• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Recent content by Blooblabb21

  1. B

    Issue MySQL memory usage still rising even after installing Memcached

    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...
  2. B

    Issue MySQL memory usage still rising even after installing Memcached

    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...
  3. B

    Issue MySQL memory usage still rising even after installing Memcached

    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.
  4. B

    Issue MySQL memory usage still rising even after installing Memcached

    updated mysql usage stats
  5. B

    Issue MySQL memory usage still rising even after installing Memcached

    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...
See more
Back
Top