…`col2` (`col2`), KEY `col2_2` (`col2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) In previous … Query OK, 0 rows affected, 1 warning (0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note …
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… is the related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row… t as SELECT ld.label_id, cai.inventory_id, COUNT(1) as installed_count from client_app_inventory cai inner join…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… a two-NIC bonded pair you’ll get roughly 1.67x the throughput of a single port. [Don’t … number of long-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble is …up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance on this size …show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better throughput, and on data size: InnoDB…extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql….
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the more general descriptors optimization in Percona Server showed fairly close results in our tests. In… Dimitri was using 8 tables with 1M rows each (about 2.1GB) for his tests,…sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp-simple-ranges=…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…78GiB of data (32 tables, 10M rows each) and a 4GiB buffer pool…. the blue line – SSD config) which shows the most consistent performance. The others…innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb…
Comment: Implications of Metadata Locking Changes in MySQL 5.5
March 27, 2013 By 9 Comments
… and not a query that would hold any row lock. The point was to show the implications of a transaction not holding… row locks blocking the ALTER, while the post deals with metadata locks. If you can enable the InnoDB plugin on your 5.1… case is waiting on InnoDB row locks by setting innodb_lock_wait_timeout to 1 and then issuing the ALTER: — session 1 start transaction; select…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2>&1 & Our awesome development … step because update statements that match no rows or insert statements that have duplicate key …this (we did 39 measurements), the next graph shows chunk 4’s workload warmed up with chunk…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…errors: ———————— LATEST DETECTED DEADLOCK ———————— 060717 4:16:48 *** (1) TRANSACTION: TRANSACTION 0 42313619, ACTIVE 49 sec, …Finally last section – row operations which shows activity on the row basics and some system information. It shows innodb thread queue status…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… antest_innodb; +——————–+———+———-+———-+ | Table | Op | Msg_type | Msg_text | +——————–+———+———-+———-+ | test.antest_innodb | analyze | status | OK | +——————–+———+———-+———-+ 1 row in set (0.00 sec) mysql> show…
