id
type
5 (blog/news article)
status
21 (imported old-v2, waiting for another import)
review version
0
cleanup version
0
pending deletion
0 (-)
created at
2025-10-28 15:40:01
updated at
2025-10-28 15:40:02
pol page id
pol status
0
pol hosts ticketing
pol hosts ecommerce
pol hosts finance
pol hosts crypto
pol hosts leak
pol hosts devel
pol hosts ugc
facebook.com linkedin.com twitter.com
pol hosts klim
pol hosts builders
pol hosts self subdomains
pol hosts other subdomains
pol hosts other domains
pol updated
1763032304
url
https://katapult.io/blog/post/mysql-indexes-primer/
url length
51
url crc
28347
url crc32
1427992251
location type
1 (url matches target location, page_location is empty)
canonical status
2 (missing canonical tag in html)
canonical page id
-
domain id
domain tld
86
domain parts
0
originating warc id
-
originating url
https://data.commoncrawl.org/crawl-data/CC-MAIN-2025-33/segments/1754151280245.49/warc/CC-MAIN-20250811034648-20250811064648-00799.warc.gz
source type
11 (CommonCrawl)
server ip
Publication date
2025-08-11 05:20:22
Fetch attempts
0
Original html size
66498
Normalized and saved size
40261
title
MySQL Indexing Explained | Blog | Katapult
excerpt
content
MySQL Indexing Explained20 Jan 2015 · 6 min read · Devops & Infrastructure, TutorialsIn the time we've been assisting people with hosting their web applications, the most common reason we've seen for performance problems has been missing or incorrectly used database indexes, so we hope this simple introduction can help people get much more out of their databases. What are Indexes? Every time your web application runs a database query containing a WHERE statement, the database server's job is to look through all the rows in your table to find those that match your request. As the table grows, an increasing number of rows need to be inspected each time.Indexes solve this problem in exactly the same was as the index in a reference book, by taking data from a column in your table and storing it alphabetically in a separate location called an index. The same process can be applied to all data types, for example numeric data will be stored in numeric order and dates in date order.By doin...
author
updated
1763032304
block type
0
extracted fields
104
extracted bits
title
full content
content was extracted heuristically
detected location
0
detected language
1 (English)
category id
index version
2025110801
paywall score
0
spam phrases
0
text nonlatin
0
text cyrillic
0
text characters
5916
text words
1332
text unique words
401
text lines
1
text sentences
35
text paragraphs
1
text words per sentence
38
text matched phrases
31
text matched dictionaries
2
links self subdomains
0
links other subdomains
0
links other domains
0
links spam adult
0
links spam random
0
links spam expired
0
links ext activities
0
links ext ecommerce
0
links ext finance
0
links ext crypto
0
links ext booking
0
links ext news
0
links ext leaks
0
links ext ugc
3
links ext klim
0
links ext generic
0
image author
featured image