Announcement

Collapse
No announcement yet.

forums crash

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

  • forums crash

    All the night the forum crash o someone hack in to.

    this are my config..pls help. The new error now is block the database, i do a flush and that all..but i like to correct that to

    12:03pm up 19 days, 20:41, 1 user, load average: 2.37, 1.80, 0.91
    114 processes: 112 sleeping, 2 running, 0 zombie, 0 stopped
    CPU0 states: 77.0% user, 6.0% system, 25.0% nice, 16.0% idle
    CPU1 states: 75.0% user, 18.0% system, 53.0% nice, 6.0% idle
    Mem: 1027964K av, 1022872K used, 5092K free, 64K shrd, 55916K buff
    Swap: 0K av, 0K used, 0K free 570892K cached



    Http processes currently running = 23
    Mysql processes currently running = 46

    Netstat information summary
    1 FIN_WAIT2
    2 ESTABLISHED
    2 SYN_RECV
    3 CLOSING
    5 LISTEN
    8 FIN_WAIT1
    535 TIME_WAIT

    +--------------------------+------------+
    | Variable_name | Value |
    +--------------------------+------------+
    | Aborted_clients | 71 |
    | Aborted_connects | 1773 |
    | Bytes_received | 639869333 |
    | Bytes_sent | 2200953750 |
    | Com_admin_commands | 0 |
    | Com_alter_table | 0 |
    | Com_analyze | 0 |
    | Com_backup_table | 0 |
    | Com_begin | 0 |
    | Com_change_db | 199348 |
    | 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 | 11384 |
    | Com_drop_db | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_table | 0 |
    | Com_flush | 2 |
    | Com_grant | 0 |
    | Com_insert | 17549 |
    | Com_insert_select | 1620 |
    | 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 | 4375 |
    | Com_replace_select | 42 |
    | Com_reset | 0 |
    | Com_restore_table | 0 |
    | Com_revoke | 0 |
    | Com_rollback | 0 |
    | Com_select | 3463727 |
    | Com_set_option | 3463 |
    | Com_show_binlogs | 0 |
    | Com_show_create | 3463 |
    | Com_show_databases | 0 |
    | Com_show_fields | 3463 |
    | Com_show_grants | 0 |
    | Com_show_keys | 0 |
    | Com_show_logs | 0 |
    | Com_show_master_status | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_processlist | 0 |
    | Com_show_slave_status | 0 |
    | Com_show_status | 1 |
    | Com_show_innodb_status | 0 |
    | Com_show_tables | 115 |
    | Com_show_variables | 1 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_truncate | 0 |
    | Com_unlock_tables | 0 |
    | Com_update | 321083 |
    | Connections | 201142 |
    | Created_tmp_disk_tables | 1560 |
    | Created_tmp_tables | 105178 |
    | Created_tmp_files | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Delayed_errors | 0 |
    | Flush_commands | 1 |
    | Handler_delete | 29048 |
    | Handler_read_first | 113633 |
    | Handler_read_key | 25833233 |
    | Handler_read_next | 403222604 |
    | Handler_read_prev | 0 |
    | Handler_read_rnd | 29502522 |
    | Handler_read_rnd_next | 1235966341 |
    | Handler_update | 314594 |
    | Handler_write | 5225377 |
    | Key_blocks_used | 15582 |
    | Key_read_requests | 144094003 |
    | Key_reads | 120934 |
    | Key_write_requests | 299456 |
    | Key_writes | 281908 |
    | Max_used_connections | 38 |
    | Not_flushed_key_blocks | 0 |
    | Not_flushed_delayed_rows | 0 |
    | Open_tables | 338 | 33% of table_cache in use
    | Open_files | 487 |
    | Open_streams | 0 |
    | Opened_tables | 344 |
    | Questions | 4228931 |
    | Select_full_join | 52 |
    | Select_full_range_join | 0 |
    | Select_range | 869434 |
    | Select_range_check | 0 |
    | Select_scan | 621129 |
    | Slave_running | OFF |
    | Slave_open_temp_tables | 0 |
    | Slow_launch_threads | 0 |
    | Slow_queries | 578 | (execution time > 10 secs)
    | Sort_merge_passes | 0 |
    | Sort_range | 775411 |
    | Sort_rows | 30910259 |
    | Sort_scan | 505083 |
    | Table_locks_immediate | 4491086 |
    | Table_locks_waited | 6113 |
    | Threads_cached | 37 |
    | Threads_created | 39 |
    | Threads_connected | 2 |
    | Threads_running | 1 |
    | Uptime | 176383 | 2 days 59 mins 43 secs
    +--------------------------+------------+


    Key Reads/Key Read Requests = 0.000839 (Cache hit = 99.999161%)
    Key Writes/Key Write Requests = 0.941400
    Connections/second = 1.140 (/hour = 4105.334)
    KB received/second = 3.543 (/hour = 12753.719)
    KB sent/second = 11.890 (/hour = 42803.125)
    Temporary Tables Created/second = 0.596 (/hour = 2146.697)
    Opened Tables/second = 0.002 (/hour = 7.021)
    Slow Queries/second = 0.003 (/hour = 11.797)
    % of slow queries = 0.014%
    Queries/second = 23.976 (/hour = 86313.032)


    And my.cnf

    [mysqld]
    set-variable = max_connections=350
    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
    set-variable = max_allowed_packet=16M
    set-variable = max_connect_errors=10
    [safe_mysqld]
    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

  • #2
    Originally posted by cerebro
    All the night the forum crash o someone hack in to.

    this are my config..pls help. The new error now is block the database, i do a flush and that all..but i like to correct that to

    12:03pm up 19 days, 20:41, 1 user, load average: 2.37, 1.80, 0.91
    114 processes: 112 sleeping, 2 running, 0 zombie, 0 stopped
    CPU0 states: 77.0% user, 6.0% system, 25.0% nice, 16.0% idle
    CPU1 states: 75.0% user, 18.0% system, 53.0% nice, 6.0% idle
    Mem: 1027964K av, 1022872K used, 5092K free, 64K shrd, 55916K buff
    Swap: 0K av, 0K used, 0K free 570892K cached



    Http processes currently running = 23
    Mysql processes currently running = 46

    Netstat information summary
    1 FIN_WAIT2
    2 ESTABLISHED
    2 SYN_RECV
    3 CLOSING
    5 LISTEN
    8 FIN_WAIT1
    535 TIME_WAIT

    +--------------------------+------------+
    | Variable_name | Value |
    +--------------------------+------------+
    | Aborted_clients | 71 |
    | Aborted_connects | 1773 |
    | Bytes_received | 639869333 |
    | Bytes_sent | 2200953750 |
    | Com_admin_commands | 0 |
    | Com_alter_table | 0 |
    | Com_analyze | 0 |
    | Com_backup_table | 0 |
    | Com_begin | 0 |
    | Com_change_db | 199348 |
    | 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 | 11384 |
    | Com_drop_db | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_table | 0 |
    | Com_flush | 2 |
    | Com_grant | 0 |
    | Com_insert | 17549 |
    | Com_insert_select | 1620 |
    | 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 | 4375 |
    | Com_replace_select | 42 |
    | Com_reset | 0 |
    | Com_restore_table | 0 |
    | Com_revoke | 0 |
    | Com_rollback | 0 |
    | Com_select | 3463727 |
    | Com_set_option | 3463 |
    | Com_show_binlogs | 0 |
    | Com_show_create | 3463 |
    | Com_show_databases | 0 |
    | Com_show_fields | 3463 |
    | Com_show_grants | 0 |
    | Com_show_keys | 0 |
    | Com_show_logs | 0 |
    | Com_show_master_status | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_processlist | 0 |
    | Com_show_slave_status | 0 |
    | Com_show_status | 1 |
    | Com_show_innodb_status | 0 |
    | Com_show_tables | 115 |
    | Com_show_variables | 1 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_truncate | 0 |
    | Com_unlock_tables | 0 |
    | Com_update | 321083 |
    | Connections | 201142 |
    | Created_tmp_disk_tables | 1560 |
    | Created_tmp_tables | 105178 |
    | Created_tmp_files | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Delayed_errors | 0 |
    | Flush_commands | 1 |
    | Handler_delete | 29048 |
    | Handler_read_first | 113633 |
    | Handler_read_key | 25833233 |
    | Handler_read_next | 403222604 |
    | Handler_read_prev | 0 |
    | Handler_read_rnd | 29502522 |
    | Handler_read_rnd_next | 1235966341 |
    | Handler_update | 314594 |
    | Handler_write | 5225377 |
    | Key_blocks_used | 15582 |
    | Key_read_requests | 144094003 |
    | Key_reads | 120934 |
    | Key_write_requests | 299456 |
    | Key_writes | 281908 |
    | Max_used_connections | 38 |
    | Not_flushed_key_blocks | 0 |
    | Not_flushed_delayed_rows | 0 |
    | Open_tables | 338 | 33% of table_cache in use
    | Open_files | 487 |
    | Open_streams | 0 |
    | Opened_tables | 344 |
    | Questions | 4228931 |
    | Select_full_join | 52 |
    | Select_full_range_join | 0 |
    | Select_range | 869434 |
    | Select_range_check | 0 |
    | Select_scan | 621129 |
    | Slave_running | OFF |
    | Slave_open_temp_tables | 0 |
    | Slow_launch_threads | 0 |
    | Slow_queries | 578 | (execution time > 10 secs)
    | Sort_merge_passes | 0 |
    | Sort_range | 775411 |
    | Sort_rows | 30910259 |
    | Sort_scan | 505083 |
    | Table_locks_immediate | 4491086 |
    | Table_locks_waited | 6113 |
    | Threads_cached | 37 |
    | Threads_created | 39 |
    | Threads_connected | 2 |
    | Threads_running | 1 |
    | Uptime | 176383 | 2 days 59 mins 43 secs
    +--------------------------+------------+


    Key Reads/Key Read Requests = 0.000839 (Cache hit = 99.999161%)
    Key Writes/Key Write Requests = 0.941400
    Connections/second = 1.140 (/hour = 4105.334)
    KB received/second = 3.543 (/hour = 12753.719)
    KB sent/second = 11.890 (/hour = 42803.125)
    Temporary Tables Created/second = 0.596 (/hour = 2146.697)
    Opened Tables/second = 0.002 (/hour = 7.021)
    Slow Queries/second = 0.003 (/hour = 11.797)
    % of slow queries = 0.014%
    Queries/second = 23.976 (/hour = 86313.032)


    And my.cnf

    [mysqld]
    set-variable = max_connections=350
    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
    set-variable = max_allowed_packet=16M
    set-variable = max_connect_errors=10
    [safe_mysqld]
    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
    what error message(s) you get ? can you post exact error message ?
    :: 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


    • #3
      Link-ID == false, connect failed
      mysql error: Host '200.49.147.21' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

      That is the error

      Comment


      • #4
        Pls what can i do?? all night the forum crash..again and again!

        Comment


        • #5
          sounds like you set a linux/unix load limit in admin CP, vbulletin option, you may want to raise the value or disable it completely
          MCSE, MVP, CCIE
          Microsoft Beta Team

          Comment


          • #6
            Originally posted by cerebro
            Link-ID == false, connect failed
            mysql error: Host '200.49.147.21' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

            That is the error
            you might have some TCP/IP connection problems between your web server and mysql database server.

            mysql defaults to 10 max_connect_errors or failed requests from your host hostname before blocking the site from connecting to your mysql database until you execute the command

            mysqladmin flush-hosts

            you can try in your database server's /etc/my.cnf file add under

            [mysqld] section add
            set-variable = max_connect_errors=5000
            and restart mysql

            max_connect_errors
            If there is more than this number of interrupted connections from a host this host will be blocked from further connections. You can unblock a host with the command FLUSH HOSTS.
            to edit /etc/my.cnf file you need root server access normally with dedicated hosting, if you're shared hosted you need to contact your web host and ask them to check their TCP/IP connections etc to their database.
            :: 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


            • #7
              The mysql server is in the same machine.

              i increase the max_connect_errors to 200.
              And the forum crash...maybe that is the cause.

              Comment


              • #8
                Originally posted by cerebro
                The mysql server is in the same machine.

                i increase the max_connect_errors to 200.
                And the forum crash...maybe that is the cause.
                did it crash after you restarted mysql ? what error messages you're getting ?
                :: 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


                • #9
                  Originally posted by eva2000
                  did it crash after you restarted mysql ? what error messages you're getting ?
                  I will check the log..

                  Comment

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