WordPress.org

Forums

I would love for plugins to state if and how many tables they add. (19 posts)

  1. 12sp
    Member
    Posted 2 years ago #

    I actually think it should be required, since database size (how many tables) is a big issue for hosts.

    In the FAQ or doc notes it should what the tables are called since deleted a plugin usually leaves the tables behind.

  2. 12sp
    Member
    Posted 2 years ago #

    I sorry, I wanted to also say that I'd like it to be post on the wordpress.org site plugin posts.

  3. Barry Hughes
    Member
    Posted 2 years ago #

    The thing with that is, Plugin X could add 50 new tables and potentially they'd consume less space than your entire posts table.

    Also, what if all of those 50 new tables have a fairly small footprint per row - it may well have less impact than Plugin Y which might regularly dump huge amounts of serialized data into your options table.

    That's all hypothetical of course, but my point is I just don't think it's a great measure of how much space will be consumed.

  4. michael.mariart
    Member
    Posted 2 years ago #

    I've got to agree. I've got a database (not part of a WP site) that has 200 tables that total about 50KB with one main data table that's currently sitting around 1.2GB. This may be a little extreme but it's a good example of why number of tables will never be a good indication of possible storage use.

    Number of tables is not the issue, it's the amount of data that's added to those tables, and that will always be completely dependant on how the users site uses which ever plugin it is.

    Another thing to remember is that (with most hosts as least) hosting is not exactly expensive these days, so upgrading to a plan with more storage is not the same big deal that it was 5 or 10 years ago. If your site does well enough to store enough data to go beyond your current hosting requirements, you should be happy that it's that popular!

  5. 12sp
    Member
    Posted 2 years ago #

    Unfortunately, hosts don't agree about the tables in a database. When you hit a certain number - regardless of how much data is used they either shut you down or you pay quite a bit more.

  6. Barry Hughes
    Member
    Posted 2 years ago #

    I'm astonished to hear that, to be honest.

    I can't resist asking with which hosts (and hosting packages) you have experienced this - and just how many tables did you have running when this happened?

  7. esmi
    Forum Moderator
    Posted 2 years ago #

    Ditto! I've never heard of a host imposing a table limit on a database. Overall size, yes but not number of tables.

  8. michael.mariart
    Member
    Posted 2 years ago #

    Unfortunately, hosts don't agree about the tables in a database. When you hit a certain number.

    Who??? Can you tell me exactly where you've seen this policy before?

    I have never seen this after working with around 100 different companies over the last decade. DB size, sure, they count that. Number of tables has never been an issue that I've seen.

  9. 12sp
    Member
    Posted 2 years ago #

    I don't want to get in trouble for posting the host name, but it is one that wordpress has listed in its recommended hosting page.

    It's a mulitsite. When it hit 100 tables they emailed me. I moved a static site over to wordpress and did a lot of plugin playing at first - they left a crap load of unused tables behind after I deleted the plugins I didn't care for or need. It was a pain the in arse to find the unused table but I did and brought the count way down.

  10. esmi
    Forum Moderator
    Posted 2 years ago #

    If you feel uncomfortable naming the host on a public forum, please feel free to email me directly via esmi [at] quirm [dot] net and I can look into this for you.

  11. 12sp
    Member
    Posted 2 years ago #

    I'll email you. I got "yelled" at for mentioning a host in the forums in the past.

  12. esmi
    Forum Moderator
    Posted 2 years ago #

    Not got the email thus far. If you prefer, there's a contact form on my site that you can use. The mail will come straight to me and no one else.

  13. 12sp
    Member
    Posted 2 years ago #

    Hum... will use your contact form. Thanks.

  14. esmi
    Forum Moderator
    Posted 2 years ago #

    Given that we're actually talking about 995 tables (not 99), then your hosts are correct. A db of this size is going to cause problems. Have a look at http://codex.wordpress.org/HyperDB which would allow you to spread the data across multiple databases.

  15. 12sp
    Member
    Posted 2 years ago #

    Thanks. You can't spread them across the several databases with the host.I mean you can, but with won't make a difference. It's an all inclusive number for all databases for an account. I did ask them about that.

  16. Barry Hughes
    Member
    Posted 2 years ago #

    I've no idea what sort of hosting plan we're discussing here, but if you have to run with so many tables for whatever reason and you can't find a conventional host who will accommodate that (I'm making an assumption that you're trying to do this on a shared hosting plan?) then perhaps you should look into rolling your own setup on a virtual/dedicated box.

  17. 12sp
    Member
    Posted 2 years ago #

    I would love to but the cost is prohibitive right now. Some day...

    Yes, it is shared.

    Sidetrack...
    I have a multisite. The sub sites all have a different look. When I first looked into setting this up that was I the forums here recommended. There are 26 (I think subsites). The only plugin I currently use that adds tables is the relevanssi search(5 per blog). It adds up quick. I don't see any reason in the foreseeable future to add new anything except content.

    But anywho, that's why I'd like to know how many tables a plugin will add before I even test it out.

  18. Pete
    Member
    Posted 2 years ago #

    I had gone over my limit with hostmonster who also has a 1000 table limit. They are basically the same company as BlueHost. Their tech support are very helpful when this happens, you can ask them to generate a file that will list each database in your account and the quantity of tables each has.

  19. 12sp
    Member
    Posted 2 years ago #

    Thanks. I got set up with the phpadmin (its that the right title, that gives you access to your database). That helped me immensely when looking for unused tables from old plugins.

    Side note: I almost popped a gasket when I found one plugin I tried that left 15 tables per blog. It was ridiculous.

Topic Closed

This topic has been closed to new replies.

About this Topic