mysql - Should I RESET QUERY CACHE on a regular basis? -


i running website game. haven't touched such reseting query cache year game has been up, i'm working 5000-1million rows depending on table. being updated , things being inserted tables. if understand correctly, every insert or update clear cache table? that's searching online has found, don't know if that's true though or if should regularly reseting cache.

queries happened month ago no longer useful now. if it's storing query results it's worthless because chances no 1 going run same exact query again.

i ran show status "qcache%" , results were:

qcache_free_blocks 6941

qcache_free_memory 23490288

qcache_hits 253269763

qcache_inserts 368937684

qcache_lowmem_prunes 57410566

qcache_not_cached 9872266

qcache_queries_in_cache 35275

qcache_total_blocks 84877

i don't know things mean or if useful in determining whether or not need reset cache. in advance.

the manual didn't lie you, queries alter data in table invalidate cache entries reference table. never have manually flush cache.

if data updated queries never last in cache, or same query run infrequently it's not useful cache it, you're wasting huge amounts of memory , cpu time checking , invalidating cache entries on every insert , update query. see performance increase turning off query cache.


Comments

Post a Comment

Popular posts from this blog

apache - Add omitted ? to URLs -

i working on website cms reads page name of query string, e.g. http://exmaple.com/?pagename . trying create rewrite rule rewrite ? . so, user types in /pagename , taken /?pagename try this: rewriteengine on rewritecond %{request_filename} !-d rewritecond %{request_filename} !-f rewriterule ^/?(.*) index.php?$1 [l]
Read more

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

i using bbpress installation without wordpress integration. the redirect of rewriteengine @ forum site works: rewriteengine on rewritecond %{http_host} ^forum.mysite.com$ rewriterule (.*)$ http://www.forum.mysite.com/$1 [r=301,l] the problem login pppress. bbpress login not recognize: http://www.forum.mysite/bb-login.php . it redirects to: http://forum.mysite.com/bb-login.php . i tried permalink settings none , name based, same issue. does uses redirect in bbpress or how can eliminate "double" content , redirect permanently www.? i redirected www.forum.mysite.com forum.mysite.com , achieved eliminate "double" content.
Read more

php - How can I stop spam on my custom forum/blog? -

so have custom built forum & blog system of late has been dealing lot of spam. if wordpress use akismet, if different common platform i'm sure i'd find plugin. there kind of static class can download this? using php. i'd still go akismet, if it. uses outside of wordpress, may have pay fee it, depending on use -- check terms , conditions -- it's option , easy implement in php using api. use api key wordpress. com account access. basically, grab whichever php client library takes fancy -- use alex potsides' php5 library -- plug in key, , it's handful of lines of code. here's bare bones of validation straight 1 of live sites: ... if ($akismet) { $akismet->setcommentauthor($name); $akismet->setcommentauthoremail($session->userinfo["email"]); $akismet->setcommentauthorurl(""); $akismet->setcommentcontent($sentence);...
Read more