Hosting Plan MySQL database size limit exceeded

  • Resolved paolomx

    (@paolomx)


    4 years, 5 months ago

    Hi,

    I just exceeded MySQL database size limit (1000 GB) but I wrote just 260 post and everything is pretty clean.
    I have the doubt that a staging-site plugin has doubled some content and some tables.
    If I go and check in PHPmyAdmin I see two rows called wpsa0_posts (795 Mib) and wpsm0_posts (751 Mib) and if I look inside the content is the same.
    Can they be the same posts doubled? How do I know which one I should delete?
    Thank to those will be so kind to help me 🙂

    • This topic was modified 4 years, 5 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    4 years, 5 months ago

    Moved to Fixing WordPress, this is not an Everything else WordPress topic.

    I just exceeded MySQL database size limit (1000 GB) but I wrote just 260 post and everything is pretty clean.

    Find a better host?

    *Drinks coffee*

    I don’t want to get into a hosting conversation as that would get the topic closed pronto but your shared hosting plan may not be sufficient for your needs.

    Matias Benedetto

    (@mmaattiiaass)

    4 years, 5 months ago

    Hi, @paolomx It sounds very weird that 260 WordPress posts take 750Mib. In such space you would be able to store A LOT of posts (tens of thousands at least).

    I would review this database to know if there are other tables used for other purposes than WordPress.

    Thread Starter paolomx

    (@paolomx)

    4 years, 5 months ago

    Hi Matiasbenedetto, thank you very much for your reply. I manage to solve the problem. the plugin staging site pro had doubled my content and I didn’t realize it. I just cancelled all the folders in the database starting with wpsa0_posts and wpsm0_posts.

    Thank you again! 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Hosting Plan MySQL database size limit exceeded’ is closed to new replies.