… synchronized. If we speak about backup and you can execute SHOW SLAVE STATUS command you can get reliable information about current state, but…-tools/wiki/TransactionalReplication patch and http://bugs.mysql.com/bug.php?id=34058 bug report. Basically we want to store the… available in error-log output, so you can repoint your slave to correct position by executing CHANGE MASTER command. Currently patch…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…bugs.mysql.com/bug.php?id=34058, this has…mysql-bin.000002 —round 2— show master status; +——————+———-+————–+——————+ | File | Position | Binlog_Do_DB | … error log (snipped): InnoDB: In a MySQL replication slave the last master binlog …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s … table on a separate computer, maybe a replication slave. Can you make the reorganization run in a …lookups or not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves … 2 rows in set (53.78 sec) session10 > show status like ‘Open%tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables …case where there is a reporting slave that daily runs a long running…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… see one example. We’re running a typical master-slave replication with ROW based binary log file. The application … temporary files are not visible on the EXPLAIN or SHOW STATUS output. Therefore, the best solution is to monitor your … to follow this issue: http://bugs.mysql.com/bug.php?id=66237
