Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Advertise on LowEndTalk.com
Cpu vs RAM for Mysql Server.
New on LowEndTalk? Please read our 'Community Rules' by clicking on it in the right menu!

Cpu vs RAM for Mysql Server.

styxtrooperstyxtrooper Member

For a WP site with lots of posts which is a bottleneck that causes "Error Establishing a Database Connection"?

Comments

  • cazrzcazrz Member
    1. MySQL optimization
    2. For the topic I would consider RAM then storage/IOps
    3. Are you using some kind of a aggregator plugin? Throttle it or better yet trash it.
  • Cache and MySQL optimization.

    But, WordPress wise, the most probable cause is a bad plugin - one egotistic piece of shitware that slows everything.
    Disable all plugins and see if that works.
    Then, enable one by one, spaced by some hours or days and find which one is the culprit.

    I too had a site that was getting too slow and whatever (not WordPress).
    After reading about MySQL optimization and tweaking my.cnf, I didn't needed a new server, I've allocated more resources to MySQL (RAM essentially), and that solved almost every slowness.

    Thanked by 2RedSox styxtrooper
  • cazrzcazrz Member

    And here's another, if your site isn't very dynamic.
    WP static + bunnycdn

  • BharatBBharatB Member, Provider

    @styxtrooper said:
    For a WP site with lots of posts which is a bottleneck that causes "Error Establishing a Database Connection"?

    Make a Galera cluster, scale it when needed. Try https://cloudjiffy.com/ for your Wordpress. I've seen it running smoothly like butter :)

    Readydedis, LLC - Managed Dedicated Servers

  • @DrCornFlakes I'll look into my.cnf optimization. thanks.
    @cazrz My site has very minimal images and very slim css and js, its mostly query heavy with lots of custom taxonomies and acf fields.
    @BharatB I'll look into galera cluster, but I still have have no idea should the new cluster have high cores or ram.

  • cazrzcazrz Member

    @styxtrooper said:
    @cazrz My site has very minimal images and very slim css and js, its mostly query heavy with lots of custom taxonomies and acf fields.

    Cache + Wp static + bunnycdn

    Or try Redis/Memcached

  • BharatBBharatB Member, Provider

    @styxtrooper said:

    It all depends on the type of operations, just setup monitoring for your app like espego or new relic and see what is being hit most, you'll know what to do.

    Thanked by 1styxtrooper

    Readydedis, LLC - Managed Dedicated Servers

  • leapswitchleapswitch Member, Provider

    Error Establishing a Database Connection would be caused by

    1. Database server down
    2. Tables corrupted
    3. Max User Connections exceeded
    4. Max Connections exceeded

    Have you reviewed and ensured the above is not the case ?

    Leapswitch Networks - Affordable Managed and UnManaged VPS
    Pune/Mumbai, India - Asheville, USA - Lisbon, Portugal - Kiev, Ukraine - Barcelona, Spain - Frankfurt, Germany

  • It all depends on the type of operations.

    Thanks, I'll have to look into my own use case.

    @leapswitch Database server becomes inaccessible whenever there is a spike of people visiting in a short time. I have to reboot the server. Doesn't happen often, do you know what kindof db does imdb use, mine is similar with details about local movie, episodes, actors, directors an so on with each its own taxonomy and each actor, director having its own bio pages, movie listings, lots of queries you can say.

  • leapswitchleapswitch Member, Provider
    edited May 20

    @styxtrooper said:

    It all depends on the type of operations.

    Thanks, I'll have to look into my own use case.

    @leapswitch Database server becomes inaccessible whenever there is a spike of people visiting in a short time. I have to reboot the server. Doesn't happen often, do you know what kindof db does imdb use, mine is similar with details about local movie, episodes, actors, directors an so on with each its own taxonomy and each actor, director having its own bio pages, movie listings, lots of queries you can say.

    I have PMed you some additional questions. We handle 100,000 concurrent users on our Wordpress clusters regularly. Here is something we handled last week >

    Thanked by 1dosai

    Leapswitch Networks - Affordable Managed and UnManaged VPS
    Pune/Mumbai, India - Asheville, USA - Lisbon, Portugal - Kiev, Ukraine - Barcelona, Spain - Frankfurt, Germany

  • exception0x876exception0x876 Member, Provider

    If your database fits in RAM, there is a little benefit of adding more RAM. You're better off with adding CPU cores if that turns to be a limitation.

    However, with WP websites you should just use caching so your requests won't even hit the database.

    8-core VPS for $11.99/mo, 32GB RAM VPS for $15.99/mo - wishosting.com

    Affiliate program

  • kenhsongaokenhsongao Member without signature

    Optimize your code.

  • raindog308raindog308 Moderator

    BharatB said: Make a Galera cluster, scale it when needed

    That's a pretty big jump.

    exception0x876 said: If your database fits in RAM, there is a little benefit of adding more RAM.

    True, but that's a big if. How many people's DBs fit in memory? I suppose it might for a small WP site it might. And your statement is not strictly true because the DB uses additional memory for sorts, etc.

    kenhsongao said: Optimize your code.

    Probably not his code if he's running WP.

    styxtrooper said: which is a bottleneck

    Have you run mysqltuner.pl? That's both a script and a URL.

    Thanked by 2styxtrooper Jord

    For LET support, please visit the support desk.

  • Have you run mysqltuner.pl? That's both a script and a URL.

    I have not. I'll look up how to use it. Does it run on the background to catch queries?

  • donkodonko Member
    edited May 20

    CPU + MySQL Table Indexes.
    I had a problem like you with a Wordpress site having lot of post and only doing indexes on some tables solved my problem, i was wasting a lot of $$$ paying for servers and now i use only a CPX 4gb hetzner.

    This is my server before doing it, i was using redis to cache everything but if i run a purge everything goes down for like 1 hour with 99% cpu usage x_x

    Thanked by 1styxtrooper
  • imokimok Member

    Always check for /wp-admin/admin-ajax.php calls (in browser developer tools). Some plugins will try to store stats or something not needed with every page visit, overloading the server.

    Janitor @ Netflix
    CORONAVIRUS ALERT

  • raindog308raindog308 Moderator

    styxtrooper said: Does it run on the background to catch queries?

    No, it's an instance tuner - it tunes your configuration.

    For LET support, please visit the support desk.

  • I've been having issues all year with high traffic crashing my site. I have CPU: 2xXeon E5-2620 v3,
    RAM: 32 GB, 250GB SSD dedicated server which I upgraded to about 2 months ago.

  • @davidjablonski said:
    I've been having issues all year with high traffic crashing my site. I have CPU: 2xXeon E5-2620 v3,
    RAM: 32 GB, 250GB SSD dedicated server which I upgraded to about 2 months ago.

    How much traffic?
    Text/image pages, video, applications/services...?
    Custom made, "click-to-install" script (as WordPress)...?

Sign In or Register to comment.