Announcement

Collapse
No announcement yet.

my cpu load is a nightmare 50

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

  • my cpu load is a nightmare 50

    i am now on a new deticated server

    daul cpu p111 1ghz

    1 gb ram

    40 gb harddisk

    linux red hat 7.3


    i only have a clean 2.2.8 vb forum running without any hacks


    clean templates (just translated to arabic)

    i know only have an average of 90 vistors on the site

    and the cpu load is wow 50 +/-


    when i type this in ssh
    ps -ef | grep httpd

    i get
    root 19923 1 0 00:47 ? 00:00:00 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19926 19923 4 00:47 ? 00:00:17 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19927 19923 4 00:47 ? 00:00:19 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19928 19923 10 00:47 ? 00:00:45 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19929 19923 7 00:47 ? 00:00:33 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19930 19923 5 00:47 ? 00:00:24 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19931 19923 4 00:47 ? 00:00:20 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19932 19923 9 00:47 ? 00:00:43 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19933 19923 5 00:47 ? 00:00:24 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19936 19923 2 00:47 ? 00:00:12 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19944 19923 9 00:47 ? 00:00:40 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19945 19923 5 00:47 ? 00:00:23 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19948 19923 8 00:47 ? 00:00:34 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19949 19923 9 00:47 ? 00:00:39 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19950 19923 6 00:47 ? 00:00:27 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19951 19923 10 00:47 ? 00:00:47 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19954 19923 8 00:47 ? 00:00:35 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19955 19923 13 00:47 ? 00:00:59 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19956 19923 4 00:47 ? 00:00:20 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19957 19923 10 00:47 ? 00:00:44 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 19958 19923 6 00:47 ? 00:00:26 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 20212 19923 8 00:53 ? 00:00:07 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 20276 19923 9 00:54 ? 00:00:02 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 20283 19923 9 00:54 ? 00:00:02 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 20284 19923 8 00:54 ? 00:00:02 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 20294 19923 4 00:54 ? 00:00:01 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 20295 19923 0 00:54 ? 00:00:00 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 20296 19923 9 00:54 ? 00:00:02 /usr/sbin/httpd -DHAVE_ACCESS -D
    apache 20297 19923 0 00:54 ? 00:00:00 /usr/sbin/httpd -DHAVE_ACCESS -D
    root 20323 18989 0 00:54 pts/4 00:00:00 grep httpd
    apache 20328 19923 0 00:54 ? 00:00:00 /usr/sbin/httpd -DHAVE_ACCESS -D
    Good times are for friends to share

  • #2
    And this site is the only thing on the server? If so, it sounds like you need to optimize MySQL and Apache to work more efficiently.

    You should check in the Server Configuration forum for help. SitePointForums runs on roughly similar equipment and similar usage. If the load average climbs above .5 then we think there is a problem. Never happens though.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      let's have a look

      please provide the following

      1. your server specs, such as mysql and php version
      2. if possible how mysql was compiled/installed
      3. your top stats
      4. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

      mysqladmin -u root -p variables

      copy and paste output here

      5. your mysql extended-status output either still telnet as root user type

      mysqladmin -u root -p extended-status

      copy and paste output here

      or preferred is to installed extended-status output script which is either located

      - in your vB 2.2.6 or higher vB version's zip file extra's folder, upload mysqlinfo.php script to your site or if you're on an pre vB 2.2.6 install go to
      - http://vbulletin.com/forum/showthread.php?threadid=3477 and install that scrip making sure to edit $mysqllogin line with your own mysqlusername and password

      and post url to that here

      6. oh and is your vB the only thing on the server? or other scripts? sites?

      7. how many average and max concurrent users on your vB forum ?

      8. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

      <?
      phpinfo();
      ?>

      i.e. yourdomain.com/phpinfo.php

      9. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

      KeepAlive
      MaxKeepAliveRequests
      KeepAliveTimeout
      MinSpareServers
      MaxSpareServers
      StartServers
      MaxClients

      10. what version of vB are you running ?
      :: 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
        http://hawaaworld.com/info.php
        Good times are for friends to share

        Comment


        • #5
          Tue Oct 29 21:59:03 EST 2002


          9:59pm up 4 days, 23:34, 0 users, load average: 34.64, 28.73, 27.99
          318 processes: 282 sleeping, 36 running, 0 zombie, 0 stopped
          CPU0 states: 51.6% user, 48.2% system, 0.0% nice, 0.0% idle
          CPU1 states: 55.4% user, 44.3% system, 0.0% nice, 0.0% idle
          Mem: 1030984K av, 1004828K used, 26156K free, 0K shrd, 37040K buff
          Swap: 1052248K av, 80288K used, 971960K free 340220K cached

          PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
          6833 mysql 20 0 40336 36M 2124 R 0.4 3.6 0:00 mysqld


          Http processes currently running = 167
          Mysql processes currently running = 107

          Netstat information summary
          1 LAST_ACK
          1 SYN_RECV
          22 LISTEN
          23 CLOSE_WAIT
          40 ESTABLISHED
          62 TIME_WAIT


          +---------------------------+-----------------+
          | Variable_name | Value |
          +---------------------------+-----------------+
          | Aborted_clients | 599 |
          | Aborted_connects | 2689 |
          | Bytes_received | 278025515 |
          | Bytes_sent | 4114998142 |
          | Com_admin_commands | 0 |
          | Com_alter_table | 66 |
          | Com_analyze | 0 |
          | Com_backup_table | 0 |
          | Com_begin | 4 |
          | Com_change_db | 94988 |
          | Com_change_master | 0 |
          | Com_check | 88 |
          | Com_commit | 4 |
          | Com_create_db | 0 |
          | Com_create_function | 0 |
          | Com_create_index | 0 |
          | Com_create_table | 12 |
          | Com_delete | 8728 |
          | Com_drop_db | 0 |
          | Com_drop_function | 0 |
          | Com_drop_index | 0 |
          | Com_drop_table | 4 |
          | Com_flush | 1 |
          | Com_grant | 0 |
          | Com_insert | 17392 |
          | Com_insert_select | 601 |
          | Com_kill | 0 |
          | Com_load | 0 |
          | Com_load_master_table | 0 |
          | Com_lock_tables | 0 |
          | Com_optimize | 86 |
          | Com_purge | 0 |
          | Com_rename_table | 0 |
          | Com_repair | 0 |
          | Com_replace | 817 |
          | Com_replace_select | 93 |
          | Com_reset | 0 |
          | Com_restore_table | 0 |
          | Com_revoke | 0 |
          | Com_rollback | 0 |
          | Com_select | 1949449 |
          | Com_set_option | 160 |
          | Com_show_binlogs | 0 |
          | Com_show_create | 160 |
          | Com_show_databases | 7 |
          | Com_show_fields | 164 |
          | Com_show_grants | 0 |
          | Com_show_keys | 0 |
          | Com_show_logs | 0 |
          | Com_show_master_stat | 0 |
          | Com_show_open_tables | 0 |
          | Com_show_processlist | 0 |
          | Com_show_slave_stat | 0 |
          | Com_show_status | 785 |
          | Com_show_tables | 9 |
          | Com_show_variables | 5 |
          | Com_slave_start | 0 |
          | Com_slave_stop | 0 |
          | Com_truncate | 0 |
          | Com_unlock_tables | 0 |
          | Com_update | 186675 |
          | Connections | 50765 |
          | Created_tmp_disk_tables | 13 |
          | Created_tmp_tables | 26925 |
          | Created_tmp_files | 0 |
          | Delayed_insert_threads | 0 |
          | Delayed_writes | 0 |
          | Delayed_errors | 0 |
          | Flush_commands | 1 |
          | Handler_delete | 17699 |
          | Handler_read_first | 21985 |
          | Handler_read_key | 11624585 |
          | Handler_read_next | 255373685 |
          | Handler_read_prev | 30326 |
          | Handler_read_rnd | 13221178 |
          | Handler_read_rnd_next | 1681057830 |
          | Handler_update | 420215 |
          | Handler_write | 1496452 |
          | Key_blocks_used | 7793 |
          | Key_read_requests | 62901311 |
          | Key_reads | 116809 |
          | Key_write_requests | 83862 |
          | Key_writes | 35163 |
          | Max_used_connections | 100 | Max. connections reached

          | Not_flushed_key_blocks | 0 |
          | Not_flushed_delayed_rows | 0 |
          | Open_tables | 64 | 100% of table_cache in use
          | Open_files | 85 |
          | Open_streams | 0 |
          | Opened_tables | 2039 |
          | Questions | 2306893 |
          | Select_full_join | 13 |
          | Select_full_range_join | 0 |
          | Select_range | 214547 |
          | Select_range_check | 0 |
          | Select_scan | 322145 |
          | Slave_running | OFF |
          | Slave_open_temp_tables | 0 |
          | Slow_launch_threads | 2 |
          | Slow_queries | 3290 | (execution time > 10 secs)
          | Sort_merge_passes | 0 |
          | Sort_range | 235675 |
          | Sort_rows | 13318776 |
          | Sort_scan | 133203 |
          | Table_locks_immediate | 2412827 |
          | Table_locks_waited | 4593 |
          | Threads_cached | 0 |
          | Threads_created | 50764 |
          | Threads_connected | 101 |
          | Threads_running | 1 |
          | Uptime | 165385 | 1 day 21 hrs 56 mins 25 secs
          +---------------------------+-----------------+


          Key Reads/Key Read Requests = 0.001857 (Cache hit = 99.998143%)
          Key Writes/Key Write Requests = 0.419296
          Connections/second = 0.307 (/hour = 1105.022)
          KB received/second = 1.642 (/hour = 5910.043)
          KB sent/second = 12.680 (/hour = 45649.506)
          Temporary Tables Created/second = 0.163 (/hour = 586.087)
          Opened Tables/second = 0.012 (/hour = 44.384)
          Slow Queries/second = 0.020 (/hour = 71.615)
          % of slow queries = 0.143%
          Queries/second = 13.949 (/hour = 50215.042)
          Good times are for friends to share

          Comment


          • #6
            /etc/my.cnf
            PHP Code:
            [mysqld]
            datadir=/var/lib/mysql
            socket
            =/var/lib/mysql/mysql.sock
                 
            [mysql.server]
            user=mysql
            basedir
            =/var/lib

            [safe_mysqld]
            err-log=/var/log/mysqld.log
            pid
            -file=/var/run/mysqld/mysqld.pid 
            Good times are for friends to share

            Comment


            • #7
              change your my.cnf contents to the below one and restart mysql

              [mysqld]
              datadir=/var/lib/mysql
              socket=/var/lib/mysql/mysql.sock
              set-variable = max_connections=450
              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=9600
              set-variable = connect_timeout=10
              set-variable = max_allowed_packet=16M
              set-variable = max_connect_errors=10

              [mysql.server]
              user=mysql
              basedir=/var/lib

              [safe_mysqld]
              err-log=/var/log/mysqld.log
              pid-file=/var/run/mysqld/mysqld.pid
              open_files_limit=8192

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

              [myisamchk]
              set-variable = key_buffer=64M
              set-variable = sort_buffer=64M
              set-variable = read_buffer=16M
              set-variable = write_buffer=16M
              :: 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


              • #8
                I do it ... but the problem still until now !!



                Wed Oct 30 22:40:15 EST 2002


                10:40pm up 6 days, 15 min, 1 user, load average: 18.64, 9.97, 4.95
                225 processes: 207 sleeping, 18 running, 0 zombie, 0 stopped
                CPU0 states: 57.0% user, 42.0% system, 0.0% nice, 0.0% idle
                CPU1 states: 44.0% user, 55.1% system, 0.0% nice, 0.0% idle
                Mem: 1030984K av, 1012980K used, 18004K free, 0K shrd, 92820K buff
                Swap: 1052248K av, 63136K used, 989112K free 342308K cached

                PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
                3151 mysql 15 0 13196 12M 2164 R 0.0 1.2 0:03 mysqld


                Http processes currently running = 142
                Mysql processes currently running = 36

                Netstat information summary
                5 SYN_SENT
                6 CLOSE_WAIT
                22 LISTEN
                23 ESTABLISHED
                87 TIME_WAIT


                +---------------------------+-----------------+
                | Variable_name | Value |
                +---------------------------+-----------------+
                | Aborted_clients | 0 |
                | Aborted_connects | 677 |
                | Bytes_received | 6096292 |
                | Bytes_sent | 121987641 |
                | Com_admin_commands | 0 |
                | Com_alter_table | 0 |
                | Com_analyze | 0 |
                | Com_backup_table | 0 |
                | Com_begin | 0 |
                | Com_change_db | 2312 |
                | Com_change_master | 0 |
                | Com_check | 0 |
                | Com_commit | 0 |
                | Com_create_db | 0 |
                | Com_create_function | 0 |
                | Com_create_index | 0 |
                | Com_create_table | 0 |
                | Com_delete | 237 |
                | Com_drop_db | 0 |
                | Com_drop_function | 0 |
                | Com_drop_index | 0 |
                | Com_drop_table | 0 |
                | Com_flush | 0 |
                | Com_grant | 0 |
                | Com_insert | 643 |
                | Com_insert_select | 104 |
                | Com_kill | 0 |
                | Com_load | 0 |
                | Com_load_master_table | 0 |
                | Com_lock_tables | 0 |
                | Com_optimize | 0 |
                | Com_purge | 0 |
                | Com_rename_table | 0 |
                | Com_repair | 0 |
                | Com_replace | 106 |
                | Com_replace_select | 45 |
                | Com_reset | 0 |
                | Com_restore_table | 0 |
                | Com_revoke | 0 |
                | Com_rollback | 0 |
                | Com_select | 39708 |
                | Com_set_option | 0 |
                | Com_show_binlogs | 0 |
                | Com_show_create | 0 |
                | Com_show_databases | 1 |
                | Com_show_fields | 0 |
                | Com_show_grants | 0 |
                | Com_show_keys | 0 |
                | Com_show_logs | 0 |
                | Com_show_master_stat | 0 |
                | Com_show_open_tables | 0 |
                | Com_show_processlist | 0 |
                | Com_show_slave_stat | 0 |
                | Com_show_status | 36 |
                | Com_show_tables | 0 |
                | Com_show_variables | 35 |
                | Com_slave_start | 0 |
                | Com_slave_stop | 0 |
                | Com_truncate | 0 |
                | Com_unlock_tables | 0 |
                | Com_update | 2410 |
                | Connections | 1921 |
                | Created_tmp_disk_tables | 1 |
                | Created_tmp_tables | 890 |
                | Created_tmp_files | 0 |
                | Delayed_insert_threads | 0 |
                | Delayed_writes | 0 |
                | Delayed_errors | 0 |
                | Flush_commands | 1 |
                | Handler_delete | 204 |
                | Handler_read_first | 1573 |
                | Handler_read_key | 237499 |
                | Handler_read_next | 4890450 |
                | Handler_read_prev | 2 |
                | Handler_read_rnd | 321923 |
                | Handler_read_rnd_next | 2929161 |
                | Handler_update | 2168 |
                | Handler_write | 55706 |
                | Key_blocks_used | 3942 |
                | Key_read_requests | 1261294 |
                | Key_reads | 3641 |
                | Key_write_requests | 24775 |
                | Key_writes | 4347 |
                | Max_used_connections | 28 |
                | Not_flushed_key_blocks | 0 |
                | Not_flushed_delayed_rows | 0 |
                | Open_tables | 74 | 7% of table_cache in use
                | Open_files | 130 |
                | Open_streams | 0 |
                | Opened_tables | 88 |
                | Questions | 46856 |
                | Select_full_join | 1 |
                | Select_full_range_join | 0 |
                | Select_range | 4562 |
                | Select_range_check | 0 |
                | Select_scan | 6693 |
                | Slave_running | OFF |
                | Slave_open_temp_tables | 0 |
                | Slow_launch_threads | 0 |
                | Slow_queries | 0 | (execution time > 10 secs)
                | Sort_merge_passes | 0 |
                | Sort_range | 4110 |
                | Sort_rows | 324969 |
                | Sort_scan | 2895 |
                | Table_locks_immediate | 48988 |
                | Table_locks_waited | 11 |
                | Threads_cached | 6 |
                | Threads_created | 29 |
                | Threads_connected | 23 |
                | Threads_running | 1 |
                | Uptime | 3187 | 53 mins 7 secs
                +---------------------------+-----------------+


                Key Reads/Key Read Requests = 0.002887 (Cache hit = 99.997113%)
                Key Writes/Key Write Requests = 0.175459
                Connections/second = 0.603 (/hour = 2169.940)
                KB received/second = 1.868 (/hour = 6724.443)
                KB sent/second = 37.379 (/hour = 134565.673)
                Temporary Tables Created/second = 0.279 (/hour = 1005.334)
                Opened Tables/second = 0.028 (/hour = 99.404)
                Slow Queries/second = 0.000 (/hour = 0.000)
                % of slow queries = 0.000%
                Queries/second = 14.702 (/hour = 52928.020)
                Good times are for friends to share

                Comment


                • #9
                  Wed Oct 30 23:03:00 EST 2002


                  11:03pm up 6 days, 38 min, 0 users, load average: 38.66, 37.21, 26.85
                  282 processes: 243 sleeping, 39 running, 0 zombie, 0 stopped
                  CPU0 states: 48.2% user, 51.0% system, 0.0% nice, 0.0% idle
                  CPU1 states: 52.0% user, 47.2% system, 0.0% nice, 0.0% idle
                  Mem: 1030984K av, 1009152K used, 21832K free, 0K shrd, 92352K buff
                  Swap: 1052248K av, 63140K used, 989108K free 265104K cached
                  Good times are for friends to share

                  Comment


                  • #10
                    now load average up to 110 !!
                    Good times are for friends to share

                    Comment


                    • #11
                      hi i used your server info in your support ticket and checked your server looks like both your cpus are 100% maxed out all the time with 0% idle time on both cpus for long periods of time...

                      you can try upgrading apache to 1.3.27 and linux kernel to lastest 2.4.x smp kernel and see if that helps could be bugs in kernel causing this or could be you need to upgrade your cpus

                      other possible issue is your slow 40GB EIDE hdd which is more cpu resource intensive than scsi disks...

                      you can upgrade apache and linux kernel first and see if that helps after a few days of use then upgrade your hdd from EIDE to scsi based and see if that helps first before upgrading cpus
                      :: 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
                        apache and kernel r upgraded yes

                        the drive is good we have been running vb on a similar one before


                        daul p111 1ghz i think is more than enough


                        when i close the vb everything goes back to normal????

                        Good times are for friends to share

                        Comment


                        • #13
                          http://www.hawaaworld.com/vb/admin/

                          look admin cpanel runs smoothly and fine perfect

                          http://www.hawaaworld.com/vb/index.php
                          http://hawaaworld.com/vb/forumdisplay.php?s=&forumid=4
                          http://hawaaworld.com/vb/showthread....threadid=47464

                          takes ages to browse board and open threads

                          definelty something wrong with th vb script
                          Last edited by Male_LadyBug; Tue 5 Nov '02, 6:44am.
                          Good times are for friends to share

                          Comment


                          • #14
                            Originally posted by Male_LadyBug
                            http://www.hawaaworld.com/vb/admin/

                            look admin cpanel runs smoothly and fine perfect

                            http://www.hawaaworld.com/vb/index.php
                            http://hawaaworld.com/vb/forumdisplay.php?s=&forumid=4
                            http://hawaaworld.com/vb/showthread....threadid=47464

                            takes ages to browse board and open threads

                            definelty something wrong with th vb script
                            install a 2nd test dummy copy of vBulletin (same version as you're running on the above forum and check if the stock vB loads index and forums properly
                            :: 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


                            • #15
                              i did this is a second one
                              freshly downloaded from vb site last night

                              and tried the original templates that came with vb
                              Good times are for friends to share

                              Comment

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