…, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the log stream across log rotation events. On the standby server, the logs are…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…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 18 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 38 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: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
… good opportunity to re-examine how we could provide slow query log type functionality to our users. The slow query log code inside the MySQL server…. My solution to log file rotation is to basically count how many people may be using it and waiting until this drops to zero before closing…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… rotation without and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to…log. Now lets see how Synchronous Replication solutions such a Percona XtraDB Cluster and MySQL Cluster are different. Synchronous replication essentially allows you to…
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…
