Question : I’m trying to decide whether to normalize a thing further, and need to know what the smallest a […]
Category: InnoDB
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 […]
What is the size of currently-existing tmp tables in innodb?
Question : This is yet another “how to add a column to a gigantic table” question. The table on disk […]
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 […]
Adding multiple foreign keys to single table
Question : I’m trying to add multiple foreign keys to the same table; however, the error code 1215: Cannot add […]
Why are tiny Innodb row updates causing so much disk IO?
Question : This is a followup question to my earlier How can I determine which Innodb table is being written? […]
Mysql warning: InnoDB: Ignoring tablespace `foo`.`bar` because the DISCARD flag is set
Question : Whenever my MySQL 5.7 starts I get the warning InnoDB: Ignoring tablespace `foo`.`bar` because the DISCARD flag is […]
MySQL client goes down after using setPrimaryInstance() in InnoDB clustering, but the cluster remains up with all nodes functioning
Question : So, I have a cluster of 3 nodes, each in a different data center located in the same […]