…mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the log stream across log rotation events. On the standby server…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…backup impact on server performance may well be). We also assume backup is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup…all archivers it is possible to use parallel compression to get…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all…get much faster during the repeat runs, compared to the initial cold run. I stopped the MySQL 5.6 server…hot pages from the buffer pool often for an infrequent scan, like a backup…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup while your application is running. No need to shut down server…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…MySQL Cluster, which is more special-purpose, this is probably the best general-purpose way to get…to get good performance after a failover. You need to use some technique to mirror the read-only workload to the passive server…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… to get the “snapshot” – shutting down MySQL Server and copying data, using LVM, Using Innodb Hot Backup Tool, Using another Slave, using backup image etc but in all the cases you have to…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…get to deal with recovering tables on the crash or partially executed statements. Table locks is no more problem, hot backups…servers. It is important the team understands Innodb and knows how to handle it, or be able to learn it. It is also important to…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…to spare. We’re using Percona Server…mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock prepare Running Sysbench and MySQLDump. Note we run them in the loop to see how…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…to work. Get the log file which will include all queries MySQL server ran with their times and run mk-query-digest with filter to…how fast do you need to be able to recover from backups and how…
