… time for MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL 5.6 IO… workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M…/MariaDB 5.5 This is another area of improvement in the optimizer, as it is clearly a part of the optimizer’s job…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… “amazing” and James Briggs said that “Percona did a great job.” We appreciate all the kind words, but even more than… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and better. The… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… some this is 15 minutes job for others it is many month projects. Why is that ? Performing MySQL upgrade two things should… – Upgrade of MySQL 5.0.30 to 5.0.32 is generally likely to expose less issues than 5.0.30 to 5.0.86…. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… this into a query log, and examine the log. In MySQL 5.1 and newer with the InnoDB plugin, it’s easy… port 3306 and port ${port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date +%s… for lots of short, small transactions. Don’t design batch jobs that run in loops and update data, unless you make…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
…. I would suggest you having “production requirement” of no cron jobs allowed unless they prevent themselves from started in multiple copies… using GET_LOCK function in MySQL. The second one is good if you want to serialize jobs from multiple servers (for example… example you may get an alert if CRON job which runs every 5 minutes and normally completes in 30 seconds took more…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… when you’re doing mysqldump (or running some complex batch job query) you are likely going to have multiple accesses to… MySQL 5.6 as it would offer much better “out of box” user experience. Summary As we can see in default configuration MySQL has buffer pool which can be easily washed away by large table scans or heavy batch jobs. If this…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… “%cheap rolex%”; This query will perform full table scan in MySQL 5.0 (even if there are no spam posts) which will… and run update in chunks if application allows it. In MySQL 5.1 with row level replication you will not have selection… your replication – Quite typically I see replication lagging when batch jobs are running. These can load master significantly during their run…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know there are some cases when it… long time. And every time you have some incremental job to update the aggregates, you’re exposed to that bad… can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work…
Post: Using MySQL as a Queue, and Free Percona Live Tickets
September 15, 2011 By Leave a Comment
… guest post over on the Engine Yard blog: 5 subtle ways you’re using MySQL as a queue, and why it’ll… building a good job queue or batch processing system, and try not to create one inside MySQL. Although the job queue is a… well in a relational database. However, experience shows me that job queues sneak up in unexpected ways, even if you’re…
