…simple queries or simple transactions but high concurrency with complex transactions as well — items like…far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01…host rapidly scalable NDB clusters (commence with inserting a shameless plug that users can …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…set an lower bound on performance, only a upper bound. The best performance you can expect is …but also updates groups with some metadata: BEGIN; INSERT INTO users_groups (user_id, group_id) VALUES … above examples you can imagine plenty of concurrent clients attempting to modify the same record at …
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… so we will verify this. “Semi-sync performs dismally under concurrency. Think about it, our single inserts took ~100ms, so we are effectively…
Post: MyISAM concurrent insert
June 13, 2006 By 12 Comments
… better) threads Quadxeon with enabled concurrent-insert Quadxeon –skip-concurrent-insert Sun V40z with enabled concurrent-insert Sun V40z –skip-concurrent-insert 1 44.08 64.82 61… are using range-queries and doing INSERT not often than disabling concurrent-insert with –skip-concurrent-insert can improve MyISAM performance. As I said the reason…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that … to simulate 5 concurrent connections writing to the table, with each instance of iiBench writing 200 million single row inserts, for a… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 8 Comments
… AUTO-INC. We have recovered the concurrency and the performance but with a small cost. Queries like INSERT … ON DUPLICATE KEY UPDATE produce… of performance and concurrency. How can I solve this problem for INSERT IGNORE? As I informed you before, it is not documented that INSERT…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…concurrent…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… to most users? INSERT w/PRIMARY KEY defined: Number of rows inserted – 1 INSERT w/FOREIGN KEY constraint: Number of rows inserted – 1 SELECT… a significant amount of time. Setting innodb_concurrency_tickets too high can have startlingly negative performance implications. On the other hand, if…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…. Concurrency. MyISAM uses table locks and has concurrent inserts which can go concurrently with selects. This is sometimes presented as great concurrency for inserts … TABLES/UNLOCK TABLES) be careful. This option may improve performance dramatically in certain cases by avoiding flushing dirty index…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather than treat each defect as an individual case, is there any performance testing going on to quantify what are the limits of different operations for different levels of concurrency, specifically around…
