… log that illustrates these best practices: /var/mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql -e ‘select @@global.long_query_time into @lqt_save; set global long_query_time=2000; select sleep(2); FLUSH LOGS…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave…_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate …_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_…l command line to run test for 10x dataset: ./bin/linkbench -D requesters=64 -D dbid=linkdb -D …
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… log coordinates and GTID information. That information is also printed by innobackupex after backup is taken: innobackupex: MySQL binlog position: filename ‘mysql-bin.000002′, position 1232, gtid_executed c777888a-b6df-11e2-a604-080027635ef5:1-4 2- Apply the logs to…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… the log copying thread which could cause XtraBackup to crash. Bug fixed #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql dependency which is required…. Percona XtraBackup would fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G on the source…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
April 17, 2013 By 12 Comments
… restart [linko@g4 ~]$ ps -ax | grep mysql 35328 pts/1 S 0:00 /bin/sh /usr/bin/mysqld_safe –defaults-file=/etc/my2… –datadir=/var/lib/mysql2 –plugin-dir=/usr/lib64/mysql/plugin –user=mysql –log-error=/var/log/mysqld2.log –open-files-limit=32768 –pid-file=/var/lib/mysql2/g4.dmz.local.pid –socket=/var/lib/mysql2/mysql…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 24, 2013 By 15 Comments
… IO because of different MySQL configuration. Make sure you’re using the same innodb_* parameters and binlog settings (log-bin, binlog-format, sync…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
…-bin.log [root@node2 mysql]# file GRA_3_3.log GRA_3_3.log: data [root@node2 mysql]# file GRA_3_3-bin.log GRA_3_3-bin.log: MySQL replication log [root@node2 mysql]# mysqlbinlog -vvv GRA_3_3-bin.log /*!40019…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… *************************** Master_Log_File: mysql-bin.000006 Read_Master_Log_Pos: 98 Relay_Log_File: mysql_sandbox20551-relay-bin.000028 Relay_Log_Pos: 235 Relay_Master_Log_File: mysql-bin.000006 Slave… until master_log_file=’mysql-bin.000007′, master_log_pos=207; slave1 > show slave status\G *************************** 1. row *************************** Master_Log_File: mysql-bin.000007 …. omitted …….. Exec_Master_Log_Pos…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… apply mysql-bin.00022 only starting from position 336796712 and skipping the DROP statement at position 336797160: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107 | +——————+———–+ 23 rows in set (0.00 sec) mysql> select count…
