…cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf…buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries,…going on to quantify what are the limits of different operations for different levels of…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…version: 5.0.79-enterprise-log MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/…table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…version: 5.0.79-enterprise-log MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/…table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… number of threads that can enter InnoDB is limited by innodb_thread_concurrency (which is why …lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1…max_dirty_pages_pct=90 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
…t know where to start. Here is our my.cnf: skip-name-resolve max_connections = 2000 skip-…size = 32M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 64 query_cache_limit = 0 #query_cache_size = 64M query_cache_size = 0 query_cache_type = 0 join_buffer_size = 512K log_slow_queries…
Comment: MySQL Query Cache
June 28, 2010 By 70 Comments
> How to expand mysql query cache? What about changing the settings in my.cnf to whatever you need? query_cache_limit = 150K query_cache_size = 512M query_cache_type = 1
Comment: MySQL Query Cache
June 28, 2010 By 70 Comments
Robin, You can increase the size of the query cache in my.cnf. You do not want to make the cache too big though, the article… just to increase the query cache, then it might be that you’ve misunderstood the limitations of it. memcache cannot cache sql results directly… them in memcache, and then check memcache before running the query next time.
