… statement at position 336797160: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107 | +——————+———–+ 23 rows in set…-position 336797133 mysql-bin.000022 | mysql [root@sb logs]# mysqlbinlog –verbose –base64-output=decode-rows –start-position 336797275 mysql-bin.000022 | mysql mysql…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
Comment: Can MySQL temporary tables be made safe for statement-based replication?
May 27, 2008 By 8 Comments
… events IN ‘bin-logs.000440′\G *************************** 1. row *************************** Log_name: bin-logs.000440 Pos: 4 Event_type: Format_desc Server_id: 1 End_log_pos: 98… *************************** Log_name: bin-logs.000440 Pos: 224 Event_type: Query Server_id: 1 End_log_pos: 300 Info: use `test`; BEGIN *************************** 4. row *************************** Log_name: bin-logs…
Post: Group commit and XA
May 19, 2006 By 8 Comments
… without —log-bin, with —log-bin, and with —log-bin and —innodb-support-xa=0 (default value is 1). Results (in transactions / sec) threads without —log-bin —log-bin —log-bin and… if binary logs are enabled as Innodb will need to flush its log buffer only once. So, if you are using —log-bin with…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…-logs/ibdlogs/dbtmp pid-file = /db/mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs after in…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…-logs/ibdlogs/dbtmp pid-file = /db/mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs after in…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…-networking # Replication Master Server (default) # binary logging is required for replication log-bin=db1-bin log-bin-index=db1-bin.index binlog-ignore-db=chrome_vin binlog…-port = # # binary logging – not required for slaves, but recommended #log-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path…
Comment: Using LVM for MySQL Backup and Replication Setup
August 15, 2008 By 53 Comments
… the master_log_pos (Position as returned by SHOW MASTER STATUS;) is always equal to the file size of the bin-log file… TABLES WITH READ LOCK; > SHOW MASTER STATUS; > \! ls -lart mysql-bin*|tail -n1 > UNLOCK TABLES; > MYSQL File Position Binlog_Do_DB… TABLES WITH READ LOCK; > SHOW MASTER STATUS; > \! ls -lart mysql-bin*|tail -n1 > UNLOCK TABLES; > MYSQL File Position Binlog_Do_DB…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… of the last binary log. This last file will be still overwritten hence we make a backup first. #!/bin/sh source $1… failure RESPAWN=10 Starting in the background with logging to /var/log/livebinlog/server2.log: nohup /media/binlogs/livebinlog.sh /media/binlogs/livebackup.server2.conf 2>&1 > /var/log/livebinlog/server2.log & As a great addition, older logfiles that have been…
Comment: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
Vadim, 1) Can you also show the results with no bin-log at all? Like you did here: http://www.mysqlperformanceblog.com… fix turning on bin-log resulted in over 95% performance drop. I want to see how much performance drop does bin-log cause now…
Comment: Managing Slave Lag with MySQL Replication
December 16, 2010 By 15 Comments
IYTM SQL_LOG_BIN, not SQL_BIN_LOG: http://dev.mysql.com/doc/refman/5.1/en/set-sql-log-bin.html
