…_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the… of traditional InnoDB log flushing, which can cause downward spikes in performance. Other then that, I have also disabled query cache to… pool mutexes, using “estimate” checkpoint method to reduce chances of log flush storms and disabling the query cache.
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…-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…=6M key_buffer_size=12M server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… data type ZeroMQ plugin Log output to syslog is enabled by default Updated DEB and RPM packages Query log plugin and auth_schema… plugin, authentication via tables (similar to MySQL), RabbitMQ, regex policy, logging to syslog, authentication via LDAP. This shows that major pieces…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… behaves as if you use READ COMMITTED for all write queries, in spite of your chosen transaction isolation level (considering only… exceeded; try restarting transaction transaction2 > INSERT INTO t VALUES(31); Query OK, 1 row affected (0.00 sec) After running the…, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 localhost msandbox TABLE…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… simple script: while true do date >> ps.log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related… memory. There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_table_size…. In Percona Server you can do better as you can query temporary tables too: mysql> select sum(data_length+index_length…
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: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through speedier joins, faster subqueries…
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
… further 1) By turning logs into benchmarks so you use real user input (real queries) and not “made up” queries 2) with a…
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: 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…’ve got some time to play with table based slow query log in production while tuning one of the systems. It is… query come in the log file. If you used to do tail -100 log-slow.log and now change it to SELECT * FROM slow_log…
