… Server 5.5.27-29.0 on October 11th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.27, including all the bug fixes in it, Percona Server 5.5.27-29.0 is now… (George Ormond Lorch III). Option expire_logs_days was broken by group_commit patch introduced in Percona Server 5.5.18-23.0. Bug fixed…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… back to normal in just a few seconds. This was MySQL 5.0 running MyISAM/InnoDB mix, not heavily loaded. We used… size, new binary log is created and, if expire_logs_days is not zeroish, log files older than expire_logs_days are removed. &LOCK_log mutex is held for the duration of the binary log removal…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…and HEAP for in memory tables. So first MySQL versions did not bother naming variables with … do not support it (HEAP/MEMORY). Note in 5.0 you now have very nice value …is MyISAM related. expire_logs_days This is replication/binlogging related options – when to delete binary logs from master. It…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
… = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock [Server] server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock The problem…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…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 X days…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…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 X days…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…-bdb default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query…_size=12M server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start the…
