…freezes routinely for half a second, then it’s occasionally going to freeze for much longer than that. Knowing whether it’s freezing…size, or something like that. It suddenly caused the query cache to become an enormous bottleneck. The query cache… where improvements to the MySQL source code are …
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
… the master db is freezing up. Its replicating to 2 slave servers. When it freezes up it’s top state…_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/logs/mysql-slow….
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… a situation where mysql reports max connections reached and freezes, with a bunch of processes waiting to finish. Also, mysql will not shut… long-query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_size = 2000M…
