…MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql….com/files/benchmarks/innodb-myisam-falcon.html (Note:…MyISAM shows bad scalability with increasing count of thread. I think the reason is pread system call MyISAM…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write …mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql-table-engine innodb –myisam…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… SubQueries avoided for MySQL) so do not just compare it directly. It also does not mention if Innodb or MyISAM tables are used… Innodb may well start to slow down before concurrency reaches number of CPUs. Yes, Innodb Team has provided the fix for this scalability problem and it is merged into MySQL 5.0.30 “Enterprise…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM scalability… performance gotcha illustration purposes. The benchmark shows following results for MyISAM using MySQL 5.0.45 run on 4 Core System: Threads…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… sources for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method… is too hard for InnoDB even with all scalability fixes exist in 5.1.16 tree. I think InnoDB team should solve this…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… will LOAD DATA INFILE be optimized same way as for MyISAM tables by separate phase of building Indexes ? Will be UNIQUE… most interesting: Further Scalability improvements Yasufumi Kinoshita did number of interesting benchmarks stress testing other areas in Innodb than buffer-pool which… MySQL 5.0 I still see Innodb having serious scalability problems in some environments with 4+ cores so it is still important. IO Scalability…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
…on a lot of short write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The …here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background there would be some changes…
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 …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… it’s time to convert MyISAM tables to InnoDB. (But then again, it might not…
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…. The modeling I performed is Universal Scalability Law modeling, which can predict both software and hardware scalability, depending on how it is… on another machine, instead of taking 12 cores away from MySQL and giving them to sysbench. That way we could test…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…. I helped Violin Memory to optimize MySQL for customer workload and Violin memory … threads which corresponds to even worse scalability. Disabling adaptive hash index could take …MyISAM (double of Innodb already) which scaled to 70.000 queries/sec peaking out at 16 threads. However even with MyISAM…
