What is often underestimated is impact of MySQL Performance by complex queries on large data … IO schedulers should be better with this. So what can you do about it ? Do reporting on the slave Doing reporting on the slave is…. In some environments which do not run 24/7 this is great solution as there is no one to suffer at certain times…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…what is now my newest Firefox toolbar bookmark: an option and variable reference for all three sites in one! abort_slave….commanual innodb_read_ahead_thresholdblogpercona.commanual innodb_read_io_threadsblogpercona.commanual innodb_replication_delayblogpercona.commanual innodb_rollback_…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable transactions the log write latency is triple… outstanding IO requests which is needed to utilize SAN efficiently. It is especially problem if you’re running replication Slave as slave thread will issue single IO…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…runs too slow (and affects other transaction) and may be increasing memory is helpful to solve this problem. If it is IO bound (high IO…problems. So what if we have very IO bound application without serialization issues (say reporting slave) which is very IO bound showing 100% IO subsystem …
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
…what is going on and hit the button to initiate failover. Lets say automated failover is…Slave but never fail back without manual intervention. We also will failover only when replication is caught up (wait for slave…is result. Running…
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
…by the customer every time this happens is this: When is the replica going to catch up?” I…s a lot of IO happening, Not all queries are created equal – some would run for seconds, while…run nightly tasks like building statistics tables or table checksum – these are usually very intense and cause slave…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_LOG_INFO | 0 | 10000 | | SLAVE_LOAD_TMPDIR…IO bound workloads. Most users will not be affected though as innodb_thread_concurrency is 0 by default so this queuing feature is…what is the purpose of this change but it is…is now ON by default. This is very big change and is good one. We have been running…
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
… some time the SHOW SLAVE STATUS on MasterA gives us this output: Last_IO_Error: Got fatal error…id is not enabled 
What is the relation between read_buffer_size and this bug? Again, an example is best…read_buffer_size = 16M We run the LOAD DATA INFILE again and now this is the output on both …
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is…run our of CPU itself, if it is…What is about compression tool ? The classical tool used for backup compression is gzip – it exists almost everywhere, it is…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… rate the server allows, given it’s IO system It can typically execute a backup …frm files. Enable –slave-info when backing up from a slave so you know what the position you …run this): Ensure it stays running, restart it if it appears to be hanging Verify the file is the same on master and slave…
