…to see if system is IO bound or CPU bound, while to understand if MySQL goes through more rows than it needs to…to do is to flush transactional log. In case innodb_flush_log…to seek to the proper track and you need drive to rotate to the place where your data is stored to…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… up more often than it used to when all we had were rotating hard disk drives. I think … be good idea to check that page size is no bigger than stripe element; second – logs are actually … address to physical address (at a certain level) so when writing a file, file system decides how to distribute …
Comment: How to calculate a good InnoDB log file size
November 23, 2008 By 33 Comments
… it in such depth — I usually just log on to the system and see how often the log rotates — for instance, just now here’s a sample from a production machine: /var/lib/mysql… lasts 1 hour and the log rotates approximately every 2 hours, I probably don’t want to cut the log file size in 1…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… this setting. First I should wonder how common this problem is outside of Dell … might need to do something such as getting Slave out of rotation when it …MySQL 5.5. Note it might also be good to increase innodb_write_io_threads to … out of sync with Innodb transaction logs. I’m also wondering if this…
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
…% 3. It is unfair to compare two nodes system to single node, so let’s see how regular MySQL replication performs there. So we… there two things to consider: You see quite periodic drops for MySQL replication, I think it is related to binary logs rotation And, second, much more serious problem: After 1800 sec of run, slave in regular MySQL replication was…
