…MYSQL Config as below. Could you please provide us suggestions to improve the performance. Hardware…slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log… innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=1 …
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
…logging impacts on performance. When we do performance audit often we log every query to find not only slow queries. A query…logging turned off; logging queries which take more than a second to execute; logging every query; MySQL …3000 innodb_log_file_size=128M innodb_flush_log_at_trx_commit=1 innodb_…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…slow query log and mk-query…queries MySQL server ran with their times and run mk-query-digest with filter to only check queries from replication thread: mk-query-digest slow-log…perform a lot slower then they are warmed up. Measuring times for each binary log…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…to the MySQL 5.5.8 server. Here are some highlights: Performance and …log_at_trx_commit was added. Bug fixed: #635399. (Yasufumi Kinoshita) New variable log_warnings_silence replaced old variable suppress_log… Slow Query Log page. (Oleg Tsarev) Other Changes Additional information was added to the LOG…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
….0 of MySQL being slow but few queries being “inside innodb” and potentially even empty queue. This is because bottleneck happens in commit phase… you may not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit back but obviously you…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…mysql tables in use 1, locked 1 3 lock struct(s), heap size 368, undo log entries 1 MySQL thread id 9697561, query…log buffer as well as when last checkpoint was performed. Innodb uses fuzzy checkpointing so this line hold log…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…committed transactions but it is it. It is Performance of this process which may cause the problems. As I already wrote innodb_log…MySQL server its caches (key_buffer, innodb_buffer_pool, query…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…use smaller values. innodb_flush_log_at_trx_commit Crying about Innodb being …it too large as it may slow things down as its maintenance … specific. If you have simple queries there is no reason to…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=200M innodb_log… see that the number of slow queries is increasing on. mysql> \s ————– mysql Ver 14.7 Distrib 4….: 64 Queries per second avg: 1.615 ————– Please suggest me how to increase the performance of …
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
…commit transactions unless there were any writes. If database is configured in READ-COMMITTED transaction mode it is actually fine from performance…perform some update/deletes as there are undo log entries. This is bad because of 2 reasons. First if some other query…
