Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 45

Thread: Slow loading

  1. #21
    Guild Member sigurdbjohansson's Avatar
    Join Date
    Aug 2010
    Location
    Oslo, Norway
    Posts
    82

    Default

    Yeah, I'm up to nearly a minute on the main page, and around twenty seconds for forum pages. Gets annoying after a while
    -Sigurd Sigurd Brutus Motor-



  2. #22
      Redrobes is offline
    Software Dev/Rep Redrobes's Avatar
    Join Date
    Dec 2007
    Location
    England
    Posts
    4,763
    Blog Entries
    4

    Default

    Look at whos online. 10 members 100+ guests. Look at the list and the Baidu spider dominates. Can we limit the number of Baidu connections. Its not like we have a plethora of Chinese members. Probably less than 1% of members are Chinese and its taking probably half the bandwidth.

    If it were me, id just dump the Baidu spider altogether. In fact, if I could, I would limit it to 10 spiders of any type on a first come first serve basis and 403 the rest.

  3. #23
      bartmoss is offline
    Publisher Gracious Donor
    Facebook Connected
    bartmoss's Avatar
    Join Date
    Mar 2008
    Location
    Berlin, Germany
    Posts
    888
    Blog Entries
    1

    Default

    Quote Originally Posted by RobA View Post
    The host is a VPS, and the database is shared... and we can't do much diagnostics. The price of a dedicated sql is quite high for the size we have

    I've been adding some of the obvious indices to try and speed up the sql server...

    EDIT - though I came in today the first time in a few days and was loading the front page in under 3 seconds....

    -Rob A>
    How big is the SQL database?

    MySQL and Postgres are free and scale quite well.

    It's really bad again today... :-(

  4. #24
      Jaxilon is offline
    Community Leader Gracious Donor Jaxilon's Avatar
    Join Date
    Nov 2009
    Location
    Arizona
    Posts
    3,914

    Default

    Last night/early this morning around 1am or so Arizona time I couldn't get on at all. I guess either we were down for maintenance or something between me and the site was completely out?

    I was so relieved when I was able to get in just now. For a moment there I thought, "OH NOOOOOO!"
    “When it’s over and you look in the mirror, did you do the best that you were capable of? If so, the score does not matter. But if you find that you did your best you were capable of, you will find it to your liking.” -John Wooden

    * Rivengard * My Finished Maps * My Challenge Maps * My deviantArt

  5. #25
      torstan is offline
    Community Leader Facebook Connected torstan's Avatar
    Join Date
    Jul 2007
    Posts
    4,142

    Default

    Yesterday Arcana altered some of the cache settings which caused a large portion of the site cache to be rebuilt. That probably explains yesterday's problems, but it should be much better today. How's it looking to everyone? I know my load times seem quicker today.
    Fantasy Map Blog | My food illustration
    Everything I post is free for use and redistribution under the Creative Commons Attribution-Noncommercial-Share Alike 3.0 licence, except where noted otherwise in the thread.

  6. #26
      RobA is offline
    Administrator RobA's Avatar
    Join Date
    Apr 2007
    Location
    Niagara, Canada
    Posts
    5,530

    Default

    We are also on a trial on a dedicated mysql server, so some of yesterday's performance issues were related to transferring the database.... all 1.6GB of it...while leaving the site up.

    -RobA>

  7. #27
      bartmoss is offline
    Publisher Gracious Donor
    Facebook Connected
    bartmoss's Avatar
    Join Date
    Mar 2008
    Location
    Berlin, Germany
    Posts
    888
    Blog Entries
    1

    Default

    Today seems MUCH better than usual.

  8. #28
      bartmoss is offline
    Publisher Gracious Donor
    Facebook Connected
    bartmoss's Avatar
    Join Date
    Mar 2008
    Location
    Berlin, Germany
    Posts
    888
    Blog Entries
    1

    Default

    PS: if it's mysql, what table types are you using? This may be too obvious, so my apologies in advance, but if you have MyISAM check carefully what they are used for, because MyISAM only does table locking. I have seen this myself in one situation, if you have say a session table that constantly gets updated, and it's myisam, you'll kill your site with that.

  9. #29
      RobA is offline
    Administrator RobA's Avatar
    Join Date
    Apr 2007
    Location
    Niagara, Canada
    Posts
    5,530

    Default

    Quote Originally Posted by bartmoss View Post
    PS: if it's mysql, what table types are you using? This may be too obvious, so my apologies in advance, but if you have MyISAM check carefully what they are used for, because MyISAM only does table locking. I have seen this myself in one situation, if you have say a session table that constantly gets updated, and it's myisam, you'll kill your site with that.
    We are using InnoDB tables where possible to deal with this, though it is an overhead trade-off.

    -Rob A>

  10. #30
      Arcana is offline
    Administrator Facebook Connected Arcana's Avatar
    Join Date
    Mar 2006
    Location
    Fairborn, OH
    Posts
    2,772
    Blog Entries
    5

    Default

    I just found something weird...the vb_cache table was 1.2 Gigabytes in size...just for the table...

    So I cleared the cache and it dropped down to 300K...Home page load times should be significantly faster now, because there was a cache query that took 3 minutes to load.

    Also, I think we're goign to look into keeping it MyIsam and going with a Sphinx solution...I've read good reviews...more info to come.
    Robbie Powell - Site Admin

Page 3 of 5 FirstFirst 12345 LastLast

Posting Permissions

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