Details

0anon
Extending Index for Innodb tables can hurt performance in a surprising way
One schema optimization we often do is extending index when there are queries which can use more key part. Typically this is safe operation, unless index length increases dramatically queries which can use index can also use prefix of the new index are th...
1   Published 100+ days ago in
MySQL Performance Blog: Profile, Details
Previous: Beyond great cache hit ratio
Next article: Percona Server security fix releases

Users that voted for the article:

Similar posts

Thumb
For $4500, You Can Drive Around in a Giant Milk Carton and Cereal Bowl [Wtf]
An Oakland-based Burning Man vet...
0   Published 26 days ago in
Gizmodo, the Gadget Guide: Profile, Details
 
anon
How FLUSH TABLES WITH READ LOCK works with Innodb Tables
Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH...
0   Published 60 days ago in
MySQL Performance Blog: Profile, Details
 
Thumb
OCZ Releases Firmware Update for Octane, Increases Random Write Performance
OCZ released a firmware update for its Octane SSD series. The update carries a...
0   Published 100+ days ago in
AnandTech: Profile, Details
 
anon
Three ways that the poor man’s profiler can hurt MySQL
Over the last few years, Domas’s technique of using GDB as a profiler has...
0   Published 100+ days ago in
MySQL Performance Blog: Profile, Details
 
anon
Looking for InnoDB/XtraDB hacker
We are happy to see that Percona Server/XtraDB and XtraBackup are raising popularity...
0   Published 100+ days ago in
MySQL Performance Blog: Profile, Details
 

The word extending is found 462 times in 364 documents.
The word index is found 44566 times in 23369 documents.
The word for is found 482091 times in 135227 documents.
The word innodb is found 1927 times in 368 documents.
The word tables is found 2060 times in 990 documents.
The word can is found 133219 times in 60242 documents.
The word hurt is found 1839 times in 1291 documents.
The word performance is found 12270 times in 6322 documents.
The word in is found 684301 times in 157268 documents.
The word surprising is found 1460 times in 1281 documents.
The word way is found 44044 times in 27355 documents.

Category

Development

Тагове:

MySQL Optimizer Innodb


Your blog is missing? Add it here. Requires registration. The system is updated every hour. If you wish your site to be updated in real time, please use TopBlogLog ping service and add voting button.