…how to recover a single tablespace using stock MySQL server. First, you must meet certain prerequisites to be able to…runs…knowing in advance that there are some prerequisites to comply. Percona Server relaxes a lot of limitations and is able to…
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
…to know before making changes what pt-online-schema-change will do when it runs. The tool has two options to…to see how it reveals that the tools is going to…MySQL server (privileges, etc.), or other oddities, there is a good likelihood that a dry run will reveal them. In summary: before running…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…servers are in your MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to…, whether replication is running, how far behind it …to know — if we run a checksum on the non-cloud servers, for example, we could make the cloud servers…hardy.7-log Server ID 19924124 Uptime 12…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… dropping process to run during off-peak…Server since version 5.1 has a feature know as “Lazy Drop Table” that alleviates the problem to…MySQL >= 5.5.23 work, I would like to mention quickly, that how drop table in MySQL < 5.5.23 used to…id), here space_id is the id of the tablespace corresponding to…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…How should we do that benchmark? People usually run generic benchmark tools like sysbench, tpcc or mysqlslap that are good to know…to the DEV server we can replay the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql…id = 1 AND ol_d_id = 10 AND ol_o_id < 3415 AND ol_o_id >= (3415…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…how to make MySQL replication reliable, part of which is to…Server_id: 1 End_log_pos: 271 Info: BEGIN *************************** 4. row *************************** Log_name: mysql-bin.000007 Pos: 271 Event_type: Query Server_id…
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…Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to…how long will this take? Is there a facility we can run to show any table / index fragmentation, without having to run…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…running MySQL in wild. I also wanted to share some troubleshooting techniques I use. Plot Memory Usage First I would like to see MySQL…to look at Prepared_stmt_count to see how many prepared statements are allocated on server and Com_stmt_send_long_data to…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…to traditional MySQL replication. For those who don’t know, it gives you: Fully Synchronous replication with a write latency increase equivalent to…to succeed (unless something weird happens like the disk fails or the server…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…to number of queries running will give average CPU usage per query. If you’re running Percona Server…how much does it cost to run a query. With Cloud Computing being hot a lot of Directors would like to know…
