… time to answer all of the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could Save Your Day… you run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest… the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila database Thanks to everyone who attended the MySQL webinar!
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…master_yes_txblogpercona.commanual rpl_semi_sync_slave_enabledblogpercona.commanual Rpl_semi_sync_slave_statusblogpercona.commanual rpl_semi_sync_slave…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… main MySQL branch. The MySQL at Facebook branch has a number of tests that are quite interesting. They basically create a master-slave pair… Facebook multi-threaded python load-generation code seemed very, very slow I just like the randgen (it is fun!) The tests… view the comparisons of master-slave checksums after the master has crashed and restarted: $ ./kewpie.py –suite=innodbCrash –basedir=mysql-5.5 –test-debug…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… need to know in which GTID is the master and set it on the slave. MySQL keeps two global variables with GTID numbers… MASTER TO MASTER_HOST=”127.0.0.1″, MASTER_USER=”msandbox”, MASTER_PASSWORD=”msandbox”, MASTER_PORT=18675, MASTER_AUTO_POSITION = 1; How to restore a slave in… restore a slave in a good and slow way The good way is mysqldump again. We take a dump from the master like…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… help in this case. Changing Slave Role Changing Slave role, such as swapping active and passive masters in Master-Master setup is often cause of the problem for similar reason as MySQL… traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it is easy to filter out…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely… of thumb depending on differences in master/slave configuration, their load and concurrency you …slave to run the same load through single thread. The solution in many cases is to simply space it out and slow…
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
… executed by replication thread are not being logged to the slow query log. This is not a big deal but it… query times on master and slave can be different in a lot of circumstances. One more thing to consider – slow replication queries also identify replication lag, ie if you have query which ran 10 seconds on the slave and your…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…at indexes: the workload on slaves is often not the same as on the master, so they may benefit …these spots? A good start is to enable full slow query logging (with long_query_time = 0) for … Q: Are these recommendations true of all versions of MySQL? If not which versions? The recommendations I made …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/…| 445 | | SYNC_RELAY_LOG_INFO | 0 | 10000 | | SLAVE_LOAD_TMPDIR | /mnt/data/sandboxes/msb…| | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC_MASTER_INFO | 0 |…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… – MySQL Replication executes queries one after another on the slave, so if you have query which takes certain time on the master you… being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you…
