I got 92 points at google page for my xenforo start page with advertisements enabled. If you have optimized your web presence, then mod_pagespeed doesnt have much to do.
I thought that as of 5.5, the suggestion was to not use query cache at all and thus avoid the single mutex? IIRC, since 5.5, the default is 0 or OFF: https://dev.mysql.com/doc/refman/5.5/en/query-cache-configuration.htmlOptimize MySQL. A query cache can help tremendously, but care must be taken to not "overoptimize" it - if a query cache uses too much memory, it can quickly negate the performance effect into a loss
Anyone have any more info on this?If query_cache_size is 0, you should also set query_cache_type variable to 0. In this case, the server does not acquire the query cache mutex at all, which means that the query cache cannot be enabled at runtime and there is reduced overhead in query execution.
Well, not everyone is on 5.5 and the suggestion is valid for cases where a query cache would *not* help at all. In that case, you can speed up MySQL a tiny bit more by completely disabling the query cache at startup time.I thought that as of 5.5, the suggestion was to not use query cache at all and thus avoid the single mutex? IIRC, since 5.5, the default is 0 or OFF: https://dev.mysql.com/doc/refman/5.5/en/query-cache-configuration.html
Two completely different pair of shoes, but if an application cleverly uses its own caching (memchached/xcache/apc/whatever) to cache query results, it can help a lot, yes. Fetching a serialized query result from from memcached is almost always much faster than fetching it from the db even if the query was cached by the database server.I've also read on the documentation that you don't need to enable query cache if memcache(d) is installed. Any thoughts on that ?
We use essential cookies to make this site work, and optional cookies to enhance your experience.