…=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file…_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size… InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this is mostly because fixes to rw_locks…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… certain type of the table corrupting with Innodb, as it is limited to only one particular index on one particular table type it is likely to be Innodb bug… will be locked) So everything kind of worked (of course we still hoped new MySQL release will have this Innodb bug fixed…
Comment: Yasufumi Kinoshita joins Percona
November 3, 2008 By 8 Comments
… patches to improve InnoDB‘s scalability and has tracked down a serious bug in InnoDB-5.0.30 rw-lock implementation. To Kevin Burton I would like to assure that Innobase/Oracle has 8 developers working on InnoDB. We… InnoDB and InnoDB Plugin: http://bugs.mysql.com/search.php?search_for=&bug_type%5B%5D=Server%3A+InnoDB&bug_type%5B%5D=Server%3A+InnoDB…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
… | Table | Op | Msg_type | Msg_text | +——–+———-+———-+——————————————————————-+ | test.a…stops you from using LOCK TABLES on Innodb table to ensure…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… recovering tables on the crash or partially executed statements. Table locks is no more problem, hot backups are easy, though there… replication of mixed table types which is quite complicated. I prefer to pick one storage engine (typically Innodb) and when use other…) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…_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… value for innodb_thread_concurrency? The value depends on a lot of factors, including kind of workload you have, what type of… saw innodb_thread_concurrency protects only access to row, but there is also commit stage which obviuosly uses internal structures and locks…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…_type = 1 query_prealloc_size = 65536 query_alloc_block_size = 131072 default-storage-engine = InnoDB #thread_concurrency = 32 innodb_buffer_pool_size = 4096M innodb_lock_wait_timeout = 120 innodb_use_sys_malloc = 0 long…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
… was attempted. A check is now made for the replication type to test. (Oleg Tsarev) Bug #676158 – Setting the query cache…) Bug #677407 – The innodb.innodb_information_schema test could fail sporadically due to flawed logic in the INFORMATION_SCHEMA.INNODB_LOCKS caching mechanism. (contributed…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… InnoDB in REPEATABLE READ mode. On the other hand, there are currently no plans to implement InnoDB style “gap locking“. Gap locking effectively involves locking… index scans. Basically this means that all types of SELECTs can be done without locking. Morgan notes: Indexes not using MVCC is…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…: 0 # Query_time: 9.031233 Lock_time: 0.000086 Rows_sent:…id=a.id; +—-+————-+——-+——–+—————+———+———+————-+——+——-+ | id | select_type | table | type | possible_keys | key | key_len …: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: 12F24 SET timestamp=…
