… is MySQL Replication is single threaded, which means if you have any long running write query it …query. It is best to avoid INSERT … SELECT going through replication in 5.0 for many reasons (locking, long query… adjusting your sleep behavior to keep the progress fast enough and at the same time …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… slaves used for long reporting queries can have queries running for hours which stalls replication progress for this time. As MySQL Replication goes … all replication stalled. Long Queries – MySQL Replication executes queries one after another on the slave, so if you have query which takes certain …
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
…MySQL development suffered some detours and slowdowns over the last few years. This era is over. MySQL has never progressed…query analysis, replication management, and other capabilities. If you’re worried about Oracle making MySQL…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
…in our plans to create excellent free tools for MySQL administrators. There is one really big thing to …up pt-kill to kill the queries if they happen to run too long and schedule downtime in your Nagios…s clear, and then continues to Just Work. With progress reports, of course. And if you want to stop…
Post: Percona Server and XtraBackup weekly news, March 12th
March 13, 2011 By Leave a Comment
Welcome to the weekly roundup and progress report. What’s new this week in Percona Server: As … can be useful for understanding how much progress a query has made, and potentially how long until it completes. Our 5.5 release… algorithm that should further improve the quality and consistency of query response time and throughput when the disks can’t keep…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
… etc ? Could it be some of the queries currently running is using some of …using memory. It was long spoken about global resource management for MySQL, ie so I …MySQL is progressing the problem of memory allocation transparency is becoming more and more serious. There are much more objects which MySQL…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
…does and asking the question about the progress. The Single Day visits are often …, for performance review or for starting long term Remote DBA or support relationships. …, any forms of scripting, implementation (writing queries), hands on setting up MySQL, Replication, Monitoring, High Availability …
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… very simple queries both reads and writes taking long time to complete, with progress almost paused (dropping from thousands to tens of queries per… high CPU usage. Closer examination showed there were hundreds of queries stuck in the innodb queue, with innodb_thread_concurrency set… excuse to blame everything on this lock, suggest upgrading to MySQL 5.1 and call it a day. Learning more about…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
… gets bloated and slow. Even simple SELECT queries might have to scan through lots of … take a Very Long Time to do — I hate to think how long. I’m … while [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set…rows-per-second to see what the progress was. Here are some graphs. This one…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
…in that state for a long time (minutes). This comes from the fact that MySQL performs changes in memory at…affected by periodic tasks like backup or heavy background queries.) If we see that flushing to disk is …a way that makes sense. We have made good progress, and I will keep you posted on our …
