…my.cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query optimization…mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf…
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…optimizations in Innodb in 5.0 series. Also note the “Auto Increment Issue” is finally solved in 5…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 3.5.2pl1 …InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb…innodb.log max-allowed-packet=1M net-buffer-length=16K #we value throughput over response time, get a good plan optimizer…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…. I used MySQL 5.4.2 for tests which should be as good as it gets in terms of optimizations in this space… the maximum InnoDB: allowed value would be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18:47:44 InnoDB: Warning: too…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld… = 1 innodb_max_dirty_pages_pct=15 innodb_support_xa=0 innodb_flush_method = O_DIRECT First the options are somethat benchmark optimized – for…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… TB 1 (1-0-0) 2 2-2 64 Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== ==== ======= ====== ======= ============ =========== …5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… 0 mysql> ALTER TABLE test_table ADD INDEX (id); — 5 Tickets… any performance optimization effort, you will want to optimize for the…mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 139 Comments
I need to optimize mysql server to manage a big tables (now about 78Mb, with …, defautl mysql applied, and my.cnf are not modified. Why? Where are written this configs? – do i switch table from MyISAM to InnoDB (if… disk space Load avg: 0.81 (1 min) 0.68 (5 mins) 0.73 (15 mins) Real memory 3.86 GB…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…optimizations or troubleshooting the applications. We ourselves often rely on it when doing commercial MySQL consulting and MySQL… specify it in my.cnf file, the …MySQL 5.0.56 msl patch for MySQL 5.0.45 with InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5…
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… percona 5.5 mysql server running under CentOS 5.6 on a system with 32 GB of memory: My sysctl.conf looks like this: # Memory optimization…: 2048 kB My limits.conf looks like this: mysql soft memlock unlimited mysql hard memlock unlimited My my.cnf looks like this: large-pages innodb_buffer_pool…
