Announcement

Collapse
No announcement yet.

Server becoming super bogged

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Server becoming super bogged

    Hey all, this is Dave from TutorialForums...

    It seems my server (dedicated with rackshack - amd duron 1ghz, 512mb ram, 20gb 5400rpm drive, running Plesk 2.0) has been having some pretty serious trouble keeping up lately... however the traffic level on the forum/server has not changed all that much. With an average number of members online (40-60 I'd say) the server load is always well above 1.0 now... often around 8+ (as you can see in the top output I'll post in a moment) and has even hit as high as 60+. Usually restarting Plesk (or at least apache and mysql) brings it back down, but it goes right back up within a few days. I thought it "might" have something to do with the size of the database, since it's definately growing very bulky (phpmyadmin reports 290MB).... but I have no idea if that would actually affect it like this.

    I know I need more RAM (in fact I'm looking into a whole new server asap) but I'm sure that my system is probably massively misconfigured, and could probably handle a good deal more if it were optimized. I am using the /etc/my.cnf that Eva2000 gave me a number of months ago, but almost all the rest of the configurations are default, or "something" (I think there's some really wacky stuff in there hehe). Anyhow... I'll post some various stats and configurations that I have, and if you need additional, please let me know.

    phpinfo
    http://www.tutorialforums.com/phpinfo.php (yeah I know I need some upgrades)
    Top output
    3:36pm up 11 days, 15:20, 1 user, load average: 8.73, 4.05, 2.86
    539 processes: 532 sleeping, 7 running, 0 zombie, 0 stopped
    CPU states: 72.5% user, 27.4% system, 0.0% nice, 0.0% idle
    Mem: 496672K av, 484340K used, 12332K free, 64K shrd, 4844K buff
    Swap: 1028120K av, 279640K used, 748480K free 116308K cached

    PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
    7402 mysql 14 0 119M 40M 23544 R 9.1 8.3 5:46 mysqld
    7414 mysql 18 0 119M 40M 23544 R 8.9 8.3 3:28 mysqld
    28956 mysql 20 0 119M 40M 23524 R 8.8 8.3 13:55 mysqld
    25256 mysql 14 0 121M 44M 26032 R 8.7 9.2 6:46 mysqld
    28639 admin 19 0 1412 1412 836 R 6.0 0.2 0:06 top
    24873 mysql 14 0 119M 43M 26584 R 4.5 8.9 8:11 mysqld
    28967 mysql 12 0 119M 40M 23528 S 4.2 8.3 4:17 mysqld
    7415 mysql 20 0 119M 40M 23544 R 4.0 8.3 3:17 mysqld
    28230 apache 9 0 7940 5928 3600 S 1.7 1.1 0:01 httpd
    27914 apache 9 0 7516 5588 3676 S 1.6 1.1 0:00 httpd
    20867 apache 9 0 9380 7064 6192 S 1.4 1.4 1:44 httpd
    28674 apache 9 0 7244 5268 3576 S 1.4 1.0 0:00 httpd
    28670 apache 9 0 7628 5616 3532 S 1.1 1.1 0:00 httpd
    5 root 9 0 0 0 0 SW 0.9 0.0 16:18 kswapd
    28391 apache 9 0 7632 5700 3676 S 0.9 1.1 0:00 httpd
    27902 apache 9 0 6428 4476 3648 D 0.8 0.9 0:01 httpd
    23466 apache 9 0 9384 6788 5688 S 0.7 1.3 9:27 httpd
    3756 apache 9 0 9252 6128 5288 S 0.7 1.2 1:36 httpd
    28624 apache 9 0 6428 4464 3640 S 0.7 0.8 0:00 httpd
    2963 apache 9 0 10016 7736 7156 S 0.6 1.5 21:12 httpd
    7494 mysql 9 0 109M 29M 22176 S 0.6 6.0 2:03 mysqld
    9172 apache 9 0 9180 6980 5512 S 0.6 1.4 2:08 httpd
    28823 apache 9 0 6432 4412 3596 S 0.6 0.8 0:00 httpd
    28857 apache 9 0 7428 5396 3572 S 0.6 1.0 0:00 httpd
    30048 mysql 9 0 119M 43M 26584 S 0.5 8.9 9:06 mysqld
    7033 apache 9 0 8256 5948 4680 S 0.5 1.1 2:36 httpd
    6379 apache 9 0 8964 5880 4708 S 0.5 1.1 0:58 httpd
    28229 apache 9 0 6096 4120 3496 S 0.5 0.8 0:00 httpd
    28591 apache 9 0 6512 4540 3580 S 0.5 0.9 0:00 httpd
    28641 apache 9 0 6424 4392 3576 S 0.5 0.8 0:00 httpd
    28858 apache 9 0 6296 4188 3436 D 0.5 0.8 0:00 httpd
    1430 apache 9 0 9576 6880 6044 S 0.4 1.3 7:26 httpd
    28589 apache 9 0 6276 4324 3576 D 0.4 0.8 0:00 httpd
    472 mysql 9 0 121M 44M 25888 S 0.3 9.2 3:50 mysqld
    29409 mysql 9 0 121M 43M 24596 S 0.3 8.9 7:37 mysqld
    29017 mysql 9 0 119M 40M 23528 S 0.3 8.3 5:03 mysqld
    5721 mysql 13 0 119M 40M 23536 S 0.3 8.3 8:46 mysqld
    7770 mysql 9 0 109M 29M 22176 S 0.3 6.0 4:44 mysqld
    7871 apache 9 0 8544 5624 5168 S 0.3 1.1 15:46 httpd
    1427 apache 9 0 9352 5804 5240 S 0.3 1.1 7:09 httpd
    3232 apache 9 0 9332 6948 5980 S 0.3 1.3 1:10 httpd
    19866 apache 9 0 7640 5620 4940 S 0.3 1.1 0:03 httpd
    25985 apache 9 0 6492 4484 3680 S 0.3 0.9 0:00 httpd
    28659 apache 9 0 5680 3452 3192 D 0.3 0.6 0:00 httpd
    28677 apache 9 0 6404 4360 3564 S 0.3 0.8 0:00 httpd
    28813 apache 9 0 6032 3864 3408 D 0.3 0.7 0:00 httpd
    28863 apache 9 0 6024 3856 3412 D 0.3 0.7 0:00 httpd
    28871 apache 9 0 6248 4196 3524 S 0.3 0.8 0:00 httpd
    24595 mysql 9 0 117M 41M 26804 S 0.2 8.6 6:33 mysqld
    13044 mysql 9 0 121M 45M 26484 S 0.2 9.3 10:32 mysqld
    6625 apache 9 0 7656 5608 4140 S 0.2 1.1 0:18 httpd
    28224 apache 9 0 6188 4220 3476 S 0.2 0.8 0:00 httpd
    28566 apache 9 0 6296 4200 3460 S 0.2 0.8 0:00 httpd
    28644 apache 9 0 5964 3824 3404 S 0.2 0.7 0:00 httpd
    28650 apache 10 0 6584 4612 3644 D 0.2 0.9 0:00 httpd
    28866 apache 9 0 6164 4088 3468 S 0.2 0.8 0:00 httpd
    28870 apache 9 0 6300 4248 3492 D 0.2 0.8 0:00 httpd
    28889 apache 9 0 6300 4244 3504 D 0.2 0.8 0:00 httpd
    484 root 9 0 600 544 504 S 0.1 0.1 24:04 syslogd
    794 qmails 9 0 684 608 548 S 0.1 0.1 19:52 qmail-send
    798 qmaill 9 0 468 444 396 S 0.1 0.0 11:30 splogger
    800 qmailr 16 0 364 328 308 D 0.1 0.0 14:36 qmail-rspawn
    /etc/my.cnf contents (from Eva)
    [client]
    port = 3306
    socket = /tmp/mysql.sock

    [mysqld]
    port = 3306
    socket = /tmp/mysql.sock
    skip-locking
    set-variable = max_connections=600
    set-variable = key_buffer=16M
    set-variable = myisam_sort_buffer_size=64M
    set-variable = join_buffer=2M
    set-variable = record_buffer=2M
    set-variable = sort_buffer=3M
    set-variable = table_cache=1024
    set-variable = thread_cache_size=256
    set-variable = wait_timeout=7200
    set-variable = connect_timeout=10

    [safe_mysqld]
    open_files_limit=8192

    [mysqldump]
    quick
    set-variable = max_allowed_packet=64M

    [myisamchk]
    set-variable = key_buffer=64M
    set-variable = sort_buffer=64M
    set-variable = read_buffer=16M
    set-variable = write_buffer=16M
    httpd.conf items (untouched)
    Timeout 300
    KeepAlive On
    MaxKeepAliveRequests 1000
    KeepAliveTimeout 15
    MinSpareServers 5
    MaxSpareServers 10
    StartServers 5
    MaxClients 2048
    MaxRequestsPerChild 0
    HostnameLookups Off
    Mysql extended status
    +--------------------------+------------+
    | Variable_name | Value |
    +--------------------------+------------+
    | Aborted_clients | 5033 |
    | Aborted_connects | 151 |
    | Bytes_received | 1661786392 |
    | Bytes_sent | 629237969 |
    | Connections | 773305 |
    | Created_tmp_disk_tables | 263145 |
    | Created_tmp_tables | 487358 |
    | Created_tmp_files | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Delayed_errors | 0 |
    | Flush_commands | 1 |
    | Handler_delete | 67943 |
    | Handler_read_first | 3213113 |
    | Handler_read_key | 332758001 |
    | Handler_read_next | 1305324822 |
    | Handler_read_prev | 1099554 |
    | Handler_read_rnd | 49294307 |
    | Handler_read_rnd_next | 3411910294 |
    | Handler_update | 218322586 |
    | Handler_write | 96200954 |
    | Key_blocks_used | 15582 |
    | Key_read_requests | 345853997 |
    | Key_reads | 54763 |
    | Key_write_requests | 2045769 |
    | Key_writes | 1884274 |
    | Max_used_connections | 474 |
    | Not_flushed_key_blocks | 0 |
    | Not_flushed_delayed_rows | 0 |
    | Open_tables | 518 |
    | Open_files | 3709 |
    | Open_streams | 0 |
    | Opened_tables | 658 |
    | Questions | 20894141 |
    | Select_full_join | 31 |
    | Select_full_range_join | 0 |
    | Select_range | 1245864 |
    | Select_range_check | 0 |
    | Select_scan | 7423586 |
    | Slave_running | OFF |
    | Slave_open_temp_tables | 0 |
    | Slow_launch_threads | 19 |
    | Slow_queries | 9565 |
    | Sort_merge_passes | 0 |
    | Sort_range | 1090523 |
    | Sort_rows | 50520688 |
    | Sort_scan | 1302242 |
    | Table_locks_immediate | 18535662 |
    | Table_locks_waited | 19671 |
    | Threads_cached | 175 |
    | Threads_created | 556 |
    | Threads_connected | 161 |
    | Threads_running | 7 |
    | Uptime | 830211 |
    +--------------------------+------------+
    Anyhow.... I'm hoping you pros can give me some good solid advice on how to correct and maximize my system configuration.

    Thanks in advance for your help!
    -- David
    + TutorialForums.com
    + Photoshop-Tips.com

  • #2
    I assume you have gzip enabled?? If not, do that!
    -Draco
    The Digital Sector Forums

    Comment


    • #3
      Re: Server becoming super bogged

      Originally posted by TutorialForums
      Hey all, this is Dave from TutorialForums...

      It seems my server (dedicated with rackshack - amd duron 1ghz, 512mb ram, 20gb 5400rpm drive, running Plesk 2.0) has been having some pretty serious trouble keeping up lately... however the traffic level on the forum/server has not changed all that much. With an average number of members online (40-60 I'd say) the server load is always well above 1.0 now... often around 8+ (as you can see in the top output I'll post in a moment) and has even hit as high as 60+. Usually restarting Plesk (or at least apache and mysql) brings it back down, but it goes right back up within a few days. I thought it "might" have something to do with the size of the database, since it's definately growing very bulky (phpmyadmin reports 290MB).... but I have no idea if that would actually affect it like this.

      I know I need more RAM (in fact I'm looking into a whole new server asap) but I'm sure that my system is probably massively misconfigured, and could probably handle a good deal more if it were optimized. I am using the /etc/my.cnf that Eva2000 gave me a number of months ago, but almost all the rest of the configurations are default, or "something" (I think there's some really wacky stuff in there hehe). Anyhow... I'll post some various stats and configurations that I have, and if you need additional, please let me know.




      Anyhow.... I'm hoping you pros can give me some good solid advice on how to correct and maximize my system configuration.

      Thanks in advance for your help!
      NO WAY are you going to handle 474 max used connections on your current hardware...

      Max_used_connections | 474 |
      your mysql usage must of increased since the last time i recommended the tune up of your server

      i'm recommend an upgrade of your cpu, memory and hard drive speed 5400 rpm hard drive won't cut it

      for now

      change my.cnf to this and restart mysql mysql
      [client]
      port = 3306
      socket = /tmp/mysql.sock

      [mysqld]
      port = 3306
      socket = /tmp/mysql.sock
      skip-locking
      set-variable = max_connections=650
      set-variable = key_buffer=16M
      set-variable = myisam_sort_buffer_size=64M
      set-variable = join_buffer=1M
      set-variable = record_buffer=1M
      set-variable = sort_buffer=2M
      set-variable = table_cache=1024
      set-variable = thread_cache_size=256
      set-variable = wait_timeout=7200
      set-variable = connect_timeout=10

      [safe_mysqld]
      open_files_limit=8192

      [mysqldump]
      quick
      set-variable = max_allowed_packet=64M

      [myisamchk]
      set-variable = key_buffer=64M
      set-variable = sort_buffer=64M
      set-variable = read_buffer=16M
      set-variable = write_buffer=16M
      and in httpd.conf reduce maxclients from 2048 to 150 and restart apache

      i seriously recommend for consistent 450+ mysql concurrent connections a dual cpu server with at least 1 - 1.5GB of ram and fast scsi 10k rpm hard drives but even 7200 rpm ide hard drives would be better than 5400 rpm hard drives

      bear minimum i would recommend for 1 server to handle 500+ mysql concurrent connections would be

      single P3 1.4ghz tualatin 512k L2 cache
      2GB REG ECC PC2100 DDRAM
      80GB Western Digital 800JB 8MB cache EIDE drive (which has speeds close to scsi drives and retains 3 yr warranties)

      even then you could be pushing your luck
      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
      :: Nginx SPDY SSL - World Flags Demo [video results]
      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

      Comment


      • #4
        Thanks eva - I was looking forward to your reply (and thanks Lorddraco98 as well)
        I'll make those changes and let you know how it goes.
        Really, the forum hasn't got a great deal bigger "however" Spoono.com on the server has become a great deal more popular (and they use plenty of mysql)... maybe that's what happened. I just don't recall the server ever having these kinds of troubles, at least not until the forum hit like 80+ users. Concerning the size of the vbulletin database - could that be an issue at all, or does the size not matter?

        It looks like everyone is saying go for mod_gzip too hehe... do you concur? I was reading today also about adding "output_handler = ob_gzhandler" .... is this something that might help?

        Anyhow... thanks!
        -- David
        + TutorialForums.com
        + Photoshop-Tips.com

        Comment


        • #5
          i'd turn off gzip output handler in php.ini
          turn off vB gzip

          and just install mod_gzip

          it's hard to say about mysql usage issues unless vB is the only app on the server and only app using mysql

          when you have other sites sharing the server or using mysql it no longer is just a vB performance issue
          :: Always Back Up Forum Database + Attachments BEFORE upgrading !
          :: Nginx SPDY SSL - World Flags Demo [video results]
          :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

          Comment


          • #6
            Hey eva....

            Ok I did the changes to the settings in my.cnf and the item in httpd.conf ... we'll see what happens from these tomorrow at peak time hehe.

            I installed mod_gzip following your instruction page (and disabled the options in vb - as best I could tell there was nothing turned on in php.ini concerning that)... after some struggle (had to compile) got it working, and tested. You should maybe add a line in your Howto to remind the person to go into httpd.conf and add in that "IfModule mod_gzip.c" stuff if they end up having to compile - it said it added lines to httpd.conf but it took a few min for me to realize it didn't add "that" part hehe

            Load is pretty low right now... could be since it's the middle of the night though haha..... well I'll cross my fingers and hope all is well tomorrow.

            Thanks for your recommended server specs...
            I'm thinking of maybe moving to Fastservers.net - for one I could use the support, but also they offer a lot more hardware options than Rackshack hehe. I was also looking at eservers.biz but that's not looking too plausible since they're not taking orders now If you have any other references for "pretty affordable" semi-managed servers with good hardware/bandwidth options, I would LOVE to hear!
            Might just get 2 servers once ad revenue picks up (hoping haha)

            Peace.
            -- David
            + TutorialForums.com
            + Photoshop-Tips.com

            Comment


            • #7
              Hm something's going wrong I think.

              Load keeps bouncing like a tennis ball..... from ~1.5 up to as much as 91+

              Here's my current mysql extended staus output:

              +--------------------------+------------+
              | Variable_name | Value |
              +--------------------------+------------+
              | Aborted_clients | 919 |
              | Aborted_connects | 2 |
              | Bytes_received | 322009500 |
              | Bytes_sent | 4135708034 |
              | Connections | 126767 |
              | Created_tmp_disk_tables | 32620 |
              | Created_tmp_tables | 72448 |
              | Created_tmp_files | 0 |
              | Delayed_insert_threads | 0 |
              | Delayed_writes | 0 |
              | Delayed_errors | 0 |
              | Flush_commands | 1 |
              | Handler_delete | 13849 |
              | Handler_read_first | 1094789 |
              | Handler_read_key | 60041959 |
              | Handler_read_next | 232658191 |
              | Handler_read_prev | 205620 |
              | Handler_read_rnd | 8628536 |
              | Handler_read_rnd_next | 961890573 |
              | Handler_update | 39781969 |
              | Handler_write | 13975736 |
              | Key_blocks_used | 13884 |
              | Key_read_requests | 61146705 |
              | Key_reads | 13188 |
              | Key_write_requests | 283656 |
              | Key_writes | 267883 |
              | Max_used_connections | 380 |
              | Not_flushed_key_blocks | 0 |
              | Not_flushed_delayed_rows | 0 |
              | Open_tables | 462 |
              | Open_files | 697 |
              | Open_streams | 0 |
              | Opened_tables | 472 |
              | Questions | 4340046 |
              | Select_full_join | 9 |
              | Select_full_range_join | 0 |
              | Select_range | 222585 |
              | Select_range_check | 0 |
              | Select_scan | 1627294 |
              | Slave_running | OFF |
              | Slave_open_temp_tables | 0 |
              | Slow_launch_threads | 21 |
              | Slow_queries | 3622 |
              | Sort_merge_passes | 0 |
              | Sort_range | 192311 |
              | Sort_rows | 8801865 |
              | Sort_scan | 240619 |
              | Table_locks_immediate | 3930192 |
              | Table_locks_waited | 1854 |
              | Threads_cached | 26 |
              | Threads_created | 381 |
              | Threads_connected | 355 |
              | Threads_running | 73 |
              | Uptime | 149092 |
              +--------------------------+------------+


              After waiting for like 10 minutes for it to come up, here's the top output:

              6:49pm up 13 days, 18:33, 1 user, load average: 72.69, 79.61, 68.46
              603 processes: 534 sleeping, 68 running, 1 zombie, 0 stopped
              CPU states: 1.8% user, 1.9% system, 0.0% nice, 2.4% idle
              Mem: 496672K av, 467680K used, 28992K free, 44K shrd, 3488K buff
              Swap: 1028120K av, 299764K used, 728356K free 110464K cached

              PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
              26940 mysql 14 0 146M 100M 12676 R 1.3 20.7 7:14 mysqld
              26966 mysql 18 0 145M 99M 12728 R 1.3 20.5 0:49 mysqld
              26997 mysql 18 0 145M 99M 12728 R 1.3 20.5 1:13 mysqld
              27063 mysql 20 0 141M 95M 12780 R 1.3 19.7 1:18 mysqld
              27084 mysql 19 0 146M 100M 12824 R 1.3 20.8 0:55 mysqld
              27234 mysql 18 0 131M 87M 13296 R 1.3 17.9 3:03 mysqld
              28267 mysql 18 0 135M 90M 13448 R 1.3 18.6 3:15 mysqld
              28360 mysql 14 0 136M 91M 13500 R 1.3 18.8 0:51 mysqld
              28925 mysql 14 0 134M 90M 13536 R 1.3 18.6 2:28 mysqld
              19553 mysql 15 0 133M 89M 14036 R 1.3 18.5 2:34 mysqld
              19559 mysql 16 0 133M 89M 14036 R 1.3 18.5 1:45 mysqld
              24806 mysql 18 0 124M 80M 14612 R 1.3 16.6 1:07 mysqld
              24810 mysql 14 0 124M 81M 14660 R 1.3 16.7 1:03 mysqld
              24820 mysql 17 0 126M 83M 14660 R 1.3 17.1 1:35 mysqld
              26554 mysql 15 0 126M 83M 14660 R 1.3 17.1 2:04 mysqld
              26675 mysql 20 0 127M 84M 14704 R 1.3 17.3 2:46 mysqld
              26686 mysql 19 0 127M 84M 14704 R 1.3 17.3 2:30 mysqld
              26837 mysql 20 0 123M 80M 14892 R 1.3 16.5 2:13 mysqld
              10739 mysql 15 0 125M 82M 14956 R 1.3 16.9 1:21 mysqld
              10832 mysql 14 0 125M 82M 14956 R 1.3 16.9 0:44 mysqld
              14088 mysql 17 0 124M 81M 15136 R 1.3 16.8 1:36 mysqld
              14930 mysql 18 0 124M 81M 15176 R 1.3 16.8 2:29 mysqld
              14965 mysql 14 0 124M 81M 15176 R 1.3 16.8 2:56 mysqld
              15279 mysql 18 0 124M 81M 15176 R 1.3 16.8 3:14 mysqld
              14806 mysql 19 0 125M 83M 15280 R 1.3 17.1 3:11 mysqld
              14846 mysql 19 0 124M 82M 15280 R 1.3 16.9 1:09 mysqld
              14319 mysql 14 0 123M 81M 15280 R 1.3 16.7 1:08 mysqld
              12621 mysql 14 0 125M 82M 15376 R 1.3 16.9 2:05 mysqld
              26936 mysql 17 0 146M 100M 12620 R 1.2 20.7 2:18 mysqld
              27185 mysql 20 0 142M 97M 13092 R 1.2 20.1 1:31 mysqld
              27187 mysql 20 0 142M 97M 13092 R 1.2 20.1 3:31 mysqld
              27198 mysql 14 0 141M 97M 13248 R 1.2 20.0 3:23 mysqld
              27236 mysql 15 0 131M 87M 13296 R 1.2 17.9 4:10 mysqld
              27243 mysql 16 0 131M 87M 13296 R 1.2 17.9 1:02 mysqld
              28142 mysql 17 0 128M 83M 13376 R 1.2 17.2 7:33 mysqld
              28473 mysql 20 0 134M 90M 13536 R 1.2 18.6 4:40 mysqld
              28993 mysql 17 0 133M 89M 13956 R 1.2 18.5 1:28 mysqld
              29008 mysql 19 0 133M 89M 13956 R 1.2 18.4 5:53 mysqld
              29010 mysql 15 0 133M 89M 13972 R 1.2 18.4 1:44 mysqld
              14744 mysql 20 0 133M 89M 14024 R 1.2 18.5 5:05 mysqld
              19642 mysql 14 0 133M 89M 14052 R 1.2 18.5 6:37 mysqld
              22327 mysql 14 0 130M 86M 14144 R 1.2 17.8 6:00 mysqld
              22529 mysql 20 0 130M 86M 14288 R 1.2 17.8 1:44 mysqld
              22779 mysql 14 0 130M 86M 14288 R 1.2 17.8 1:31 mysqld
              24772 mysql 14 0 129M 85M 14580 R 1.2 17.6 3:51 mysqld
              24789 mysql 14 0 128M 84M 14612 R 1.2 17.5 2:31 mysqld
              26820 mysql 15 0 126M 83M 14868 R 1.2 17.1 1:06 mysqld
              10838 mysql 20 0 124M 81M 15020 R 1.2 16.8 1:39 mysqld
              15292 mysql 20 0 124M 81M 15176 R 1.2 16.8 3:12 mysqld
              15374 mysql 11 0 124M 81M 15176 S 1.2 16.8 1:09 mysqld
              14420 mysql 19 0 124M 81M 15184 R 1.2 16.8 1:19 mysqld
              14620 mysql 20 0 123M 80M 15244 R 1.2 16.6 1:07 mysqld
              14792 mysql 17 0 124M 82M 15276 R 1.2 16.9 1:10 mysqld
              14967 mysql 20 0 124M 82M 15280 R 1.2 16.9 1:42 mysqld
              12359 mysql 14 0 123M 81M 15280 R 1.2 16.7 0:32 mysqld
              17783 mysql 14 0 126M 83M 15408 R 1.2 17.2 0:37 mysqld
              17883 mysql 14 0 126M 83M 15408 R 1.2 17.2 0:38 mysqld
              18006 mysql 15 0 126M 83M 15456 R 1.2 17.2 0:27 mysqld
              18764 mysql 20 0 125M 82M 15464 R 1.2 17.0 0:16 mysqld
              18955 mysql 19 0 125M 82M 15464 R 1.2 17.0 0:43 mysqld
              26515 root 14 0 1348 1308 856 R 1.2 0.2 0:05 top
              28967 mysql 14 0 133M 89M 13568 R 1.1 18.3 2:02 mysqld


              Are there any suggestions you can maybe make to keep it at least "sort of" functional until I have it on the new server? (I decided to pick up one of the Intel P4 1.7GHz servers that rackshack is liquidating for 99/mo - just as a temporary solution until I can get something better)... but it will be a good number of days before the server is ready to have sites loaded on it (since by default it's outdated and a sitting duck asking to be hacked hehe)....

              Well first thing, if I can even access the server at all, I'll restart apache/mysql.. or request a reboot.
              Hope you can advise..

              Thanks!
              -- David
              + TutorialForums.com
              + Photoshop-Tips.com

              Comment


              • #8
                I shut down mysql and did NOT bring it back online yet, but after about 10 min the load still hasnt come down past 30.. hmm

                time for bye bye apache too i think

                (hoping you sign on soon george hehe)
                -- David
                + TutorialForums.com
                + Photoshop-Tips.com

                Comment


                • #9
                  well it looks like you're swapping to disk but as why it's hard to tell from where i'm sitting

                  if you're still on amd duron 1ghz, 512mb ram, 20gb 5400rpm, then there's your problem under powered hardware... tweaking my.cnf can only do so much
                  :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                  :: Nginx SPDY SSL - World Flags Demo [video results]
                  :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                  Comment


                  • #10
                    yah still on the duron... just nothing this bad has ever happened thats all hehe

                    After I let both apache and mysql "cool down" (offline) for about 20 min, it seems it has stabilized for the moment.

                    It will be on the new server soon (p4 1.7ghz, 512mb ram - inital: getting upgrade, 40gb ide 7200rpm wd caviar) but I gotta find a way to make due till then hehe.... would you mind giving me a bit of advice on your preferred method (or a link to a trustworthy guide) on burning-in/benchmarking/load testing a new server? I trust your advice more than that of random sites I find with google hehe

                    Thanks!
                    -- David
                    + TutorialForums.com
                    + Photoshop-Tips.com

                    Comment


                    • #11
                      did you reduce maxclients from 2048 to 150 in httpd.conf and restart apache ?
                      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                      :: Nginx SPDY SSL - World Flags Demo [video results]
                      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                      Comment


                      • #12
                        yes... did that the other night, along with installing mod_gzip, and your suggested modifications to my.cnf.... made it through the following day without any serious problem... but at peak today this happened.
                        -- David
                        + TutorialForums.com
                        + Photoshop-Tips.com

                        Comment


                        • #13
                          Originally posted by TutorialForums
                          yes... did that the other night, along with installing mod_gzip, and your suggested modifications to my.cnf.... made it through the following day without any serious problem... but at peak today this happened.
                          server hardware mate

                          you can try turning off attachments, avatars, online user display, browsing in forum display, turn off searching, forumjump to temporarily deal with the load
                          :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                          :: Nginx SPDY SSL - World Flags Demo [video results]
                          :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                          Comment


                          • #14
                            From what I understand, AMD Durons are on a similar level to a Celeron (P3 based) chip. Depending on your motherboard, you might be able to upgrade your BIOS and replace that Duron chip with an Athlon XP (which is comparable to P4 chips).

                            There's probably a good chance that the Duron & your 5400 rpm drive are both causing a bottleneck on the server. If you're not going the SCSI route, the WD800JB would be a great choice as eva mentioned. The 8mb cache on the drive, compared to the 2mb cache on most IDE drives, really helps to speed things up.
                            ...john2k...

                            Comment

                            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                            Working...
                            X