Reactions to story from MySQL Performance Blog
Concurrent inserts on MyISAM and the binary log
http://www.mysqlperformanceblog.com/ 2008/ 05/ 14/ concurrent-insert-select-myisam/
Recently I had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with queries in Locked status. My first thought was that the customer had deleted from the table, which leaves "holes" in the middle of it and prevents concurrent inserts. (You can configure the server to permit concurrent inserts even when there are holes, but it's disabled by default.) However, that turned out not to be the cause; the table was only inserted into (and selected from).
More rising blog posts
-
Entertainment »
A type of E.S.P. -
Business »
How Chrome puts the skids under Nokia -
Lifestyle »
Global Markets Sink After Dow's Plunge -
Politics »
Ypulse Essentials: Teen Vogue's 'Political Partier,' Peaceful Teen Ts, Ikeas's New Webisodes -
Sports »
Handful of Iraqi refugees to return home from Jordan -
Technology »
Review: PCalc 1.0.2 for iPhone and iPod touch
More rising news stories
-
Entertainment »
Lindsay Lohan Turns Down Playboy -
Business »
Tech firms fare better than most in jobs slump -
Lifestyle »
GE may face civil action on securities violations -
Politics »
US election: US newspapers react to McCain's speech -
Sports »
Quentin has broken wrist, will have surgery -
Technology »
New Comet May Explain Halley's Strange Orbit
Recent posts from MySQL Performance Blog
-
New patches, new builds
2 hours ago -
How quickly you should expect to see bugs fixed
1 day ago -
ANALYZE: MyISAM vs Innodb
2 days ago
