… of similar structure with needed index and populate it with insert… select statement as you need it. One little gotcha which… concurrent inserts and run long reporting query on the log file query execution is still proceeds. I have not checked if concurrent insert is…
Comment: Using MyISAM in production
June 23, 2006 By 36 Comments
… with inserts going in the table. What if you use –skip-concurrent-insert option ? This would show if it is related to concurrent inserts at…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… to about 15% in MySQL 5.5.8 with 8 concurrent threads. This both shows there is a substantial gains as… your select queries dramatically. The inserts in this case of course are bulk inserts… using single value inserts you would get much lower… great performance (the competing way is to have prepared bulk insert statements). We need to try new Percona Server 5.5…
Comment: Innodb Performance Optimization Basics
April 25, 2008 By 75 Comments
… be faster than Innodb to insert the data and Innodb can be faster than MyISAM to insert the data – it all depends on what you’re looking at. For inserts in single table by… in Innodb, however if you have large system and many concurrent inserts or parallel long running queries Innodb is likely to be…
Comment: Heikki Tuuri to answer your in depth Innodb questions
October 2, 2007 By 51 Comments
… been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather than treat each defect as an… are the limits of different operations for different levels of concurrency, specifically around mutexes and contention? How does this fit into…
Comment: MyISAM concurrent insert
September 24, 2006 By 12 Comments
What is the negative impact to turn the concurrent_insert off? Will it make insert waits much longer? Is there any bug or…? Will turning off the feature help queries which have no insert on the same table at the same time? My system has update:Insert:Select ratio is 3:1.5:1 so the db…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… fixed #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on a table with an…, lost data due to some rows being updated rather than inserted) with the default value of innodb_autoinc_lock_mode=1…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
… fixed #1015109 (Stewart Smith). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on a table with an…, lost data due to some rows being updated rather than inserted) with the default value of innodb_autoinc_lock_mode=1…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… the right forum for the point). Tried using concurrent_inserts=2 and the inserts fired from same machine still got blocked for long…
Comment: MyISAM concurrent insert
August 23, 2011 By 12 Comments
… is about 170 gig on drive, daily does millions of inserts, updates, selects, and a few 1000 deletes. Some of the… and writing. Do you think if I were to disabled concurrent insert this would help or worsen the select from time issues…
