PixelDad

  • Total activity 11
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 2

Activity overview

Latest activity by PixelDad

  • PixelDad commented,

    1. Community
    2. Miscellaneous
    3. MYSQL degrading over 24 hours period

    MYSQL slowed down again today and the query would not process or have a long delay. I feel like something is getting full. So the MSQL CPU starts from 27% then over 2 days it slowly go upto 100% C...

  • PixelDad commented,

    1. Community
    2. Miscellaneous
    3. MYSQL degrading over 24 hours period

    Below is our latest result. Could you recommend a good settings please? I have about 30 sites running magneto and woocommerce [mysqld] skip-name-resolve performance-schema = 1 datadir = /var/lib/...

  • PixelDad commented,

    1. Community
    2. Miscellaneous
    3. MYSQL degrading over 24 hours period

    I've noticed some warning with my new config 2022-03-05T12:31:32.851957Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 19919 (requested 120000) 2022-03-05T12:31:33.030089Z 0 [...

  • PixelDad commented,

    1. Community
    2. Miscellaneous
    3. MYSQL degrading over 24 hours period

    I'm very new to this script. Anything below that you suggest adjusting as priority? My latest config file, does it look OK? I've tuned. I have 8 CPU cores and 32GB RAM [mysqld] skip-name-resolve ...

  • PixelDad commented,

    1. Community
    2. Miscellaneous
    3. MYSQL degrading over 24 hours period

    I have 8 CPU Cores and 32GB of ram. When mysql degrading in speed I also noticed phpmyadmin was also slow at loading database tables. But low CPU and RAM utilisation is not high. Do I need to chan...

  • PixelDad commented,

    1. Community
    2. Miscellaneous
    3. MYSQL degrading over 24 hours period

    Hi, yes. I noted that Open tables: 4000 is reached almost instantly after mysql restart. Is that normal? mysql> SHOW GLOBAL STATUS LIKE 'Open_%'; +--------------------------+-------+ | Variable_n...

  • PixelDad commented,

    1. Community
    2. Miscellaneous
    3. MYSQL degrading over 24 hours period

    So having Open tables: 4000 is bad? I only restart SQL an hour ago and it's now max at 4000 already. I'm not sure if this is normal. [root@sydney ~]# mysqladmin proc status +------+-------------...

  • PixelDad created a post,

    MYSQL degrading over 24 hours period

    1. Community
    2. Miscellaneous

    Hi, MYSQL server slows down when running for more than 24 hours. I'm not sure if my SQL is getting full and why the speed is degrading\. Rebooting the server bring speed back to normal again. Belo...

    • PixelDad
    • 2 followers
    • 14 comments
    • 0 votes

  • PixelDad commented,

    1. Community
    2. Hyperscalers
    3. Best AWS Instance Type for cPanel, and other findings...

    Well, after trying practically them all, I believe the "C" series is the best as most of our server issues arise from the CPU getting overloaded. The t3 class does not seem to have a high enough o...