…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL…What you might see instead is flushing tables regularly or reducing … as you can query temporary tables too: mysql> select sum(data… like valgrind are too slow to run in production. …
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 RHEL 5. Its a…/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option and….commanual innodb_flush_log_at_trx_commitblogpercona.commanual innodb_flush_methodblogpercona…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at_trx_commit=1. …traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it is…which queries mysql. I’ve seen monitoring updates which would add excessively expensive and frequent query …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb_data_file…_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log_buffer_size = 16M innodb_flush_log_at_trx_commit = 1 innodb_lock…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…| Uptime_since_flush_status | 162626 | +———————————–+———————-+ …slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…query statistics for microslow patch and user statistics in runtime. Next variables were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL… fixed (control_flush_and_merge_and_read, control_io-threads, adaptive_flush) | | innodb_…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…disk tables and HEAP for in memory tables. So first MySQL versions did not bother naming variables with storage engines …and other storage engines transaction logs, slow query log or general log. flush, flush_time Flushing (closing) of tables after query is complete or every flush_time seconds. This …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK Note – this command may take a while to complete if you have long running queries…. Normally you can skip slow query logs and error log while taking backup. You also can skip most of binary logs – however if some of…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…down. You can have slow query log enabled and review it …transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | …with the corresponding FLUSH command (e.g. FLUSH INDEX_STATISTICS…
