…buffer = 384M max_allowed_packet = 256M table_cache = 512M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache_size = 80 query_cache_size…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
…/” datadir=”D:/work/MySQL Datafiles/” default-character-set=latin1 default-storage-engine=INNODB sql-mode=”STRICT_… 200 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=30M key_buffer_size=129M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…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_… render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication log-…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for …size=13M thread_cache_size=12 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=8M key_buffer_size=64M read_buffer_size=1M read_rnd_buffer_size=1M sort_buffer_size…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…found that 32-bit xfs inodes (which are used by default) have to live in the first terabyte of the …cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… total size is unrestricted. Note you can create tables as TEMPORARY so they would not be easily visible on file system. MyISAM Sort Buffer… ALTER 100 different tables ? This can be offset by keeping myisam_sort_buffer_size low, but then performance would suffer. Prepared Statements Number – Happily… can hold value up to max_allowed_packet in size (1M by default) but there does not seems to be any limit…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…buffer = 256M key_buffer_size = 256M myisam_sort_buffer_size = 16M join_buffer_size = 64M read_buffer_size = 16M sort_buffer_size = 8M table_cache = 3600 table_definition_cache = 4096 thread_cache_size…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with…buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…_size=64M max_allowed_packet=16M table_cache=1800 record_buffer=10M sort_buffer_size=24M read_buffer_size=9M max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 default-collation=utf8…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… wrote about rather surprising results with sort performance and today I’ve discovered even read_buffer_size selection may be less than obvious…` ( `grp` int(10) unsigned NOT NULL, `slack` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec…
