Search results

Yes I already know this, but I have implemented code that automatically caches a video after it is watched the first time and then uses the cached results for all subsequent views. At this point every video on the site is cached, so I expected to see a massive drop in mysql usage instead I'm...

Would "writing" to the database be things like INSERT and UPDATE queries? If so then that can't be the problem because people rarely interact with the website in that way. It's 90% VIEW queries. I'm the primary software developer although my hosting providers are the ones that have access to...

I don't understand. I thought RAM usage only increases when SQL queries are being made. If significantly less queries are being made why would the SQL RAM usage still remain high? I was literally told to use Memcache to solve this issue.

updated mysql usage stats

Last month my server crashed because I ran out of MySQL memory, I run a video streaming site that usually runs up to 7 SQL queries per watched-video, but in the last few weeks I have optimised my queries and used memcached to cache every video so that now only 2 queries are run per...