… vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters. … = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… stage and performance parameters may vary a lot in next releases) Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… to remove warm-up phase. Measurements are taken every second. Parameters to vary: we vary innodb_buffer_pool_size:13, 25… innodb_buffer_pool_instances parameter may change the result significantly, especially in intensive IO workloads. In MySQL 5.6 it is finally…_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover user=root skip…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
The parameter sort_buffer_size is one the MySQL parameters that is far from obvious to adjust. It is a … index: CREATE TABLE `sorttest` ( `data` char(30) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 and I inserted 100k rows with this… cache before the benchmark by doing “alter table sorttest engine=myisam;”. The script used for the benchmark is the following: #!/bin…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I… the nodes. Q: We are missing SST_AUTH parameter, rigth ? It is not possible to do SST…xtrabackup works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, since it is…
Post: Getting annoyed with MyISAM multiple key caches.
May 1, 2009 By 11 Comments
… to get CPU scalability if you’re using MyISAM. It is however very annoying – this feature really…The only thing you can access is key cache parameters – via structured variables In particular I would like … feature of multiple key caches first introduced in MySQL 4.1 was newer quite polished in terms…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… also want to know what the operating parameters are. Can we suggest upgrades, rewriting queries, …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT….09) supports the MySQL Backup API which was originally implemented in MySQL 6.0. This … PBXT seems to have very few configuration parameters. Â Was this an intentional design decision,…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… MySQL version We used MySQL 5.1.16-beta sources for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
… NOT NULL ) ENGINE=MyISAM mysql> show table status like ‘bbool’ \G *************************** 1. row *************************** Name: bbool Engine: MyISAM Version: 10 Row_format…query based on parameter (IS ” would not work) or you can use Null-Aware comparison operator: mysql> select count(*) …
