… MySQL is rather fast loading data in MyISAM table, but there is exception, which is when it can’t rebuild indexes by sort but builds them row by row instead. It can be happening due to wrong configuration (ie too small myisam_max_sort_file_size or myisam_max_extra_sort_file_size…
Comment: Why MySQL could be slow with large tables ?
June 17, 2008 By 141 Comments
… MySQL is rather fast loading data in MyISAM table, but there is exception, which is when it can’t rebuild indexes by sort but builds them row by row instead. It can be happening due to wrong configuration (ie too small myisam_max_sort_file_size or myisam_max_extra_sort_file_size…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…FILES_LIMIT | 1024 | 5000 | | INNODB_AUTOEXTEND_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE…MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… there is max_heap_table_size to restrict size of each table total size is unrestricted. …MySQL server to run out of file descriptors. The same is true for Partitioned tables in MySQL 5.1 Disk Space For MyISAM… size. Another possibility is to use queries which use large temporary tables or sort files …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…MyISAM variables are not important ? Not really. You still have some tables in MyISAM format in “mysql…file FullText search related variables. As FullText currently works with MyISAM tables these are MyISAM related. join_buffer_size…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
…_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM … pointer (typically physical) order. MySQL takes bunch of pointers from sort_buffer (just enough so all… (less than max_length_for_sort_data) data should be stored in sort buffer and sort file so there …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL…MySQL Server to consume at peak. This can be easily computed by memory needed for OS, File… increasing sort_buffer_size from 1MB to 4MB and 1000 max_connections increases …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…file_size. I won’t give you a full rundown over every option in the file…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_heap_table_size…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…files_limit = 9216 tmp_table_size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for_sort_data=2048 max_sort…
