…_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…the amazing MySQL manual, especially the option and variable … default_week_formatblogpercona.commanual defaults_extra_fileblogpercona.commanual defaults_fileblogpercona.commanual …data_pointer_sizeblogpercona.commanual myisam_max_sort_file_sizeblogpercona.commanual myisam_mmap_sizeblogpercona….
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…file-extra-flags during “prepare” phase and instead of having files…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…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=185M key_buffer_size=157M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
…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: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…~]$ vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for …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=203K…
Comment: What to tune in MySQL Server after installation
June 29, 2009 By 118 Comments
… Anyone suggest me how to increase the performance of my MYSQL server. Day by day the number of slow queries are…_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=203K…
Comment: Why MySQL could be slow with large tables ?
November 29, 2006 By 141 Comments
… 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) or it could be just lack of optimization….3G, 15.000.000 rows, 512MB memory one the box. MySQL 4.1.8 One could could call it trivial fast…
Comment: Why MySQL could be slow with large tables ?
June 17, 2008 By 141 Comments
Normally MySQL is rather fast loading data in MyISAM table, but there … 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) or it could be just lack of optimization…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… of extra calls …size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE…mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size…
