Question : I’ve recently made an upgrade to a mysql query performed by my web server when serving request. There […]
Category: InnoDB
Is the overhead of frequent query cache invalidation ever worth it?
Question : I’m currently working on a MySQL database where we are seeing a large number of invalidations from the […]
How mysql (innodb) handles auto increment column
Question : I am working on a OLTP environment with multiple parallel write operation. I found this in documentation about […]
Restored database copy larger than original
Question : I’ve created a copy of a database for testing. It’s on the same server as the original. However, […]
Unable to drop the table since its showing waiting for meta data lock
Question : We are trying to drop one table but it’s getting hanged, and when we see the ‘SHOW PROCESSLIST’ […]
Speeding up SELECT FROM a large table
Question : I have a large table (500M rows with ibd size of 1.5TB) CREATE TABLE t1 ( ID int(11) […]
In MySQL, when using InnoDB, what happens to the way data is laid out on disk when the primary key is dropped?
Question : In MySQL, when using InnoDB, what happens to the way data is laid out on disk when the […]
InnoDB row metadata size (minimum row size)
Question : I’m trying to decide whether to normalize a thing further, and need to know what the smallest a […]
What storage engine do I need – Mysql?
Question : I have designed a database and came to the point of actually deciding which storage engine is better […]
Why is this simple join taking so long?
Question : I’m trying to run some reporting queries on a MySQL database, and I’m running into serious performance issues […]