…workloads. Both have a key_buffer_size of 4GB. Now can you tell which server is badly tuned…that’s dedicated to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM, which is more… you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… a predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM system, Red Hat Enterprise with dual SCSI RAID: [mysqld] long_query_time=5 skip-bdb skip-innodb skip… not available, for instance) and eking performance out of an InnoDB table for raw SELECT speed will take a committee of…
