…MySQL manual, especially the option…Slave_open_temp_tablesblogpercona.commanual Slave_received_heartbeatsblogpercona.commanual Slave_retried_transactionsblogpercona.commanual Slave_runningblogpercona.commanual slave_skip_errorsblogpercona.commanual slave_transaction_retriesblogpercona.commanual slave…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…Slave to make another one you need to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave…Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 744615652 Relay_Log_Space…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so …well. This especially applies to reads issued to Slaves – because these are potentially lagging we can’…propagate sometime. For example if I’m maintaining counter I may not want changing that to …
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… replication, especially as it has to serialize transactions on the slave which could be executed in parallel on the master. So… in this case ? First separate them into special counter table, having say “id” and “counter” columns. Using separate table for updates already…-time counters very efficiently pushing few updates back to MySQL server. If you rather use existing solutions you can use memcache + another mysql…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… to skip the statements by stopping the slave, set global SQL_SLAVE_SKIP_COUNTER and start the slave again. This method is not really… the wrong server-id are performed on the two slaves (mysql 3 and mysql 4) and the new events (with server-id 1…] http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql.com/doc…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH… need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL Server to continue, which… slave from the slave also clones inconsistences in data which slave could have accomulated – especially if you use slave_skip_errors or sql_slave_skip_counter…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any… behavior with the new parameter –log-slow-slave-statements. THE DETAILED INFORMATION ABOUT QUERY EXECUTION…_distinct: 20 InnoDB_IO_r_ops is the counter for the number of page read operations scheduled…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… from the start but rather take the difference in these counters every 5 minutes or other interval of your choice. 2… and log_slave_slow_statements=1 for this method to work. Get the log file which will include all queries MySQL server… should work with original MySQL Server in theory, though I have not tested it. Some versions had log_slave_slow_statements unreliable…
Comment: Estimating Replication Capacity
January 16, 2012 By 4 Comments
I’m trying to estimate the slave load using the UserStats method. But it doesn’t reflect … replication? My testcase: STOP SLAVE SQL_THREAD; SELECT SLEEP(600); START SLAVE; Then i watch the counters while the slave is catching up, but… in 5 minutes while the slave is working. I see really high CPU utilization in htop for mysql, so it’s really…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
…4 hours on the master, it will cause the slave to fall 4 hours behind. lots of undo …other terminal: while [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log…actually show both files being loaded. It might seem counter-intuitive, but the second (smaller) curve is actually the…
