…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL…you can query temporary tables too: mysql> select …LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL *************************** 2. row …valgrind are too slow to run in…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…/mysql/mysql.sock max_connections = 600 wait_timeout = 60 interactive_timeout=1800 skip-name-resolve skip-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_cache_type=1 query_cache_size=32M thread…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… are a little slow to blog about…MySQL family of databases. Finally, High Performance MySQL,…time resolution for DATETIME and similar time-based types, as well as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
…I am facing major issues with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. …_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = …. select count(1),field1 from Table where REQUEST_TIME >= ’2012-03-26′ group by field1; 14 rows …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat… increase CPU time spent. This is because IO handling requires significant number of CPU. With Percona Server, enabled full query logging and log_slow_verbosity…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…Slow Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…query to be logged it must match long_query_time AND min_examined_row_limit AND log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous … query execution time and lock time does not store fractions of the second. Today I’ve got some time to play with table based slow query log…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option …Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log….commanual time_formatblogpercona.commanual time_zoneblogpercona.commanual timed_mutexesblogpercona….
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case… the application time the queries and write a query log. I suggest writing out something in a standard logging format such as the slow-query-log format, so…
