WP Breaks Database when 2 BIG UGGGGG !

  • site4

    (@site4)


    13 years, 3 months ago

    I have 24 working on 25 MU-Multi Site installs running and every thing was fine (Kudos 2 WP & MU-Multi Site) until…… I got to many users ? at about 2500 – 3000 the databases start being un-processable (to big ? for mySQL ?) at 7000+ users they even load, for example (a execute database repair from cpanel )will go clear off the CPanel page (is that a server issue ?) any way I tried every thing I can find Like casheing and compressing and I even upgraded my server account to a twice the size account (a much bigger one !) and I still can’t load mySQL it times out or ?? or it says the database has 7000+ tables why is that to many ? (from this post ” http://www.sitepoint.com/forums/showthread.php?p=4787558#post4787558 ” it does NOT sound like this is my problem ) Where do they Host I think I need a better mySQL host. I am on a HostGator reseller Silver account now. Where or what Host do they use ? and how much is it a month-year ?. My sites are all on separate cpanel accounts in said reseller account.

    In said post they refer to “We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 60,000 tables and about 5,000,000,000 rows.”

    I want a server with mySQL capability’s like that ! Where do I go who do I contact !

    Is there a way to keep this from happening ? Like splitting the database at every 2000th user added maybe ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • Andrea Rennick

    (@andrea_r)

    13 years, 3 months ago

    – turn of post revisions for starters, they will blow up your db with that many users.

    – get a VPS. Reseller accounts are not vps accounts.

    – split the db using one of these plugins:
    http://wordpress.org/extend/plugins/hyperdb/
    http://wordpress.org/extend/plugins/shardb/

    Thread Starter site4

    (@site4)

    13 years, 3 months ago

    I installed Hyper Database per instructions contained in it, but how do I know if it is working ? I think it broke it ? it says

    Parse error: syntax error, unexpected T_STRING, expecting ‘)’ in /home/shop4i/public_html/on/db-config.php on line 188 now ??

    line 188 is the password line do I need to change my password ? could it be because my password has a ( @ # ) sing in it ?

    I will have to take it back out until I know what is wrong.
    because that error is all that is showing ( u know white page, with just the error string showing )

    Thread Starter site4

    (@site4)

    13 years, 3 months ago

    PS.
    If I change my password and ( take out the ” @ ” sing and ” # ” sign )and then reinstall it, do you think it will work. Or am I doing something wrong ?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WP Breaks Database when 2 BIG UGGGGG !’ is closed to new replies.