…to complete. Here is example how it can look: mysql> show processlist; …backup or kill long running SELECT queries to let backup to proceed, but resolving server gridlock one way or another…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
…MySQL you cannot move your ibd files freely from one server to another or from one database to another…how to recover a single tablespace using stock MySQL server. First, you must meet certain prerequisites to be able to…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…backup strategies can fail to delete snapshots after finishing, sometimes due to the backup…server will continue to function, however, because the file isn’t really deleted. The MySQL server keeps an open filehandle to…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…backup or the backup restore process doesn’t work. How can I recover deleted rows? We’re going to…Server has some extra tables in INFORMATION_SCHEMA that can help us to find the different indexes and types. mysql…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
… your SELECT queries against multiple MySQL servers and reports on how each type of query performs from every server you let it test on… upgraded to your target version and let it replicate until such time you are ready to test. Another is populating spare servers from backup and…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…how much the slaves were behind the master when the outage occurred. So, if you want to… schema changes Low impact backups Automatic failover with replication …MySQL servers lags behind too much, its read VIP will be moved to another server. As a conclusion, replication can be used in many cases to…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… to them are actually slower than to a mechanical disk. I do not know how …server for Mysql you will still need some memory for the OS and the various stuff that will be running (monitoring, backup… tests, removing one bottleneck moves the contention to another place. Thus, no general rules can be…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…how we can get a word out where and how to generate leads. In fact we did not have to… indexes and tuning MySQL Server settings. It is more the question of knowing there to change things…to secure MySQL setting up backup policy and monitoring and make sure it is running healthy in general. Yet another…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online non-blocking backups…to look at MySQL Assuming I don’t see anything noteworthy here, I’ll move on to the MySQL server…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to fix them. An infinite replication loop… ? You restore a backup from another machine and you forget to change the server-id in my.cnf. You change the server-id interactively, this…
