… and log_slave_slow_statements=1 for this method to work. Get the log file which will include all queries MySQL server ran… should work with original MySQL Server in theory, though I have not tested it. Some versions had log_slave_slow_statements unreliable and… it is less than 1, so the master writes more binary logs than slave can process they will show number close to…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_master‘, ’0′ ‘Com_show_open_tables’, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave…=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…/backup 6) Copy data to backup. Normally you can skip slow query logs and error log while taking backup. You also… to the slave database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use CHANGE MASTER TO to point slave to saved binary log position: change master to master…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…command line option innodb_changed_pages_limit. MySQL option handling would then shadow the former…1105726 (Laurynas Biveinis). Time in slow query log was displayed incorrectly when slow_query_log_timestamp_…only on slave server while there are updates on the replicated table on the master which…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… MySQL Replication you have to have one Master node which handles traffic. You may be able to send some traffic to Slaves but… in MySQL 5.5 does not solves these problems. It helps to ensure the slave can be cought up to the master without… in case of MySQL Replication is handled by cluster internally – for example if timeouts are reconfigured the transient network slowness can be…
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
… a replication slave that is severely behind, you probably noticed that it’s not catching up with a busy master at a… replication slave is built from a backup which is normally hours behind, or, it could be that replication slave became too slow to… that something in awk: delay=60 cmd=”mysql -e ‘show slave status\G’ | grep Seconds_Behind_Master | awk ‘{print \$2}’” while sleep $delay; do…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… with loosing data etc. Read more in my > Why MySQL Could be slow with Large Tables article. Deciding whether or not to… from a master to a slave, there is no reason why you can’t remove the foreign key references on the slave(s… changes are being made on the master and all those changes are making it to the slave(s). Like any other decision…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
…: sysbench –test=oltp –oltp-table-size=10000000 –db-driver=mysql –mysql-user=root –mysql-db=sbsmall –init-rng=1 –max-requests=100000000 –max… on Master will be high even with replication running, but it will slow down as soon as IO thread on the slave is caught up with master. When I moved the…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… at onces, which typically make system extremely slow and also can use up all allowed …internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 sync_…vulnerable. master.info corruption – If slave happens to crash you can also have relay logs corruption and master….
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…(keeping data smaller) or can a bit slow it down. Plus there were bunch of… slave. Can you make the reorganization run in a tolerable time? PZ: Indeed using master-master setup and switching roles is a good way to get large data manageable. MySQL Master Master Manager…
