… I used a 10GB key buffer. I used ALTER TABLE DISABLE KEYS and built the keys with sort via ALTER TABLE…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb…=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted security risks symbolic…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… logfile ‘/var/log/corosync.log‘ for reason: Permission…cluster has been disabled at boot… [ OK ] Checking Network Manager…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of the servers with GTIDs Let’s stop slave #2, change configuration and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… logs. Flushing tables can impact running queries. Disable MySQL slow logs during rotation Flushing logs takes time. Meanwhile, queries are still being executed. To prevent MySQL from filling the slow log buffer, we disable…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… threshold. Time-based flushing has been disabled. In this case, both systems produce…=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp…log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
…, the slow logs are disabled in the postrotate stanza. The order of operations is: 1. logrotate renames the log file. MySQL continues to write… the file. 2. logrotate runs the postrotate stanza 2a. Slow logging is paused (set global long_query_time=2000;) 2b. There… flushed (select sleep(2);) 2c. File handles are reopened (FLUSH LOGS 
2d. Slow logging resumed (set global long_query_time=@lqt_save;)
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
“To prevent MySQL from filling the slow log buffer, we disable the MySQL slow logs temporarily during log rotation.” Wouldn’t that be in the prerotate section? I don’t see one in the stanza provided.
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… on and off without restarting server until MySQL 5.0. What can you do in MySQL 5.0 and below ? Use Our… logged as slow queries (with times) and as you can change long-query-time online you can effectively enable and disable debug logging live. Note however this is not 100% equivalent for general query log – for example connects or…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… logs. General Query Log The first option is the General Query Log. Let’s see an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log…. general_log variable is dynamic so a solution could be enabling and disabling the log just when it’s needed. Error log If you…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default… in MySQL 5.5 and before it was “ON” by default with query cache size of 0 which makes it disabled. I… because Innodb was disabled for some reason was very error prone gotcha. Note this is as far as MySQL 5.6 goes…
