…to have the same set of storage engines or default paths): (garfield:~/work) % env VISUAL=/bin…. The process should end with no errors and message like this one:…writes to slow log to only those from every (1/log_slow_rate_limit) session. With high traffic coming to your database, the slow logging…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… if there were no good ideas how to make XA to work with …to have innodb_flush_logs_at_trx_commit=1 so transactions are truly durable. You have to have log-bin enabled to…log writes and fsyncs per second which matches your hard drive capacity. Plus you would normally see single outstanding log write…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107 | …writing this blog I hacked a quick shell script to create snapshots and uploaded it here. By no…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… you have no way to change. …bin/sh /usr/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log…write something instructional to the client about it. Preparing to report findings I should mention here a bit about how I write the report to…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…logging is required for replication log-bin=db1-bin log-bin-index=db1-bin…logging – not required for slaves, but recommended #log-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to…write…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…to correct binary log position. There are two sources of information for binary log position SHOW MASTER STATUS – this shows position as master writes… leaves no room for mistakes: mysql> show master status \G *************************** 1. row *************************** File: db04-bin.000068 …
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… are written to the binary log. They are called binary log events. A binary log event …no direct writes to the passive master during the process. As I mentioned before, if both your masters receive writes…# mysqlbinlog mysql-relay-bin.000x | grep ‘id 2′ | sort | uniq Special thanks to Kenny[5] …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… you’re only going to read data anyway, but in reality read-write snapshots have number of benefits. First no extra handling is… MASTER TO to point slave to saved binary log position: change master to master_host=”master”, master_user=”user”, master_password=”password”, master_log_file=”host-bin…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…have to be both sure your application(s) only write to default database and everyone who has access to …not offer any enforcements – ie there is no way to forbid updating not default database so you …to filter writes on the Master is of course manual filtering – using SET SQL_LOG_BIN=0 if you need to…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
… “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load …logged it to a file; I also captured the output of “mysqladmin ext -ri5 | grep Handler_write” and logged that to a file. To…to log the “cool-down period” after the load ended. It would be fun to see that. Cacti seemed to show no…
