… MySQL manual, especially the option and…query_alloc_block_sizeblogpercona.commanual query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query_cache_sizeblogpercona.commanual query_cache_typeblogpercona.commanual query_cache_wlock_invalidateblogpercona.commanual query…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…size 16777216 tmpdir /tmp transaction-alloc-block-size 8192 transaction-isolation REPEATABLE-READ transaction-prealloc-size…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…Allocations There are cases when MySQL will allocate…allocated for query execution, which size can be controlled by tmp_table_size and which also only exist for duration of query…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…size = 8M bulk_insert_buffer_size = 8M query_cache_limit = 254M query_cache_size = 254M query_cache_type = 1 query_prealloc_size = 65536 query_alloc_block_size…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…tables. So first MySQL versions did …_threshold, key_cache_block_size, key_cache_…size). Other storage engines such as Innodb to not use this variable. sort_buffer_size Buffer used to sort result set (allocated…size This variable specifies maximum size implicit temporary table (created during query…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…MySQL 5.5 and before it was “ON” by default with query cache size of 0 which makes it disabled. I wish query_cache_size…blocks_time now set to 1000 making Innodb Buffer Pool Size scan resistant by default. Very welcome change ! thread_cache_size…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… this to 256M for small sized boxes to 5% of memory size on the big boxes…MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be allocated…Innodb. Note it is not enough to block OS from swapping – as I already mentioned…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…1 on it with 6GB allocated for innodb_buffer_pool …size including indexes which is way more than buffer pool size …table scan and index scan queries, though this is really not …MySQL has about data which will be accessed next – in case of full table scan, index scans etc the information about blocks…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…other. Calls require memory allocation and especially stack memory allocations. There are some protections… query is internally presented using parse tree inside MySQL which of course depends on query size…run queries with uncontrolled resource usage. Host Block You can have given client host blocked…
Comment: Using MyISAM in production
July 6, 2006 By 36 Comments
…allocate_block__11Query_cacheUlcUlc + 137 0x81227f1 write_block_data__11Query_cacheUlPcUlQ217Query_cache_block10block_typeUic + 69 0×8121632 store_query__11Query_cacheP3THDP13st_table_list + 454 0x809da46 mysql…
