…sort_buffer. It is my understanding that the sort_buffer is used when no index are available to help the sorting so I created a MyISAM…sort_buffer_size=32*1024*$i;select * from sorttest order by data limit 78000,1;show session status like ‘Sort…UTC 2010 i686 GNU/Linux MySQL: 5.1.41-3ubuntu12.6-log P.S…
Post: Percona Server 5.1.60-13.1
December 16, 2011 By Leave a Comment
… 5.1.60, including all the bug fixes in it, Percona Server 5.1.60-13.1 is now the current stable release in the 5.1…-sort buffer cannot be more than 4GB even on 64bit architectures. With this bug fix, both the server option –myisam-sort-buffer-size and the |myisamchk| –sort-buffer-size…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… surprising results with sort performance and today I’ve discovered even read_buffer_size selection may be …MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) Populated it with 75M of rows to reach 4G in size…, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…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… set during mkfs. No LVM at this point. 5. Partition table aligned properly; sunit/swidth set during…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…size=8 #*** MyISAM Specific options myisam_max_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 Server Memory Usage
September 1, 2006 By 18 Comments
….1% 0.0% 11.1% 0.1% 1.1% 6.1% 59.1% cpu01 14.9% 0.0% 7.5% 0.0% 0.0% 5.9% 71.5% cpu02 10.5…_timeout=3600 key_buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table… innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…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_length=2048 long-query-time=5…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 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…
Comment: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…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…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… ALTER 100 different tables ? This can be offset by keeping myisam_sort_buffer_size low, but then performance would suffer. Prepared Statements Number – Happily… Partitioned tables in MySQL 5.1 Disk Space For MyISAM tables hosting providers used to use disk quotas for MyISAM tables. You can also…
