…find out what the cause is some batch jobs, reports and other non response time critical …know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware,… It also often helps with monopolizing replication thread. For example if I need to delete old …
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
Another option for using a dedicated slave is to write all batch jobs to use Gearman MySQL UDF interface to apply update transactions… to apply and pace MySQL transactions to the real master db. You can configure multiple workers for quicker batch job execution if the… better yet, you could use Percona MySQL Cluster to have a dedicated master for all batch job processing and use Gearman Workers to…
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… give special recognition to Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking… conference such a success for everyone. Our goal for future conferences remains the same as always: to help the MySQL ecosystem continue to…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… 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… (this is the query time for MySQL 5.5) While when it sticks to plan ‘b’ for MySQL 5.6 and MariaDB 5.5…, 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
… have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take… on which range condition is applied cannot be used for filtering records. For example, suppose you have a key defined as: KEY…
Post: Schedule for MySQL Conference 2012 is Published
January 25, 2012 By 3 Comments
… schedule for Percona Live: MySQL Conference And Expo 2012 is now published. This is truly great selection of talks with something for MySQL Developers, DBAs, Managers, people just starting to use MySQL as well as looking for advanced topics. We have talks about running MySQL… a great job getting the schedule together. I can’t thank them enough ! See you in April in Santa Clara for MySQL Conference…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… our MySQL Support customers ask is Replication Lag. The story is typically along the lines everything is same as before and for… Master-Master setup is often cause of the problem for similar reason as MySQL Restart – the traffic on different boxes might be… of problems but more subtle things such as “small” batch job being ran which does a lot of updates can also…
Post: Percona Launches New Support Option for MySQL
October 5, 2010 By 9 Comments
… offering for MySQL. There’s a press release here, and product information page here. But what does this new service really mean for…. Just MySQL, MariaDB, Percona Server with XtraDB, and Percona XtraBackup. Focusing makes it easier for us to do a good job for you. Why… that makes sense. There is a vacuum in the market for MySQL support, and we want to help serve that need.
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… different “depth”. For some this is 15 minutes job for others it is many month projects. Why is that ? Performing MySQL upgrade two things… DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even if it is… you want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave with new version…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
… MySQL. The second one is good if you want to serialize jobs from multiple servers (for example you specially put script in CRON job on 2 servers for High Availability Purposes… stderr) you can catch when problems start to happen – for example if job failed to run because other one is running which…
