…InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance…innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…MySQL on top of something like that? I can’t imagine the performance…MySQL. It failed miserably on the mysql_install_db process. Every time… a few rows into an InnoDB table, …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…Innodb node we can have all sorts modifications floating around as long as they don’t touch the same row. Row locks…performance you can expect is modifying a given row once per RTT, it could get slower if apply times…when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Innodb_row_lock_current_waitsblogpercona.commanual Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock_waitsblogpercona.commanual Innodb_rows_deletedblogpercona.commanual Innodb_rows…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…performance to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb… # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 8338s 1us 284s 5ms 13ms 298ms 185us # Lock time 71s 0 3ms 39us 54us 28us 35us # Rows …
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…time: 9.031233 Lock_time: 0.000086 Rows_sent: 0 Rows_examined: 10000000 Rows_affected: 0 Rows…perform but as only actual rows which are found and returned up to the top level MySQL part for processing are counted the Rows…
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 8 Comments
…MySQL 5.1.22 InnoDB used a method to access that counter values called “Traditional”. This one uses a special table lock… the innodb_autoinc_lock_mode to 0. But with a loss of performance …row affected (0.00 sec) Insert the same value multiple times. As you will see, the INSERT is ignored and no rows…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
…at SHOW ENGINE INNODB STATUS to see if there are any transactions spending very long time in ACTIVE… id 1224980800 3 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id… row lock(s), undo log entries 2 In this case we see transactions are holding some locks and perform …
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…that have mostly very fast performance, and occasionally have much worse, and…# Query_time: 0.306486 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: …shockingly long times is not to be blamed on InnoDB, it’…that’s where improvements to the MySQL source code are necessary. …
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
…performed well suddenly show up on slow query log until InnoDB again updates the statistics. But when does InnoDB perform… below are documented from the MySQL and InnoDB plugin’s manual: Metadata…# Query_time: 12.277786 Lock_time: 0.000068 Rows_sent: 294 Rows_examined: 294 Rows_affected: 0 Rows_read: …
