… me to do some mathematical modeling of InnoDB‘s scalability as the number of cores in the server increases. Vadim runs lots… typical commodity machine except for the high core count, which is more than I can remember seeing in the wild. The database…, and lots of others) have 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
…work best on different database brands. Oracle’s main database has a very competent team working on…on this this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… of small size is also that TokuDB can keep in memory much more records then InnoDB / MyISAM. Actually in internal cache records… scale well on multi-cores even in only SELECT queries. What this practically means it that you can‘t get benefit of multi-core boxes running… work with mix of storage engines. – The Tokutek engine I tested comes in binary form and mysqld binary does not contain InnoDB…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
…multi-core word the compression utility should utilize several CPU to speedup operation, and another my requirement was the ability to work…For compression test I took ~12GB of InnoDB data files generated by tpcc benchmark … on what is more important for you – size or time, but having this data we can…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… modern multi core servers not only the fact you can‘t well mix SELECTs and UPDATEs but also the fact only one update can… work as this would add a lot of contention on the writes. In this case you can just rebuild the table from Innodb source on regular basics. In case you can afford to have stale data in search results it can work…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
…work on “High Performance MySQL, 3rd edition”, Baron asked me to compare different MySQL version in some simple benchmark, but on… unexpected, staring with InnoDB-plugin, MySQL scale much better on multi-cores, there is gain up…, let’s take look on single thread results: You can see that each new…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… fair amount of work required to make it work well such …on the compression page settings by looking at compressed page size distribution you can…statement duration. The problem with multi value inserts however is the …see Innodb having serious scalability problems in some environments with 4+ cores…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…Innodb now and again, and were also very interested in having some tests to ensure things were working…copying the Facebook multi-threaded python load… core is “kewpie/randgen/” is not a core …on the test tables between crash/recovery/validate cycles. To examine this for yourself during a run, you can…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…I partially got them while working for MySQL. These thought base on my understanding, reading docs,… laptops are getting multi cores so we can forget about spinlocks wasting CPU time on single CPU boxes…order can be applied to most storage engines, it certainly can be applied for MyISAM and Innodb….
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… least it should happen for most common cases. Innodb scaling issues are the most common problem (and … The good thing is now with multi-cores coming even on laptops these issues can‘t be under carpet any more … straightened up. I know on a lot of listed issues the work is going on and it just takes …
