… the most common cache methods for MySQL. Popular cache methods The MySQL query cache When the query cache is enabled, MySQL examines each query to see if the contents have been stored in the query cache… you need Both Memcached and the MySQL query cache are limited in size. If you try to cache more information than you can store…
Comment: Using MyISAM in production
July 6, 2006 By 36 Comments
… of query cache going on Here are our query cache variables and status +——————————+———–+ | Variable_name | Value | +——————————+———–+ | have_query_cache | YES | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 524288000 | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… myisam_sort_buffer_size = 64M thread_cache_size = 80 query_cache_size = 32M thread_concurrency = 8 query_cache_type = 1 query_cache_limit = 32M thread_stack=256K myisam_data_pointer_size=6 net_buffer_length = 8K log-slow-queries=/var/lib…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… extra stats such as information about the queries‘ execution plan (which includes things like whether Query cache was used or not, if Filesort… be that you end up limiting the number of results returned by the query, by using a LIMIT clause or by filtering based… the report because it matches –limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.00 # Query_time sparkline: | .^_ | # Time range: 2011…
Comment: Choosing innodb_buffer_pool_size
November 25, 2010 By 39 Comments
… QUERY CACHE Query cache is enabled Current query_cache_size = 256 M Current query_cache_used = 19 M Current query_cache_limit = 1 M Current Query cache Memory fill ratio = 7.64 % Current query_cache_min_res_unit = 4 K Query Cache is…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… = 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… innodb_use_sys_malloc = 0 long_query_time = 8 #log-slow-queries = /var/log/mysql-slow-query.log # Default to using old password…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
… Querys] #log-slow-queries = /var/log/mysqlslowq.log #long_query_time = 5 #log-queries-not-using-indexes [Cache] query_cache_type = 1 query_cache_size = 64M query_cache_limit = 64M thread_cache_size = 70 table_cache = 2048 table_open_cache = 512…
Comment: MySQL Query Cache
July 20, 2011 By 70 Comments
… insets and updates commands. Is query_catch help me? right now on my server query cache values query_cache_limit = 524288 query_cache_size = 134217728 Qcache_hits/(Com… Qcache_not_cached 244851098 Qcache_queries_in_cache 32379 Qcache_total_blocks 83477 Could you please suggest me can I go for query_catch…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… SCSI RAID: [mysqld] long_query_time=5 skip-bdb skip-innodb skip-locking query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5 thread_cache_size…
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 39 Comments
… is available. i have set normal configuration in ini with query_cache=64mb and innodb_additional_mem_pool_size 16M innodb_flush… 120 max_heap_table_size 64M max_allowed_packet 16M query_cache_limit 2M query_cache_min_res_unit slave_net_timeout innodb_data_file… i make query_cache = 0 then the process is increased to 20 seconds instead of 15 seconds. so i set again query_Cache=64M…
