Question : I have a slight problem with a table that I have converted which used to be MyISAM, I […]
Category: InnoDB
How to check innodb history list length?
Question : The output for show engine innodb status has the history list length as a number, but that output […]
MySQL innodb_row_lock_time is more than wall clock time
Question : We recently started graphing the innodb_row_lock_time status variable in our monitoring system. I noticed something I can’t understand […]
MYSQL Slow SELECT with multiple joins and ORDER BY
Question : I have this query SELECT r0_.id AS id0, r0_.deleted_at AS deleted_at1, r0_.updated_at AS updated_at2, r0_.created_at AS created_at3, r0_.is_vehicle_offer […]
How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
Question : I just switched my WordPress databases to use the InnoDB engine. When using MyISAM, I used to run […]
Recovering mysql innodb table from table.ibd backup file
Question : Just practising DB disaster recovery. As per our back up policy, we do complete disk image back ups […]
MySQL command querying all MyISAM database
Question : I would appreciate if anyone could help me of what’s the proper command in MySQL to query all […]
mysql server cannot launch in windows 7
Question : I have been using MySQL as a windows service successfully on my windows 7 machine for perhaps a […]
Optimize table and query, aggregate by date or date-hour
Question : I have a table storing sensor data (100M rows currently) from stations from different sites. In my case, […]
exit
Question : Answer :