… find the individual SSB query definitions in my previous blog post. Test environment These tests were done on a relatively fast machine with… has been loaded by the cold test already. The buffer pool and adaptive hash index are cold for the cold test. All tests were done with no concurrency. The hardware for this test was provided by Adotomi. I will be blogging about…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… been discussed on a previous post in our blog. Starting with 5.1, the new plugin API… general log. Bear in mind these were basic tests (just a few mysqlslap runs with increasing levels … switching between file and socket for output): plugin-load=AUDIT=libaudit_plugin.so audit_offsets=6464, 6512, 4072…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you…after failover as the buffer pool pages were loaded from disk. Replaying Queries Working with Groupon, we… a production database backup to our test database so that our test database was consistent before applying the…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
….000000 Rows_sent: 1 Rows_examined: 655360 use test; SET timestamp=1325145746; select count(*) from auto_inc;…which typically (not always) shows queries causing highest load on the server. As we can see … yes, 0% no # String: # Databases wp_blog_one (264/84%), wp_blog_tw… (36/11%)… 1 more # Hosts #…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…. The best way to run a benchmark is replaying the load of your production server against a different database server and…. DEV is where we are going to test all the changes and replay the load. Both servers should have an identical copy… the data first to warm up the buffer pool. This blog post is not a benchmark per se, just an overview…
Post: Looking for High Performance MySQL Interns
September 2, 2007 By 1 Comment
We have yet another opening at MySQL Performance Blog. We’re looking for Intern position (with limited compensation) to … Operating Systems and Hardware Performance Optimization, Performance Analysis, benchmarking and load testing plus get your name known in MySQL Community. What we…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… Shard-Query. Each image comes pre-loaded with the data used in the previous Shard-Query blog post. The data in the each image is split into 20 “shards”. This blog post will refer to an EC2 instances as a node… of input data on my i970 test machine. It is possible to distribute splitting and/or loading among multiple nodes as well…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…! Test your backups, and if you have a test environment, load them there periodically. You can also spin up an EC2 instance to load your backups onto. In addition, you can binlog rollforward 24 hours of binlogs as a good test. Store your… go through some of these in detail in a future blog post. Mydumper for logical backups Strong Points: Very fast for…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… data into multiple files (for each shard, for later loading) or it can load files directly, in parallel, to multiple hosts. Shard… was split before loading. The splitting/loading process will be described in another post. Complex queries Shard-Query was tested with the simple… a previous blog post. Previous testing was limited to a subset of Vadim’s test queries (see that post). As this new test schema…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…TABLE or CREATE INDEX. Peter has already blogged about it before, here I’ll … the secondary indexes after the data is loaded.” mysqldump in Percona Server supports the new…my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump -uroot test –innodb-optimize-keys > dump_…
