…, c_address, c_comment order by revenue desc LIMIT 20; In-memory workload Now let’s see….53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_pages_read 120548 123868 100551 123592 100566 Innodb_rows…sense to me. Probably its due to a bug in how counter is calculated inside MariaDB? Other…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… with Innodb, as it is limited to only one particular index on one particular table type it is likely to be Innodb bug but… course we still hoped new MySQL release will have this Innodb bug fixed) until today we got MySQL to crash during recovery… this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb_force_recovery and load them…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
… see Heikki and the Team were not just doing only bug fixes for last two years, but rather kept very quite… with this release (which you can blame both MySQL and Innodb for) – for example neither of standard data load tools (mysqldump… and Ken which will be followed by my presentation on Innodb Scalability Limits. I will not go a lot into this plugin…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and some pages in Innodb tablespace got corrupted. In such cases Innodb will…_get_page(index)) InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get… Warnings: 0 mysql> insert ignore into test2 select * from test limit 300; ERROR 2013 (HY000): Lost connection to MySQL server during…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
… ~8000 bytes limit on row size (8126 as reported by my test installation). This limit is a consequence of InnoDB storing two rows… database, you may be missing to catch important data-dependent bugs like this one. Now, how can you work around this… problem than Innodb‘s internal limitations), though you still need to change the way your application uses this data. You can limit the…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…: My impression (from an external user of Innodb point of view) is that performance bugs don’t receive very hi priority. Yet… matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent… any performance testing going on to quantify what are the limits of different operations for different levels of concurrency, specifically around…
Post: Limiting InnoDB Data Dictionary
February 11, 2009 By 13 Comments
…/patches/innodb_dict_size_limit_standalone.patch. Currently patch is on testing stage, but later will be included into our releases. To limit memory we introduce new variable innodb_dict_size_limit (in bytes). Some internals: There is already implemented in InnoDB LRU-based… you faced bug or problem which exists for long time and is not going to be solved by MySQL / InnoDB – contact us…
Comment: Yasufumi Kinoshita joins Percona
November 3, 2008 By 8 Comments
… handling the bug reports on 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+Plugin&status%5B%5D=Active&severity=&priority=all&showstopper=&limit…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… fast is better solution. Innodb Recovery – Unless you have some hardware problems (99%) or found new Innodb bug (1%) Innodb recovery should be automatic and bring your database to consistent state. Depending on innodb_flush_lot_at… warmup this data you might run select 1 from _table_ limit 1 for each table or any other statement – it is…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… known bug 15815 so do not think it is considered to be normal behavior. About innodb_commit_concurrency. As you saw innodb_thread… even with limited innodb_thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency limits number of…
