…buffer sizes are used. This matters because some buffers (sort_buffer_size for example) are allocated to their full size…buffer is allocated. Its meaning is actually “minimum join buffer size.” Here’s the code, in sql/sql…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… what is now my newest Firefox toolbar …sort_buffer_sizeblogpercona.commanual Sort_merge_passesblogpercona.commanual Sort_rangeblogpercona.commanual Sort_rowsblogpercona.commanual Sort_scanblogpercona.commanual sporadic_binlog_dump_failblogpercona.commanual sql_auto_is_nullblogpercona.commanual sql…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…| | PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | 10000 | 1556 | | SQL_MODE | | NO_ENGINE_SUBSTITUTION | | INNODB_OLD_BLOCKS…sort_buffer_size was decreased to 256K from 2M. This change should help many small sorts for which allocation of 2M for sort buffer…would make more sense in my opinion. MySQL 5.6 adds…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set user-specific options. # # In this … SQL #safe-updates [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances… 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_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” max_connections=100 query_cache_size…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…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED… = 6000 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…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows on …record_buffer=10M sort_buffer_size=24M read_buffer_size=9M max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M…slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…of more costly queries and/or low query rates. sort_buffer_size is much improved over the past 2M but … be InnoDB and use innodb_file_per_table. sql_mode also uses STRICT_TRANS_TABLES by default. … the general quality of configuration overall. Views are my own. For an official Oracle view, consult a …
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…allowed connections or run out of memory ( myisam_sort_buffer_size is normally set pretty lage). If this … my failure handling scenarios. Cold Start – If you restart MySQL server its caches (key_buffer, innodb_buffer_pool…in OS cache. You can save these into .sql file and use –init-file to make …
