… third one features even higher QPI speed (and thus, faster inter-process/node … –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-… –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT + UPDATE QPS test …
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… if InnoDB cannot log at all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log. You can request that InnoDB force its REDO… in InnoDB uses a fixed length circular transaction log, the speed at which you can process updates is tightly linked to the speed at…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_…UPDATE: If you’re looking for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed needs …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…engine for MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb users. … much larger than table itself) The index build speed is however not only reason I can’t … in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible …
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances…faster than wire speed for 1Gb networks. Plus if we can get MySQL protocol to support…. Delayed Updates Delayed Updates is complement to delayed invalidation. In many applications you have updates which are…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… run MySQL with innodb_flush_method=O_DIRECT in most cases – it… Processors | physical = 1, cores = 2, virtual = 2, hyperthreading = no Speeds | 2×1200.000 Models | 2xIntel(R) Pentium(R) …Create_time: 2012-12-31 16:24:54 Update_time: NULL Check_time: NULL Collation: utf8_…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… default MySQL settings for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log_file_size=256M innodb_flush_method=O_DIRECT for Innodb… insert speed dropped 20 times. This could be because ext3 does not like so many files in directory or because random updates…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…into a temporary table, secondary indexes are updated by inserting individual rows rather than sorting…ENGINE=InnoDB for InnoDB tables and thus, is just a special case of the previous one: mysql> SET…index creation chapter in the MySQL manual: “… you can generally speed the overall process of creating…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…create an InnoDB FT index before declaring the `FTS_DOC_ID` primary key column properly, MySQL crashed with…supports direct row-by-row updates. But you would still have to update the RT index as data …memory database, you can get a lot of speed improvement because you’re searching data without …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…s), heap size 320 MySQL thread id 30898, query id 100626 localhost root Updating update iz set pad=’a…1148250464, thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query …hash index is hash index Innodb builds for some pages to speed up row lookup replacing btree …
