…may be open or closed. Furthermore besides MySQL table_cache Innodb maintains its own (…from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… InnoDB: Doing recovery: scanned up to log… the list. I guess Heikki knows how to implement LRU in …
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…to restore the replication using CHANGE MASTER TO statement. It is very important to understand the difference between IO Thread position in Master logs (Master_Log… TO accepts Master_Log_File parameter, while you actually want to use Relay_Master_Log_File instead. This naming was left from pre MySQL…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…able to do atomic snapshot of many volumes. Lets speak a bit about how LVM …log position you’ll need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL Server to…of recovery from the backup you will need to restore slaves as well and skip binary logs …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…+hours to feel 200GB buffer pool. Automatic Buffer Pool Save/Restore available…Thread in slow query log so it is easy to filter out events)…to check the types and frequencies of queries but also how much IO they are causing and how… to see it by comparing IO MySQL is doing to IO going to devices from …
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…how to use diagnostic tools in Linux. Investigate database trends via the counters exposed in MySQL‘s SHOW GLOBAL STATUS. Backup & restore MySQL…to read diagnostic information from InnoDB and make informed decisions while changing configuration. Discover how…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…to a ping RTT to the furthest node Automatic cluster synchronization, both incremental and full restores The ability to…Galera is how multi-node… undo log entries 1 MySQL …mysql> commit; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction node1 mysql> select * from…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…file size. Though in this example we used MySQL binary log file which often contains plenty of similar…read speed from archive media and 276MB/sec write speed to the hard drive – this means restoring from backup …. UPDATE: It looks like people are wondering how BZIP2 compares so I should check it …
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…to authorize some communications for the security group. I’ll authorize 3306/tcp (MySQL) from hamysql, 694/udp (Heartbeat) from hamysql and 22 (SSH) from…to restore the service. The “initdead” is just a startup delay to allow host to…how to…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…how to handle it, or be able to learn it. It is also important to adjust processes as required to work with Innodb. For example binary copy of one of the databases from the Slave to…to do restore…MySQL server…logging. Innodb Needs Tuning As a final note about MyISAM to…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… the slave and need it to catch up or when restoring from backup, the loaded replication capacity …log_slave_slow_statements=1 for this method to work. Get the log file which will include all queries MySQL… many things including how fast do you need to be able to recover from backups and how much your…
