…. Our mysql db contains a mix of innodb and myism tables and run on linux with 16gigs or ram. Here is our…-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache… buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
….00 sec) *** All db in replicated mode are using INNODB OS (all): Linux 2.6.9-42.0.8.ELsmp #1 SMP…/Linux Also currently: these config (my.cnf) were all disabled from 20 servers: # Uncomment the following if you are using InnoDB tables #innodb… buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 Thanks in…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
…Average corresponds to ? At least on Linux it is number of processes which… of locks (table/row level locks) or other limiting factors such as innodb_thread… time requests spend waiting in various queues and waiting on locks, the time… responding site until their browsers timeout, which is as good as …
