Question : I have a table that consists of an int primary key and text column and serving primarily in […]
Category: InnoDB
Are two indexes needed?
Question : Our MySQL database will contain an encyclopedia. The encyclopedia will be shown in pages where every page contains […]
Mariadb MySQL Tuner report confusing
Question : I’d like to ask you to clarify the report from mysqltuner regarding MariaDB database. The mysqltuner was called […]
error 1118: row size too large. utf8 innodb
Question : I have tried to find a solution guys, and I am guessing that someone has met this before. […]
Is using the alpha version of Percona 5.6 safe? [closed]
Question : As it currently stands, this question is not a good fit for our Q&A format. We expect answers […]
Issues with MySQL 8.0.17
Question : Recently we upgraded MySQL version on our UAT database server to 8.0.17 from 5.7.18. We are facing issues […]
### Innodb Related Parameters ###
Question : Answer :
Set up replication and migrate to InnoDB with low downtime
Question : Current situation is this: I have a large legacy DB using only MyISAM tables, the size of whole […]
How can I *actually* defragment my InnoDB tables?
Question : After a recommendation by mysqltuner I’ve run mysqlcheck –optimize –all-databases successfully (all of the tables reported “note : […]
MySQL using swap during conversion to InnoDB
Question : I’m trying to convert some MyISAM tables in my database to InnoDB (MySQL 5.1). The server has quite […]