…in a parallel way, thus utilizing multiple CPU cores if needed. In previous versions, …backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups…running Percona XtraBackup against debug versions of InnoDB. This is only for very advanced users….
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23 vendor_id : GenuineIntel cpu family : 6 model… next step, read detailed investigation what is the reason of performance drop in next post. And last one workload I tried…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… more queries per second than identical box, but with 4 CPU Cores. The main query which showed this problem was similar… t1 into InnoDB, and results: Threads Queries/sec 1 296 2 341 4 544 8 493 16 498 InnoDB both performs much better… can see Falcon perform extremely poorly when single query executed being 1/3rd of MyISAM and 1/6th of Innodb. On other…
Post: Benchmarks of new innodb_flush_neighbor_pages
January 17, 2012 By 6 Comments
… InnoDB will flush, and P is our page. So, as the result of how it works, instead of performing 1 random write, InnoDB will perform 8 random writes. This is quite far from… significant amount of time. The raw results, scripts and different CPU/IO metrics are available from our Benchmarks Launchpad mbgc=’f5f5f5…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
…) ~5% I/O load according to iostat (from 99%) ~5% CPU load according to top (from 80-100% mostly waiting for… key (from 1-20 sec before the conversion) These interesting performance results obviously come from the fact that in addition to… trying to compress 16kb pages down to 8kb) new innodb plugin performs TEXT/BLOB/VARCHAR fields compression off-page so every large…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… this format will not be recognized by older Innodb versions. Note: These are completely CPU bound test conditions, data fits to buffer… the corellation between CPU usage and performance. We can see Plugin uses less CPU with 8 cores and has less performance – this usually shows… shows increased performance while decreased CPU usage. Note when I say CPU usage drop means concurrency issues it does not mean CPU increase does…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
… different InnoDB buffer was used. In CPU-bound case innodb_buffer_pool_size=2G In IO-bound case innodb_buffer_pool_size=512M innodb_flush… from performance degradation caused by the microslow patch itself. Let’s do the same tests but logging to /dev/null. CPU-bound… bigger than a second without worry about performance impact in case of CPU-bound workload. The performance impact is negligibly small in IO…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… this stage. Is it the current performance, future performance, scalability, ability to recover from disasters…power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel… are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example….
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… with multiple threads. So Innodb took very high hit supplied with high performance IO subsystem. But not only performance was poor with single… quite surprising adaptive hash index actually hurts performance in this case. My guess is Innodb just was not really designed and tested… CPU cycles handling them without taking large performance hit. I really hope this would be one of the Items besides CPU scaling which Innodb…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…) to see how efficient storage engines are in terms of CPU usage. In real life workload results are likely to be… and performance parameters may vary a lot in next releases) Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb… we see bad performance. We hope the performance of LIMIT queries will be fixed before release. MyISAM shows stable result. InnoDB is better…
