8 Multisites - 267,000 users - wp_usermeta 747mb & 9 million rows!

Hi WPMU Devs,

Ok so i have somehow got an insanely huge wp_usermeta table that is slowing the site down and causing it to run out of memory with login.php.

I imported users from joomla, so im not sure if thats what caused it but it seems like each user has loads of rows each. I am also using Multisite user management to make sure users are added to each subsite.

Please check the screenshot, is this normal? what can i do to have less rows?

  • Adam Czajczyk
    • Support Gorilla

    Hello Amit,

    I hope you're well today and thank you for your question!

    I'd like to know a bit more about the issue so could you please elaborate a bit regarding the questions below:

    1. How may users should there be actually? 267 000?
    2. How did you import them from Joomla: what tool(s) did you use and what was the process "step-by-step"?
    3. I understand that the site was previously powered by Joomla: how did it perform, was there any similar troubles?

    Please advise, it would be of great help if you could answer this questions with as many details as possible.


  • Amit
    • New Recruit

    Hi Adam,

    Thanks for the quick response, yeah there are actually around 276,000 users (20-30% could be spammers from the joomla install).

    The migration was done by a developer i hired as i wasn't confident in doing this at my level. There are a few plugins and methods he used but i'm not sure on the exact process taken.

    Before the import i created my admin account and the 8 subsites as well as installed the plugin 'multisite user management'. It seems strange that there are so many rows per user i think this is due to setting permissions for the subsites. Do you know if this is normal behaviour? judging from my screenshot.

    Happy to provide any login details - and allow support access.


  • Adam Czajczyk
    • Support Gorilla

    Hey Amit,

    I hope you're having a great day and thank you for answering my questions!

    I moved some sites from Joomla to WordPress but never experienced such problems. However, those sites haven't had that many users. That being said, I'd like to take a closer look at this, if I may. Could you please grant me a support access? To do so, go to your dashboard's

    "WPMU DEV" -> "Support" page -> "Support" tab

    and click on "Grant access". Please take a full backup of your site first! I know it might be quite a time-consuming task in this case but I'd rather not change any settings without knowing that your site's data is fully secured!


  • Amit
    • New Recruit

    Hi Adam,

    Thanks for getting back to me, but it took so long for you to come back i had to setup a job listing on WPMU! Luckily two people helped without asking for anything in return :slight_smile: I increased my memory limit from 1GB to 2GB (its extremely high for a wordpress site..) and then setup a cron job which solved the meta issues. So far so good no more errors.

    I was wondering if you could look into site speed which is still an issue, I have a decent VPS with 3.75gb of ram and 2gb allocated to the multisite with 8 subsites. There aren't too many plugins either - I am not sure but i think that the login check is taking long with domain mapping, or it could be the large database.

    I have allowed support access to the site - i can't backup the database as its so large it just crashes halfway through. But you can go ahead with anything you feel can help.
    I believe that the wp_usermeta table is actually meant to have 9 million rows as each user is assigned a row for each site they signed up to.

    So i don't really know what i am asking for but i just kinda need a site 'check' from an expert to see where any slowdowns are occurring, and if there is any optimising i can do. Also will the Multi-DB help me with speed? (i only plan on ever having around 20 sites max)

    Thanks Adam

  • Adam Czajczyk
    • Support Gorilla

    Hello Amit,

    I hope you're well today and I'm sorry for the delay on my side!

    I've subscribed to this thread and setup a special flag on my e-mail account so I won't miss any posts again!

    As for the speed issue, if you'd like me to take a look at it, could you please send some information directly to me?

    Send in:

    Subject: "Attn: Adam Czajczyk"
    -WordPress admin username
    -WordPress admin password
    -login url
    -FTP credentials (host/username/password)
    -link back to this thread for reference
    -any other relevant urls

    Select "I have a different question" for your topic - this and the subject line ensure that it gets assigned to me.


    I apologize for the delay once again!

    Have a great day!

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.