… in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log,… and this is what the McAffee plugin does. Installation and configuration are straightforward following the …users for which you do not want events written to the log. Just for reference, these…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… replication is not lagging. Unfortunately, that’s often not sufficient for failover during peak traffic. The standby server does not process query …handling massive slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except …
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… index the table I get the following record in the slow query log: # Time: 120911 17:18:05 # User@Host: root[root… but because the access type to the tables is “const” MySQL does not count it as access to two tables. In case of… there is no ways to simply optimize it. This method does not only provide you with “yes or no” answer but rather…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
…_log_file_size), MySQL 5.5.10 with innodb_adaptive_flushing=ON (default)). The problem here is that the system has quite slow… with a broken foot, right ?) And actually it does not work, as MySQL is not able to keep the number of dirty pages within… time (and that is an important factor with slow disks); and 3) MySQL does not support innodb_log_file_size > 4GB (it is supported in…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…case. Metadata Locking and Query Cache How does metadata locking behave with query_cache? …000005 | | sending cached result to clien | 0.000011 | | logging slow query | 0.000002 | | cleaning up | 0.000002 | …int(11) not null auto_increment primary key) ENGINE=InnoDB; When using MySQL 5.1 …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can get with our Slow Query Log patch. You may also interested to know how to measure replication lag – MySQL…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30/data/dpe0… do a lot better on MySQL 5.6 with default configuration back_log Minor increase 50 to 80 does not make much difference. Systems… good and make sense. In some cases I think MySQL 5.6 does not go far enough in those changes but I can…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL…is how you can test it, though it does not cover everything. For prepared statements you might want…to detect memory leaks like valgrind are too slow to run in production. So the best …
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… second. The problem may start very slow and be almost invisible for long …explain the math below. Second – is MySQL parameter back_log which has default value of …MySQL processes network communication in multiple threads and can benefit from multiple cores but this work done by main thread does not…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… versions and why number of people established slow by safe upgrade procedures – dump your data and… any reason. And this path does not work that great. I logged some of my experiences as … script or MySQL install script but simply I find no mysql user after upgrade. MySQL Does not start after …
