…the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_…options in xfs when creating it and you don’t want or can’t format the file system. One thing to note however – files…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…configuration. Some caching options…mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…my.cnf files. In fact my.cnf files are usually one…MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My…innodb_log_file_size. I won’t give you a full rundown over every option in the file…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…my workload has a hi amount of concurrent writes to about 6 tables, what version of Innodb/MySQL…file cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…MySQL command output. First one is that you can have innodb-status-file option set in your my.cnf. This will make InnoDB…table. The problem I faced many times is that people do not configure…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…my.cnf file, the remaining part of the configuration will not matter, because the log file won’t be created. This is also the only option…InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0.54a with InnoDB extensions msl patch for MySQL…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…my.cnf file used and the computer hardware specs that produced this benchmark. I am interested in general, innodb, and myisam settings and installation configuration…per second into that one table. using autocommit for innodb inserts I got 1125, and 1158 inserts per second into the table…
