One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
… all batch jobs to use Gearman MySQL UDF interface to apply update transactions to the master (but having the batch job only use… apply and pace MySQL transactions to the real master db. You can configure multiple workers for quicker batch job execution if the… 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… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M…, there is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area…, 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
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
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… using GET_LOCK function in MySQL. The second one is good if you want to serialize jobs from multiple servers (for example…
Post: Using MySQL as a Queue, and Free Percona Live Tickets
September 15, 2011 By Leave a Comment
… the Engine Yard blog: 5 subtle ways you’re using MySQL as a queue, and why it’ll bite you. Go… 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…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… can cause serve performance degradation. Configuration Changes Have you changed MySQL configuration ? OS Configuration or Hardware configuration or could have anyone… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… are ended. I’ve seen cases when overly eager batch job doing updates from 20 threads on the master will create…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data… hand instead of through the init script. Overly zealous cron jobs to delete old files in /tmp can do the same… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…
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… compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with no problems in most cases…, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even…
