… can increase the size of the query cache in my.cnf. You do not want to make the cache too big though, the article explains… 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.
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…hard to prove, there actually is a very limited use for the statistics from which the ratio…cause) relationship between the counter events and the query‘s execution time. Alas, that correlation fools us… “key cache hit ratio.” This is a shame. When you are new to MySQL, trying to configure my.cnf, and…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
… MYISAM. My my.cnf variables were as follows on a 4GB RAM system, Red Hat Enterprise with dual 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…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
… honestly don’t know where to start. Here is our my.cnf: skip-name-resolve max_connections = 2000 skip-innodb log-bin…_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 = /usr/mysql…
Comment: MySQL Query Cache
June 28, 2010 By 69 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
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…my.cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query… | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | …query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…# /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set …= 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216…query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… file sql/slave.cc patching file sql/sql_cache.cc patching file sql/sql_class.cc patching … long_query_time AND min_examined_row_limit AND log_slow_filter. log-slow-queries[=name] Log slow queries to … logging. If you don’t specify it in my.cnf file, the remaining part of the configuration will …
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… the query cache and the table cache and the size needed for each thread (thread stack, etc)? Those take memory too. The query cache can… things that have no defined limits. It’s not something that’s worth worrying about much, in my opinion. I think it… initially setting up a my.cnf for a server, I usually calculate the Big Ones like the buffer pool, query cache etc; leave some…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf…opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather…on to quantify what are the limits of different operations for different levels…
