…we can run out of space. Let’s see one example. We’re running a typical master-slave replication …is not really empty: # df -h [...] /dev/loop0 985M 961M 0 100% /tmp Lets see which files has MySQL opened:…the performance improvement as it uses disk I/O anyway. Ramfs will not swap, and also ramfs will …
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…is about twice as fast while MySQL replication is nearly halted. – Using CFQ with side I/O…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…replication down. If the load takes 4 hours on the master, it will cause the slave… or 12 hours. InnoDB is not optimized for rollbacks, … /tmp/my-fifo ]; do time mysql -e “set foreign_key…is actually the larger file. It has fewer rows and that’s why it causes less I/O overall. I also used ‘time’ to run…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…applications (of which Mysql is the main …I/O going out one at a time, that are esentially reads misses (10ms each). The reads are not excactly sequential, there is…replication slave. Can you make the reorganization run in a tolerable time? PZ: Indeed using master-master setup and switching roles is…
