… Qcache_queries_in_cacheblogpercona.commanual Qcache_total_blocksblogpercona.commanual Queriesblogpercona.commanual 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…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… read_rnd_buffer_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 = 131072 default-storage-engine = InnoDB #thread_concurrency = 32 innodb_buffer_pool_size = 4096M…
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 4096 …size=DEFAULT; Query OK, 0 rows affected (0.00 sec) mysql> select @@global.sort_buffer_size; +—————————+ | @@global.sort_buffer_size | …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…allocated for query execution, which size can be controlled by tmp_table_size and which also only exist for duration of query… block, which can use like this: ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated 132183490560; in additional pool allocated…
Comment: Using MyISAM in production
July 6, 2006 By 36 Comments
…block__11Query_cacheP17Query_cache_block + 93 0x812279f free_query__11Query_cacheP17Query_cache_block + 219 0x81226a4 free_old_query__11Query_cache + 84 0×8123025 allocate_block…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…key_cache_age_threshold, key_cache_block_size, key_cache_division_limit Key…size). Other storage engines such as Innodb to not use this variable. sort_buffer_size Buffer used to sort result set (allocated…_table_size This variable specifies maximum size implicit temporary table (created during query …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…would put this to 256M for small sized boxes to 5% of memory size on the big boxes, though… buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be allocated. There … to Innodb. Note it is not enough to block OS from swapping – as I already mentioned the…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… can allocate large amount of memory on server. The size is typically 4-8K per table though complex tables can require larger sizes… users being unable to run their queries. Stored Procedures – How much memory can stored procedure allocate ? say can you create 1000 variables… user which allows to run queries with uncontrolled resource usage. Host Block You can have given client host blocked from accessing the server…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…needing them. Old stale uncommitted transactions may block purge process eating up resources. By looking… as statement which is being executed, query id, query status etc. Next section you will see…it probably means your active database size is smaller than allocated buffer pool size so you can tune …
Post: Are larger buffers always better ?
June 6, 2006 By 9 Comments
… queries actually performing slower, and not because the system starts to swap. Generally you want buffers and other values to be sized… but only few rows were sorted. 32K block is allocated fully in user space, while 32M block requires mmap() call and a lot… extent as why would you allocate/free sort buffer if it is used by so many queries. Here is example if someone…
