Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009

    slow and slow and boring

    hello folks ,

    i have a strange problem at my server ,

    i hosted 1 wesite ( forum script with no plugins )

    when my traffic consuption reache to 25mbs the server running very slow for hours although the load avarage is very normal 1-2 Iowait 3% ram consumption 8-10Gb

    my uplink port 1Gb and of course my DC said the connection is normal with no limitation

    the server specs are good
    Quad procs 7200 ,16Gb ram ,15K SCSI speed

    connections reache to 2000-2500 per seconds

    anybody advice !


  2. #2
    Join Date
    Dec 2006
    What version of mysql and what table type (myisam/innodb) do you use? Some older versions of mysql 5 have a threading issue in innodb that would cause this sort of symptoms with large numbers of concurrent threads.

    If your using myisam you may be suffering from lots of threads waiting for others to release table locks.

  3. #3
    Join Date
    Oct 2009
    thanks RBBOT for ur replay

    mysql version 5.0.81-community
    os = RHEL4
    tables type myisam


  4. #4
    Join Date
    Dec 2006
    When its busy, in mysql, run 'show processlist;'

    If it shows a lot of processes in a 'Locked' state, you probably need to change the table they are using to innodb so that it has row-level locking rather than table-level locking. Check the support community for your forum script- they can probably advise on which tables should be innodb.

    You should also read up on the innodb configuraiton settings and ensure they are suitable before changing a table type. In particular, make sure you have 1 table per file option on so that it doesn't put all innodb tables in one big file.

Similar Threads

  1. VPS incredibly slow, huge numbers of slow MySQL queries for Plesk/Watchdog
    By lumpysimon in forum Hosting Security and Technology
    Replies: 3
    Last Post: 11-11-2008, 12:31 PM
  2. slow internet connection, slow surfing...
    By Flumps in forum Web Hosting Lounge
    Replies: 2
    Last Post: 01-22-2006, 05:51 PM
  3. Slow dns resolutions. Slow initial connection
    By Instagator in forum Hosting Security and Technology
    Replies: 3
    Last Post: 12-04-2005, 12:42 AM
  4. New Rackshack Server - Slow Access, Then Fast, Then Slow
    By Garrett in forum Dedicated Server
    Replies: 28
    Last Post: 06-17-2003, 10:11 AM

Posting Permissions

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