… blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as the… data for this. The modeling I performed is Universal Scalability Law modeling, which can predict both software and hardware scalability, depending on how it…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…) 2 Ñ… Dual Core AMD Opteron cpu family : 15 model : 65 model name : Dual-Core AMD Opteron(tm) Processor 2210 stepping : 2… the values of accessed column is stored in key. Interesting InnoDB scalability is pretty bad for this query. The result with 4… is too hard for InnoDB even with all scalability fixes exist in 5.1.16 tree. I think InnoDB team should solve this…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… to predict in performance, the model baron has published for example is good for measuring scalability of the system as concurrency growths… which include both latching as well as inevitable application specific scalability restrictions, such as row level locks. There is also a… estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23 vendor_id : GenuineIntel cpu family : 6 model : 29 model name…_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…) 2 Ñ… Dual Core Intel XEON 5130 model name : Intel(R) Xeon(R) CPU 5130 …InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb…in Part 2). There MyISAM shows bad scalability with increasing count of thread. I think…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb… 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz stepping… did not show the scalability problem, but the main goal was the comparison of overall performance of InnoDB before fix (in 5…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…. Is it the current performance, future performance, scalability, ability to recover from disasters? We also…: 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) Xeon(R) CPU L5335 @… there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. …
