Question : I really need some mysql expertize. I am a newbi to mysql and I am seeing some server […]
MySQL – Delete with IN Clause taking more time
Question : In MySQL 5.6 I have around 60 million rows. I wanted to remove rows based on Id. Here […]
Is ANALYZE useful immediately after creating an InnoDB index?
Question : Let’s create a new index on an existing table: CREATE INDEX `IDX_some_index` ON `some_table` (`a_column`, `another_column`); Is this […]
InnoDB page_cleaner error message: The settings might not be optimal
Question : My server is in idle state but I often get this error: Note: InnoDB: page_cleaner: 1000ms intended loop […]
Alternative ways to find tables with specific storage engine?
Question : I have a VPS with three accounts and 5 db’s. Recently I added MySQLTuner. All of my tables […]
Mysql error while creating FK
Question : here is structure of both tables category table CREATE TABLE category ( `catID` bigint(20) NOT NULL AUTO_INCREMENT, `title` […]
Why does innodb_flush_method = O_DSYNC provide such a performance boost with SAN-backed storage?
Question : I’ve seen some people suggest that O_DSYNC should be used with a SAN. The MySQL docs have this […]
Mysql database slow responding to connects when having only few concurrent connections
Question : We have a database setup with in master/slave. It runs innodb and its on a 8 core with […]
How to optimize MySQL for large BLOB updates
Question : I have a table that holds large BLOBs (up to 10M), and is updated frequently. The problem is […]
Fastest way to create local copy of live InnoDB MySQL database?
Question : We have a MySQL database (InnoDB) on our live Ubuntu 12.04 server which has grown quite large (25gb+). […]