May 26, 2012

Post: Recovering Innodb table Corruption

…’re running MySQL with Innodb tables and you’ve got crappy hardware, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and…: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures…

Comment: table_cache negative scalability

I see, you didn’t bother to submit a bug report about it. Am I the only reader of your blog that want this fixed ? http://bugs.mysql.com/49177

Comment: How adding another table to JOIN can improve performance ?

Very surprised to see this in my RSS reader right after submitting http://bugs.mysql.com/bug.php?id=38550 that covers later cases in your research.

Post: MySQL Releases first real Community Release

… contributions accepted into community version. The great question however why MySQL did not announce the split just now when it really… will be continue to flow in. In fact we have submitted our slow query log with microseconds patch so we’ll… a lot depend on MySQL – if new version will be easy to upgrade to, the amount of new bugs and incompatible changes…

Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE

Are you using InnoDB tables on MySQL version 5.1.22 or newer? If so, you probably … ignored insert, but this is undocumented behaviour. This documentation bug is already submitted. Firstly, we will start with a simple question. Why… and assigns the new value to the column. Prior to MySQL 5.1.22 InnoDB used a method to access that…

Comment: My Innodb Feature wishes

bug system and found that bug, most probably very similar to this. http://bugs.mysql.com/bug.php?id=18465 Therefore, I decided not to submit this case as a bug. By the way, especially nowadays, it is getting too much time for mysql developers to fix the bugs

Post: Innodb Fuzzy checkpointing woes

…process repeats itself. There is one more related bug which makes the problem worse. Technically if …constant.  However the shared drive at shared MySQL virtual hosting and powerful RAID system may have…also very important -  if you do not submit enough concurrent requests IO subsystems will not be…

Comment: Returning to InnoDB scalability

…. However, it became a hit to the bug and MySQL stopped. It reports on the bug. ==================test environment================= OS=RedHatEL4 update3 EM64T CPU…: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures…

Comment: Gathering queries from a server with Maatkit and tcpdump

… been following the mailing list, *including several threads on the mysql internals mailing list*, you’ve seen a lot of discussion… great way to submit a reproducible bug report. Now that I look at the output above, I also see some bugs. There were… back-end is counting something wrong… off to enter a bug report.

Post: Sphinx Technologies launches Sphinx Support

… for accounting people. The Support approach was closely modeled from MySQL Support of the early days – simple service lever differentiation with… number of incidents submitted. If you have Full or Premium support you also get priority bug fixes for any repeatable bug fixes. Support… escalation to Sphinx Developers is also a way we handle bug fixes and custom Sphinx development which are all covered by…