…QUERY_NUMBER}. In general, each flight examines … is tested again without restarting the database. The…ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… in MySQL on profuction server for various debugging needs. Unfortunately you can’t switch it on and off without restarting server until MySQL 5.0. What can you do in MySQL 5.0 and below ? Use… for general query log – for example connects or queries with syntax errors will not be logged. Enable logging to /dev/null You can enable queries to…
Comment: Be careful rotating MySQL logs
December 10, 2007 By 7 Comments
… MySQL 5.0 you can’t enable/disable general query log without restarts so if you may need it sometimes and you can’t afford server restarts you just need to have it enabled…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…enable logging queries which do not use indexes even if they take less time (–log-queries-not-using-indexes) Slow query log…with recent MySQL version. Now why do not we use general log instead ? Unfortunately general logs … you can change long_query_time without restarting server so it is easy …
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
… this patch to benchmark our production server: First, I enabled the general query log in my production server, and collected some data. I… turn off the general query log without restarting mysql – i moved the log file aside, touched a replacement, but didn’t give the mysql user write permision…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…MySQL configuration ? OS Configuration or Hardware configuration or could have anyone changed it without…general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log… cause performance problems. MySQL Restart MySQL Restarts may include …
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
…mysql cli). Oh and mind it is not a general…without restarting the application? Here’s the trick: [percona@sandbox msb_5_0_87]$ gdb -p $(cat data/mysql_sandbox5087.pid) \ -ex “set max_connections=5000″ -batch [Thread debugging using libthread_db enabled…
