… 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…=6M key_buffer_size=12M server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
Hi, I am facing major issues with slow query output. The tables are in InnoDB with MySQL 5 and …_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool…_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…: while true do date >> ps.log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table … There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_…tools to detect memory leaks like valgrind are too slow to run in production. So the best thing …
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… all-staff meeting last week, so we are a little slow to blog about this and acknowledge the great work that… Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through speedier joins, faster subqueries…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… text’); Filtering 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 by Nathanial…
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 … I’ve got some time to play with table based slow query log in production while tuning one of the systems. It is… as this would allow to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The…
Post: Does Slow query log logs all slow queries ?
June 25, 2007 By 2 Comments
… use MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries are not logged to slow query log…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… other is slow log enabled by –log-slow-queries parameter (MySQL 5.1 requires also –slow-query-log), which was designed to store poorly performing queries that run at least 2 seconds. Percona actually extended the slow log to, among…
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
I just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not a big… especially bad if you’re using tools to analyze slow query log to find what queries take up the most resources on your server…. One more thing to consider – slow replication queries also identify replication lag, ie if you have query which ran 10 seconds on the…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…. Using pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest can be pretty CPU and memory consuming, so ideally you would want to download the “slow query log…
