SitePoint Sponsor

User Tag List

Results 1 to 13 of 13

Thread: MySQL overload

  1. #1
    Non-Member MrLister's Avatar
    Join Date
    Feb 2001
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL overload

    for my gaming site i'm planning on adding a forum (topic) to each game. and inside probably sub-forums. this i will make it do automatically when a game cheat, review or preview has been approved. so there will probably be around 2000. would this overload mysql? also which board should i use. vbulletin seems good for the job but it's database is maybe already too overloaded. please help.

  2. #2
    SitePoint Wizard Defender1's Avatar
    Join Date
    Apr 2001
    Location
    My Computer
    Posts
    2,808
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh god no.
    how many posts do you think this forum has?
    Defender's Designs
    I'm Getting Married!

    Not-so-patiently awaiting Harry Potter Book 7 *sigh*

  3. #3
    Non-Member MrLister's Avatar
    Join Date
    Feb 2001
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    it's not up yet but once it is i'm guessing no more then 5 per forum if you avrage it. some will get 100s, some 1000s and some none. btw when you said "oh god no" did you mean it in the sense of that's a bad idea or it will not be overloaded?

  4. #4
    SitePoint Wizard Defender1's Avatar
    Join Date
    Apr 2001
    Location
    My Computer
    Posts
    2,808
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    in the sense that mysql can handle serveral million records.

    i doubt you'll hit it's max for a while.
    Defender's Designs
    I'm Getting Married!

    Not-so-patiently awaiting Harry Potter Book 7 *sigh*

  5. #5
    Non-Member MrLister's Avatar
    Join Date
    Feb 2001
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh that's great. thx for the help

  6. #6
    Victory shall be mine tubedogg's Avatar
    Join Date
    Mar 2001
    Location
    Medina, OH
    Posts
    440
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MySQL might be able to handle it but you need to ask yourself if you are going to get 5 posts per forum, is it worth having all those forums? As Wayne Luke stated somewhere, he will only start a new forum if he knows he can fill it. I think you should heartily consider condensing a number of those together, maybe by genre, maybe by developer/publisher, maybe by game popularity (so you can at least fill the forums you have).
    Kevin

  7. #7
    Non-Member MrLister's Avatar
    Join Date
    Feb 2001
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    that's a great idea. now i will probably make it so the game needs at least 300 views before a forum is made.

  8. #8
    SitePoint Wizard johnn's Avatar
    Join Date
    Mar 2001
    Location
    Southern California, USA
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    One time while browsing this forum, I had a message "server is busy at the moment. Please try again". So, I clicked on "Build" link to go to Webmasterbase.com, at the bottom it had this statement "There are currently 36 members and 55 guests on the forums." So, that's about 100 users.

    To me "server is busy" means overloading. Does that mean Mysql can handle thousands of concurrent users, but the physical server machine being used here can handle only about 100 concurrent users and no more than that number of users?

    John

  9. #9
    Victory shall be mine tubedogg's Avatar
    Join Date
    Mar 2001
    Location
    Medina, OH
    Posts
    440
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think I have heard that the practical limit to MySQL is about 800 to 1000 concurrent users.

    vBulletin allows the forum administrator to set an option to display the message you received when either a) the 'load' on a server hits a certain number, or b) the number of users hits a certain number. The machine here is fairly powerful but it is hosting all five SitePoint sites, and Wayne had/has the limit in vBulletin set pretty conservatively so as not to max out the machine.
    Kevin

  10. #10
    Victory shall be mine tubedogg's Avatar
    Join Date
    Mar 2001
    Location
    Medina, OH
    Posts
    440
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Also, MrLister, you will want to disable the forumjump or your pages will spend *forever* loading.
    Kevin

  11. #11
    SitePoint Wizard johnn's Avatar
    Join Date
    Mar 2001
    Location
    Southern California, USA
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks.
    vBulletin allows the forum administrator to set an option to display the message you received when either a) the 'load' on a server hits a certain number, or b) the number of users hits a certain number
    I'm new to this, what should I learn to do all this? Is that about Linux administration or Apache administration?

    Thanks,
    John

  12. #12
    Non-Member MrLister's Avatar
    Join Date
    Feb 2001
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks for the tip. will do. any other things i should watch out for?

    Originally posted by johnn
    Thanks.


    I'm new to this, what should I learn to do all this? Is that about Linux administration or Apache administration?

    Thanks,
    John

  13. #13
    Non-Member MrLister's Avatar
    Join Date
    Feb 2001
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Incase sensitive. if users submit cheats and reviews and one spells it a bit differently. i don't want 2 forums made for same game except for one minor spelling error. any way to fix that or go around it?
    Last edited by MrLister; Jun 17, 2001 at 07:35.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •