SharDB and hosting

  • doollard

    (@doollard)


    10 years, 3 months ago

    hosting wrote me:

    It has come to our attention that your site is using an excessive amount of MySQL resources on your ******** account. This is causing performance problems not only on your own website, but for other customers that are on this same server. When left unchecked, it can potentially cause crashes or service interruptions and lead to additional downtime.

    Our research shows that server performance degrades when the MySQL usage is over 1000 tables and/or 3 GB on a single account or 1000 tables and/or 2 GB on a single database. In order to ensure optimal performance for your account and the others in your shared hosting environment, we request that you reduce the MySQL usage on your account to under these limits by …

    Your account information:
    Total MySQL Database Size: 295.07 MB
    Total MySQL Tables: 3495

    Largest MySQL Database Size: 130.65 MB
    Largest MySQL Table Count: 3066
    …

    Shardb not exceed the limit?

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

    (@andrea_r)

    10 years, 3 months ago

    Shard db spreads the load over multiple databases. It might help.

    It also might help if you upgraded to a vps.

    Thread Starter doollard

    (@doollard)

    10 years ago

    Hi
    line:

    slaves[] = compact(‘read’, ‘host’, ‘localhost’

    ‘read’ -what to write?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SharDB and hosting’ is closed to new replies.