Bloated Multisite solution

  • Resolved crankin91

    (@crankin91)


    9 years, 5 months ago

    I need help WP’ers! More advise really.

    I’m the sole “developer” (lacking serious programming knowledge) for a company. Our ultimate goal is to build a large site that does event management, learning management, forums, q&a and a few other things, no small order I know.

    I built a site to do all of this, but once all of the plugins, theme customisations and all the 600 users were all in place, it started to grind to a halt!

    My question is, what’s the best way to achieve this? Multisite with separate databases and split each part of the site up? Or is wordpress just not the solution?

    Kind Regards,

    Liam
    PS. sorry if this is the wrong section

Viewing 13 replies - 1 through 13 (of 13 total)
  • jkhongusc

    (@jkhongusc)

    9 years, 5 months ago

    You need to figure out why WP is “grinding to a halt” before you attempt any solution. Is it a low powered server, is it a database problem, is it WP, is it a plugin problem, etc. Most likely it is due to plugins. Also there are ways to increase performance, for example caching plugin.

    I recommend loading some performance plugins to measure performance.
    https://wordpress.org/plugins/p3-profiler/
    https://wordpress.org/plugins/query-monitor/

    jkhongusc

    (@jkhongusc)

    9 years, 5 months ago

    BTW, I still do not know when multisite is “bloated”. We run 300 sites, have thousands of (WP) users, with moderate traffic (millions hits per day); and we havent done anything special with our system configuration. We thoroughly vet our plugins before using on production. I believe we have about 60 plugins total.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    9 years, 5 months ago

    WordPress.com runs Multisite. Bloated is subjective 🙂

    I built a site to do all of this, but once all of the plugins, theme customisations and all the 600 users were all in place, it started to grind to a halt!

    Okay. What are your server specs?

    Thread Starter crankin91

    (@crankin91)

    9 years, 5 months ago

    Hi jkhongusc,

    I had no idea WP was capable of such feats, I think maybe I’ll just start from scratch then, during the process of getting the site up and running I tried many alternative plugins and then uninstalled them, perhaps the DB is still bloated from them? I don’t pretend to know anything about anything when it comes to actual developing, I’m just a designer.

    Moderator Bet Hannon

    (@bethannon1)

    9 years, 5 months ago

    I really don’t think you want to resort to “start from scratch” so quickly. Do a little detective work first to see if what you have can be rehabilitated.

    I would start with the the suggestions jkhongusc made for the two plugins that will give you some clues. If it’s just one or two plugins that are misbehaving, you can fix that quickly.

    Your many installed & uninstalled plugins might have left some db bloat, but I wouldn’t think that would grind your network to a halt.

    If this sort of detective work and database crawling isn’t your strong suit, then it might totally be worth finding some help (compared to the cost of starting over). That’s what I do! 😉

    Thread Starter crankin91

    (@crankin91)

    9 years, 5 months ago

    So on jkhongusc’s advice I installed P3, which let me see what was causing the issue, our LMS learndash seems to hog the most time, also woocommerce and event espresso, which is pretty much what I would expect.

    I had to uninstall P3 because strangely it started taking up 100% CPU usage on my hosted server.

    Does anyone know what might have caused that so I can get it reinstalled and diagnose my original issues?

    I’ve tried deactivating/reactivating

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    9 years, 5 months ago

    Okay. What are your server specs?

    See that question? 🙂 I’m serious, what are they? What kind of server, what OS, how much memory, how much CPU, what PHP, etc.

    Thread Starter crankin91

    (@crankin91)

    9 years, 5 months ago

    I didn’t actually, apologies.

    Here is all the detail I could gain from the hosts website, I’ll try to contact them for some more detailed info, but hopefully this gives you some kind of indication.

    Its a shared server with dedicated 50% of the total CPU power
    Memory: 2048MB
    Apache Version 2.4.10
    PHP Version 5.4.32
    MySQL Version 5.6.21
    Perl Version 5.10.1
    Architecture x86_64
    Operating System linux
    MySQL Databases 4
    MySQL Disk Space 91.71 MB
    Memory Usage
    74.6 / 2048 MB
    Entry Processes
    1 / 20
    Disk Space Usage
    7.96 GB / 19.53 GB

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    9 years, 5 months ago

    Wait, you’re running this on a shared host?

    Yeah, bad idea. I never recommend anyone run Multisite on less than a VPS. Do the math this way. If you were running the same number of separate sites, with the same traffic volume, on a shared box, would you expect zippy results? Probably not. Seven sites on a Multisite is the same usage as seven separate sites.

    Thread Starter crankin91

    (@crankin91)

    9 years, 5 months ago

    I definitely see where you’re coming from, but if it was an issue of lack of power from the host wouldn’t my CPU/memory usage be sitting higher? Pretty much every time I check all I get is
    CPU Usage
    0 / 100 %
    Memory Usage
    0 / 2048 MB

    Thread Starter crankin91

    (@crankin91)

    9 years, 5 months ago

    I decided to do some more digging, found some startling statistics in the cpanel

    http://prntscr.com/576zvs

    It looks like usage jumps between 0 and 100% constantly. Based on that, is it fair to say this is a hosting issue?

    I also had a look at the DB, it’s only got about 230 tables, the biggest of which is 4.4mb (some custom user info), nothing crazy or out of place.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    9 years, 5 months ago

    Just because the server has 2G of memory doesn’t mean you get to use all of that :/

    I would see if caching helps any, but 600 users on a shared host being this bad doesn’t surprise me at all 🙁 I would invest in a VPS.

    Thread Starter crankin91

    (@crankin91)

    9 years, 5 months ago

    I was more startled by the fact the CPU seems to constantly be on 100%.

    I’ve already got caching via supercache, it made a difference, but not much.

    I’ve just contacted a company about a VPS 4 cores and 2gb of memory. It looks like it’s going to be more pricey but if it speeds up the site it will be work it!

    Thanks for your help Mika

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Bloated Multisite solution’ is closed to new replies.