… all-staff meeting last week, so we are a little slow to blog about this and acknowledge the great work that…-based types, as well as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with… group commit fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL…
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. Its a… = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool… innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 A count command with…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option and… innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED max… log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb_data_file… innodb_log_buffer_size = 16M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
….57 with the Group Commit Fix applied. The first graph shows the results when we have a slow fsync (write-back cache is disabled), innodb_flush_log_at_trx_commit=1 and sync_binlog… enabled and disabled. All results are for binaries with group commit fix. Results with disabled write cache thread trx=1, No…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… SNAPSHOT. In the middle of the workload this transaction commits and so the purge begins. The tests were performed … not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is… with the change are not effective enough: they only slow the growth of the history list. But, TPS in…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…log_slave_updates, setting innodb_flush_log_at_trx_commit=1. Also note there is no such thing… buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is…query-digest (Percona Server marks Slave Thread in slow query log so it is easy to filter…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018…: 181243 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 0 COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS:… Server, enabled full query logging and log_slow_verbosity=full you can also get great…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…insert_threads’, ’0′ ‘Delayed_writes’, ’0′ ‘Flush_commands’, ’5′ ‘Handler_commit‘, ’19092941′ ‘Handler_delete’, ’0′ ‘Handler_discover’, ’0′ ‘Handler_read_first…tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… MySQL 5.0 broken group commit bug. First I should note I am extremely unhappy how MySQL handled this problem. While working for MySQL… so group commit would trigger in MySQL 4.0 and large number of transactions in total so serializing them would make MySQL unable… of MySQL being slow but few queries being “inside innodb” and potentially even empty queue. This is because bottleneck happens in commit phase…
