… guide on tuning innodb buffer pool innodb_log_file_size…use. Also check if your application can run in READ-COMMITED isolation mode – if it does…Innodb properties – clustering by primary key, having primary key in all indexes (so keep primary key short), fast lookups by primary keys (try to use…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… the buffer pool and InnoDB essentially starts swapping between its buffer pool and …a million rows each. (InnoDB internally does operations such as ALTER TABLE …a fifo. Then we could use LOAD DATA INFILE on the …bigint(20) default NULL, key(col1), key(col2) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Here…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
…Innodb tables (for test purposes) Innodb still was crashing if we attempted to enable insert buffer. I think it would be nice for Innodb…Innodb tables this way for about 6 months. What does… keys are typically simple integer keys in Innodb while secondary keys… roll forward recovery using binary …
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… is cool but it does not really tell you how exactly read_rnd_buffer_size works as well… pointers together with key value – which are offsets for MyISAM and primary key values for Innodb or storing full…) MySQL can use read_rnd_buffer to optimize data retrieval – As data is sorted by the key value it…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
… OPTIMIZE TABLE for Innodb tables does not get advantage …buffer pool: CREATE TABLE `a` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `c` char(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `c` (`c`) ) ENGINE=InnoDB AUTO_… from using LOCK TABLES on Innodb table to…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
…, no keying time), it uses MySQL…buffers. It helps if you have performance drops when data does not fit in memory. Attention!(Windows only): You should not use…using. By default InnoDB uses 1 insert buffer thread, 1 log thread, 1 read thread, 1 write thread. With innodb_file_io_threads InnoDB will use…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…using Innodb you also might with to use innodb-safe-binlog option in MySQL 4.1 so your Innodb… If you restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are …longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… AUTO_INCREMENT, -> PRIMARY KEY (`id`) -> ) …buffering taking place and as MySQL crashes it does not store all data it could recover to MyISAM table. Using…Innodb Table Corruption. In more complex cases you may need to use higher innodb_force_recovery modes to block purging activity, insert buffer…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… what the lead consultant does. We want two sets …of performance. There are two key commands for this on most…hard to read. If the InnoDB buffer pool is set to 22GB… 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 | | Bytes_…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…on SQL and 20 on Sphinx). Also Sphinx does the relevance sorting by default, adding relevance …key_buffer_size. The other thing that happened with regards to memory was that when I tried to create an InnoDB…types. There are books that describe how to use one technology or the other, and some may…
