… was selecting from MySQL table. Query vas very simple – lookup by primary cache, so this is kind of peak performance MySQL can provide… and how we can use them for MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than… be about using these caches for your application ? Cache per script data in associative array. If you have some data read…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…. A variety of problems can delete MySQL‘s PID file, such as a buggy init script that attempts to start the server… missing, then many init scripts will behave very badly. Sample problems include starting two instances of MySQL on the same files in… in that list, there are several others that can be performed with existing plugins, so there was no need to write…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… on MySQL Performance the scope of our work proved to be much larger. We handle a lot of architecture design for MySQL and… performance optimization, replication and high availability, scaling, writing whitepapers, helping people with data recoveries, implement MySQL patches and do some general script coding… we work on Sphinx Search as well as bunch of MySQL related scripts. As a summary we have 70+ hours of work…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… so the purge begins. The tests were performed on Percona’s R900 machine. The scripts and results are on Benchmark Wiki and… to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important… I am sure that next MySQL 5.6 versions will contain a fixed and much better performing implementation, which I am looking…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… it. Then I run the following: wget http://hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/slow.log By…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… this done, being pretty bad for MySQL Performance and concurrency ? The reason is – replication. In MySQL before 5.1 replication is statement based… to see how well it performs 
One more thing to keep into account – INSERT … SELECT actually performs read in locking mode and… back (it has to be done outside of MySQL Server) as otherwise the script will fail second time. If you need result…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… write-through mode which can cause serve performance degradation. Configuration Changes Have you changed MySQL configuration ? OS Configuration or Hardware configuration or… good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the… events in the replication traffic. An interesting thing to note – scripts can hurt replication traffic well after they are ended. I…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… XtraDB storage engine. Support for multi-threaded slaves. Using custom scripts for node propagation. RSYNC method comes with the Galera distribution… much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am going to run…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
My previous benchmark on Performance Schema was mainly in memory workload and against single tables. … ) and buffer pool 30G. The scripts and results are on Benchmark Wiki. If we look on performance overhead it appears rather big… we are able to get from performance schema tables. 1. table_io_waits_summary_by_table mysql> select * from table_io_waits…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… have the best peak performance, but also stable and predictable performance. I refer you to Peter’s post, Performance Optimization and Six Sigma… the default values. The raw results, full config files, and scripts are in our Benchmarks Wiki. The graphical result below shows… fix the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we set innodb_buffer…
