…MySQL…relay_logblogpercona.commanual relay_log_indexblogpercona.commanual relay_log_info_fileblogpercona.commanual relay_log_purgeblogpercona.commanual relay_log_recoveryblogpercona.commanual relay_log…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/nfs/dist/5.6.10/lib/plugin/ | | SYNC_RELAY_LOG | 0 | 10000 | | GENERAL_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30/data…:autoextend | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
…’s or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay log, you will be…’ on this slave. This is relay relay log corruption and you can check details in the MySQL Error log file. The error message describes few… OK, 0 rows affected (0.00 sec) This will purge existing relay logs re-fetch all events which have not been executed yet…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_…log-buffer-size=32M innodb-log-file-size=128M innodb-open-files=1000 innodb_fast_checksum innodb-purge… innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-…
Comment: MySQL Replication vs DRBD Battles
May 1, 2008 By 12 Comments
…+ pending IO from insert buffer + pending IO for purge thread). When the max is exceeded the …HA solution with MySQL. It also includes a feature to keep the InnoDB transaction log and slave …– the IO thread would copy events into the relay log and the mirrored binlog. It allows hierarchical …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If…Here is why: List of rarely considered MySQL Server Memory Requirements Thread buffers can…per connection. So you can’t relay on global values if developers may…start is stored. It is never purged and may be large if you…
