…: My impression (from an external user of Innodb point of view) is that performance bugs don’t receive very hi priority. Yet, a… the scalability of InnoDB-5.0.30 in December 2006 with a large patch, and the ‘last’ serious bug in it was… matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
… in 5.1.12 (more info about InnoDB mutexes) Scalabilty issue, the well know bug 15815, that was fixed in 5.0…-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb… and used queries is avaiable here: http://docs.google.com/View?docid=d7fzh8b_7dwd8m7 or on our page http://www.mysqlperformanceblog…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…, optimizer) and storage engine. From storage engine’s point of view it works how (very simplified): mysql calls storage engine’s…_enter_innodb–; ENTER; } retry: if (entered_thread < innodb_thread_concurrency) { entered_threads++; thread->n_tickets_to_enter_innodb = innodb_concurrency_tickets; ENTER; } if (innodb_thread… known bug 15815 so do not think it is considered to be normal behavior. About innodb_commit_concurrency. As you saw innodb_thread…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…to understand how Innodb recovery works. When Innodb recovers from logs it finds the last checkpoint time. Innodb has fuzzy …cache and so having pretty scattered updates instead updating view counter for popular movie hundreds of times per second… also may help you to catch write cache bugs…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… know this, but there are precious few innodb crash recovery tests available. Some folks have noticed…the DBUG points noted in the crash test bug: DBUG_EXECUTE_IF(“crash_commit_before”, DBUG_SUICIDE…for general test runs. For example, we can view the comparisons of master-slave checksums after the…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… for two of these bugs!) This brings us to our first bug: mysql process crashes after setting innodb_dict_size The basics of this were that the server was crashing under load when innodb…: WHERE X . char_field_name != ‘If you need to translate Views labels into other languages, consider installing the
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… bugs Bug #576041 – Fixes long stalls while accessing the innodb_buffer_pool_pages_index table on systems with a large number of tables. Bug… defined by innodb_max_purge_lag by removing the requirement that purge operations be delayed if an old consistent read view exists… branch, can be found on LaunchPAD. Please report any bugs found at Bugs in Percona Server. For general questions, use our Pecona…
Post: Percona Server 5.1.49-rel11.3
September 10, 2010 By 1 Comment
… variable was introduced: innodb_flush_log_at_trx_commit_session. Fixed bugs Bug #576041 – Fixes long stalls while accessing the innodb_buffer_pool_pages_index table on systems with a large number of tables Bug… defined by innodb_max_purge_lag by removing the requirement that purge operations be delayed if an old consistent read view exists…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… etc. You should not think about this however as about bugs, as many MySQL features it is designed for particular load… application (storing billions of rows in tens of thousands tables) Innodb was better choice mainly because of thouse other behaviors … well… number of tables. I still have the same view on Storage Engines – Innodb is my oppinion is better choise for general purpose…
Post: Queries Active vs Transactions Active
September 14, 2009 By Leave a Comment
… views open inside InnoDB It is relationship between queries active – queries inside innodb+queries in the queue totalling 17 with “read views open inside InnoDB… while waiting for something else. Most of such situations are bugs either in application itself or connection pooling software.
