…rather surprising results with sort performance and today I’ve discovered even read_buffer_size selection may be … my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. … (OS and Hardware) as well as different file systems as these could all be involved here…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt …I see are not configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If … sometimes see unlikely settings, such as making the sort buffer size much too large (a gigabyte comes to mind…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…buffer_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…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = …size = 64M thread_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…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
…MySQL takes bunch of pointers from sort_buffer (just enough so all rows fit in read_rnd_buffer as they are read) and sorts…sort_data) data should be stored in sort buffer and sort file so there would be no need for read_rnd_buffer…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…file FullText search related variables. As FullText currently works with MyISAM tables these are MyISAM related. join_buffer_size Buffer…sorted order (read_rnd_buffer_size). Other storage engines such as Innodb to not use this variable. sort_buffer_size Buffer used to sort…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL…sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size…
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… 100 different tables ? This can be offset by keeping myisam_sort_buffer_size low, but then performance would suffer. Prepared Statements Number – Happily… likely cause your MySQL server to run out of file descriptors. The same is true for Partitioned tables in MySQL 5.1 Disk…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-…partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_…
