…of IO happening, Not all queries are created equal – some would run for seconds,…I decided to do something about it. And because I love awk, I did that something in awk: delay=60 cmd=”mysql -e ‘show slave…1; start = $1; } speed = (delay-($1-prev))/delay; o_speed = (start-($1-passed))/passed if (speed …
Post: Here's a quick way to Foresee if Replication Slave is ever going to catch up and When!
August 29, 2012 By 11 Comments
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… similar to a replication slave that is behind. Until… that it parses by running the SELECT portion, …: demo mview_table_alias: o mview_join_condition: NULL mview_… version does not take long to refresh: mysql> call flexviews.refresh( -> …’,'COMPUTE’,'APPLY’, or ‘COMPLETE’. I specified ‘BOTH’ for the …
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…cause the slave to fall 4 hours behind. lots of undo log entries collect in the tablespace. Not only from…other terminal: while [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log…and that’s why it causes less I/O overall. I also used ‘time’ to run the Perl fifo script, and it…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…I/O going out one at a time, that are esentially reads misses (10ms each). The reads are not…I suggest that you test reorganizing that table on a separate computer, maybe a replication slave. Can you make the reorganization run…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…MySQL database the first advice usually is: – Benchmark! How should we do that benchmark? People usually run…slave of PROD or taking an xtrabackup copy just before the data capture. Important: don’t run…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
…-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 …reported bug http://bugs.mysql.com/bug.php?id=29847, with ETA MySQL-6.0 Preload … be slow due to random logical I/O. Implementing preload of full .ibd file …put load on slave which is not warmed up properly – slave may never catch up slave, but …
Comment: Living with backups
November 18, 2008 By 28 Comments
I played recently with backups while performing server upgrades… My new backup slave…running Linux-2.6.22, I had to upgrade to 2.6.27 due to a bug in CFQ: performing read I/O…MySQL replication is nearly halted. – Using CFQ with side I/O…
