Question : This question is cross posted here from stack overflow at the suggestion of stack overflow commenters (https://stackoverflow.com/questions/47086329/percona-mysql-table-does-not-exist-after-innobackupex-restore-on-vagrant-ubuntu) I […]
Tag: percona
What variable(s) to look to maintain MySQL speed of scanning through all database tables while it starts?
Question : We have few thousand small databases with total .ibd files of about 800000. We noticed that MySQL takes […]
MySQL Handler_read_rnd_next == tablescans without indexes?
Question : I am in the process of tuning our Percona 5.5 server, and have been using percona’s tools to […]
Percona xtrabackup Prepare Fails
Question : I made a backup and according to Percona it completed successfully. Now I’m trying to prepare it and […]
Should a MySQL replication slave be set to read only?
Question : I’ve got replication running on Percona Server 5.5 by following this guide and wondered if I should add […]
Optimization causes tmpdir to fill up with ‘deleted’ file handle
Question : Using Percona 5.6.34-79.1. Storage Engine is InnoDB. One of the table to be optimized is 300Gb in size. […]
Fixing tables out of sync as reported by pt-table-checksum, pt-table-sync is not working
Question : I have several tables being reported by pt-table-checksum with CRC_DIFF between my master and slave servers using the […]
Upgrading to MySQL 5.6, benefits to switching to GTID replication?
Question : We have the most basic of MySQL replication setups, a single Master doing statement-based replication to a single […]
MySQL: How to find MySQL 5.1 (with built-in InnoDB) or MySQL 5.1 (with InnoDB-plugin)?
Question : My DB server has MySQL 5.1.58-community-log and I am planning to upgrade it to MySQL 5.6 with specific […]
what is MDL? (e.g. ‘MDL semantics’ or ‘MDL locks’) Probably Galera related
Question : I found a guy talking about MDL semantics in a Galera/XtraDB bug report. What is MDL? The term […]