…), ‘client’ => array( ‘compression’ => true, ), ); $cache = Zend_Cache::factory(‘Core‘, ‘Libmemcached’, $frontendOpts, $memcacheOpts); $timer->start(); for ($i…; While this benchmark doesn’t show any multi-threading or other advanced … InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
… blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as the number of cores in the server increases. Vadim runs lots… done great work in the last couple of years making InnoDB scale and perform better on modern hardware.
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement… rules can be established. I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for scalability… not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987, used…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
… to review that data having some new information. In current multi-core word the compression utility should utilize several CPU to speedup… request from comments. For compression test I took ~12GB of InnoDB data files generated by tpcc benchmark with 100 warehouses. I… and faster than pbzip2 but still not so fast; however multi-threaded processing may be OK, especially if you need to…
Post: Index lock and adaptive search - next two biggest InnoDB problems
February 25, 2010 By 12 Comments
Running many benchmarks on fast storage (FusionIO, SSDs) and multi-cores CPUs system I constantly face two contention problems. So I … key select queries and write queries at the same time. InnoDB again uses single global mutex for adaptive_search (single mutex… variable), but it rarely helps actually. With disabled adaptive index InnoDB needs to perform much more operations reading secondary keys. How…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… Table Locks is probably the most important issue – with modern multi core servers not only the fact you can’t well mix… is Full Text Search indexes which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM…. Use “Shadow” MyISAM Table You can keep main data in Innodb but build a “shadow” MyISAM table which is used for…
Comment: Bug fix of InnoDB scalability problem
November 15, 2006 By 13 Comments
… actually care about 4.1 Now about 4.0 and multi cores. No one is speaking about 4.0 only 4.1…, attaching it to multi core CPUs is nothing else but a trick to hide complete failure of MySQL/Innodb fixing this bug which… however existed for long time… it is just only with multi-cores they came to commodity market so amount of complaints increased.
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…servers, as most important fixes in XtraDB are related to multi-core and multi-disks utilization. Also results may be different if …InnoDB parameters: innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… that TokuDB can keep in memory much more records then InnoDB / MyISAM. Actually in internal cache records are stored in uncompressed… well on multi-cores even in only SELECT queries. What this practically means it that you can’t get benefit of multi-core boxes… binary form and mysqld binary does not contain InnoDB. Tokutek tells me that InnoDB will be included in a future release. With…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…may know this, but there are precious few innodb crash recovery tests available. Some folks have noticed… two reasons: My attempts at copying the Facebook multi-threaded python load-generation code seemed very, very…# 2011-12-21T14:25:02 core is “kewpie/randgen/” is not a core dump: Is a directory No …
