… them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading…
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
… for using a dedicated slave is to write all batch jobs to use Gearman MySQL UDF interface to apply update transactions to the master (but having the batch job only use the slave connection). You only need to implement… MySQL Cluster to have a dedicated master for all batch job processing and use Gearman Workers to apply updates to this…
Comment: Joining many tables in MySQL - optimizer_search_depth
May 12, 2012 By 6 Comments
… inefficiencies of the optimizer, that should be doing a good job in the first place. In addition, hints need to be…
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…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…, as it is clearly a part of the optimizer’s job to select the best query execution plan. I had noted…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Comment: Btw xtrabackup is not only backup..
March 7, 2012 By 12 Comments
… software that we spend literally hours developing. A pretty thankless job, all told, and when you start throwing F-Bombs around…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
tobi, Thanks, yes, I was playing with set 90-95-99% response times. You know at some point you are getting too much data, much more than you can analyze in sane amount of time, that becomes full-time job. So for now I decided to keep it simplier.
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
… recently I have found about 80 copies of same cron job running hammering the database. This number is rather extreme typically…. I would suggest you having “production requirement” of no cron jobs allowed unless they prevent themselves from started in multiple copies… multiple servers (for example you specially put script in CRON job on 2 servers for High Availability Purposes). It is also…
Post: MySQL Geek Job Openings
May 24, 2007 By Leave a Comment
The consulting load keeps increasing so we’re looking for some help. This job would be perfect for someone interested in high performance and scaling with decent knowledge of MySQL and eagerness to learn more. We do encourage people from all countries to apply.
