Question : I have a database which is in InnoDB, because I wanted consistency (cascading delete). Now, I want to […]
Tag: myisam
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 […]
Table metadata lock MariaDB
Question : I’m having serious problems in a DB, where a “Waiting for table level lock” box is loitering and […]
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 […]
Database Tuning Issues
Question : I’m not a DBA so looking for some advice on tuning a MySQL (MyISAM) database. I’ve found that […]
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 […]
MySQL: OPTIMIZE after TRUNCATE?
Question : Using MySQL (either InnoDB or MyISAM tables–I have both), if I TRUNCATE a table and then LOAD DATA […]
Issues converting MyISAM table to InnoDB (auto column issue)
Question : I’m having issues trying to convert a table from MyISAM to InnoDB in MySQL 5.6. The following is […]
Should I create a multi-column UNIQUE index?
Question : I have created the following MySQL table, which stores which sections of our site a user visited (and […]
MySQL select by primary key against 100M of records within 30ms
Question : I have no expirience with MySQL and database performance tuning in general. Wondering whether it is possible to […]