… load from the master without falling behind I will call it replication capacity of 3. When used with context of applying binary logs… you can reply 1 hour worth of binary logs within 1 hour. I will call “replication load” the inverse of replication capacity – this… vsz # Current date: Mon Jul 19 15:12:24 2010 # Files: slow-log # Overall: 1.22M total, 1.27k unique, 558.56…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…’re running a typical master-slave replication with ROW based binary log file. The application connects to the database using persistent connection technique… files. What are those ML* files? When you run a big UPDATE, INSERT or LOAD DATA INFILE MySQL send the rows to the Binary Log Cache before writing it to the Binary Log Files. If that cache…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…the problems. As I already wrote innodb_log_file_size and innodb_buffer_pool_size affect… as many other operations, so beware. Binary log corruption – Binary log may become corrupted and out of sync…but also – warmup takes longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb does not…
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
…: Got fatal error 1236 from master when reading data from binary log: ‘log event entry exceeded max_allowed_packet; Increase max_allowed_packet… to check the binary logs of both masters. MasterA: masterA> mysqlbinlog data/mysql-bin.000004 | grep block_len #Begin_load_query: file_id: 1…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… – This means snapshot module is not loaded in your kernel by default and you need to load it, which is done by… that you should probably record binary log position which is done by running SHOW MASTER STATUS – This is binary log position you’ll need… saved binary log position: change master to master_host=”master”, master_user=”user”, master_password=”password”, master_log_file=”host-bin.000335″, master_log_pos…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…-post file that has the triggers # mysqldump … -d -t How to restore mydumper data: Load the schema file Run myloader –threads=x Load the schema-post file I will get into specifics on… be used. With mysqlbinlog 5.6, you can now pull binary logs in real time to another server using “mysqlbinlog … –read-from…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…logging (see Configuration section for details). Then rename the binary…log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow log…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… accessed, and in an ascending order of the file address, then InnoDB schedules the read of all …with the Linux kernel’s buffer pool. In high load situations where INNODB is using most of the …s group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this is …
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 29 Comments
….5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down. If the load takes 4 hours on the… probably a good idea to turn off the session’s binary log in general. But if it’s left on, the replication… imported data. If the INFILE data file is missing from the slave boxes, then the LOAD DATA command will fail silently, allowing…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… which may not be available, especially for CPU bound MySQL Load. The benefit in this case is less space requirement if… note the serious leap in compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar… which makes it easy drop in replacement. I got LZOP binary which was built against LZO 1.0, more resent version…
