tag:blogger.com,1999:blog-14455177.post8193836772607831770..comments2024-03-07T18:57:25.977+01:00Comments on Mikael Ronstrom: 245% improvement of MySQL performance in 1 yearMikael Ronstromhttp://www.blogger.com/profile/07134215866292829917noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-14455177.post-4925955058631255182009-11-13T13:44:42.401+01:002009-11-13T13:44:42.401+01:00Hi Mikael
Just wanted to say congratulations to e...Hi Mikael<br /><br />Just wanted to say congratulations to everyone behind this work and thanks for sharing the results!<br /><br />Of course, a big part of these improvements have been available some time, but this post is one of the simplest summaries of the topic that I've seen. MySQL development was well ahead of Moore's curve!<br /><br />Henrikhingohttps://www.blogger.com/profile/09201666166374161923noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-12302593987022415422009-11-12T07:41:13.964+01:002009-11-12T07:41:13.964+01:00The LOCK_* changes are patches that I am currently...The LOCK_* changes are patches that I am currently working on getting into an official MySQL tree. They remove the LOCK_alarm, LOCK_threadcount as being part of every query and decreases the time LOCK_open is held in a query.Mikael Ronstromhttps://www.blogger.com/profile/07134215866292829917noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-72650583169992424922009-11-11T22:18:55.191+01:002009-11-11T22:18:55.191+01:00Can you give more insight on configuring those or ...Can you give more insight on configuring those or did you add any patch to control Lock* ?venuhttp://venublog.comnoreply@blogger.comtag:blogger.com,1999:blog-14455177.post-60787618809454494572009-11-11T17:41:54.282+01:002009-11-11T17:41:54.282+01:00The MySQL version then was MySQL 5.1.28 and now My...The MySQL version then was MySQL 5.1.28 and now MySQL 5.4.3 with the LOCK_open, LOCK_threadcount and LOCK_alarm improvements and running with InnoDB adaptive hashing off.Mikael Ronstromhttps://www.blogger.com/profile/07134215866292829917noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-3257742279234519042009-11-11T17:27:03.839+01:002009-11-11T17:27:03.839+01:00So what was the hardware used and MySQL versions -...So what was the hardware used and MySQL versions - then and now?6thSensehttps://www.blogger.com/profile/07628885185318695992noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-33089487212075104292009-11-11T16:20:57.805+01:002009-11-11T16:20:57.805+01:00Can you please post the HW/OS/MySQL config for bot...Can you please post the HW/OS/MySQL config for both scenariosymghttps://www.blogger.com/profile/07089150608334508522noreply@blogger.com