… Available) stable release in the 2.0 series. New Features: This version of… from abstract mysql to real /usr/bin/mysql file, because rpm packages from…logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
….cnf [...] master-user=rsandbox master-password=rsandbox master-host=127.0.0.1 master-port=35301 [...] Let’s disconnect the slave: mysql… Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] Connection settings…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…0.7 has been published with support for …bin.000002′, position 1232, gtid_executed c777888a-b6df-11e2-a604-080027635ef5:1-4 2- Apply the logs to the backup: # innobackupex –apply-log… Slave_SQL_Running: Yes [...] Retrieved_Gtid_Set: c777888a-b6df-11e2-a604-080027635ef5:5 Executed_Gtid_Set: c777888a…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… frequently cause replication lag spikes as well. Locks – MySQL Replication SQL Thread executes queries same as any other thread and it… on Master-Master setup do not forget to disable binary logging with SET SQL_BIN_LOG=0 before you run ALTER TABLE query. Replication Overload Many… time of queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
…-bin.log GRA_3_3-bin.log: MySQL replication log [root@node2 mysql]# mysqlbinlog -vvv GRA_3_3-bin.log /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET… error log for the corresponding error message (we know at what time to check): 121129 23:28:54 [ERROR] Slave SQL: Could…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… (GPL) 080626 0:06:20 [Note] Slave SQL thread initialized, starting replication in log ‘bin.000025′ at position 12501137, relay log ‘/var/log/mysql/relay.000088… = 20M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… set of storage engines or default paths): (garfield:~/work) % env VISUAL=/bin/cat …sql/log_event.cc patching file sql/my_time.c patching file sql/mysql_priv.h patching file sql/mysqld.cc patching file sql/set…environment. (garfield:~/work/mysql-5.0.51a) % ./configure ‘–disable-shared’ ‘–with-server…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… 4GB file in one chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘infile.txt’ into… /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘/tmp/my-fifo’ into…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…logs‘, ‘0‘ ‘Com_show_master_status’, ’105′ ‘Com_show_ndb_status’, ‘0‘ ‘Com_show_new_master’, ‘0‘ ‘Com_show_open_tables’, ‘0‘ ‘Com_show_privileges’, ‘0…log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… of course manual filtering – using SET SQL_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires SUPER Privilege and… math of dealing with binary log positions. For example cloning Master (and dropping not replicated tables) to set up replication becomes more…
