Announcement

Collapse
No announcement yet.

Slow loading for my forums which does not have alot of users

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

  • Slow loading for my forums which does not have alot of users

    here is the mysql info


    <html>
    <head><title>MySQL Status Script</title></head>
    <body><pre>
    Tue Dec 9 10:55:35 SGT 2003

    10:55am up 40 min, 1 user, load average: 0.26, 0.35, 0.51
    350 processes: 348 sleeping, 2 running, 0 zombie, 0 stopped
    CPU0 states: 7.1% user, 12.0% system, 0.0% nice, 79.0% idle
    CPU1 states: 2.0% user, 0.0% system, 0.0% nice, 97.0% idle
    CPU2 states: 0.0% user, 0.0% system, 0.0% nice, 100.0% idle
    CPU3 states: 0.0% user, 0.0% system, 0.0% nice, 100.0% idle
    Mem: 1548120K av, 1523364K used, 24756K free, 0K shrd, 31464K buff
    Swap: 2044072K av, 0K used, 2044072K free 1101756K cached
    PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
    2403 nobody 16 0 1228 1228 824 R 12.1 0.0 0:00 top

    Http processes currently running = 109
    Mysql processes currently running = 151
    Netstat information summary
    2 FIN_WAIT1
    2 FIN_WAIT2
    2 LAST_ACK
    11 LISTEN
    17 CLOSE_WAIT
    18 SYN_RECV
    155 TIME_WAIT
    279 ESTABLISHED

    +---------------------------+-----------------+
    | Variable_name | Value |
    +---------------------------+-----------------+
    | Aborted_clients | 2 |
    | Aborted_connects | 0 |
    | Bytes_received | 19766923 |
    | Bytes_sent | 819822775 |
    | Com_admin_commands | 3688 |
    | Com_alter_table | 0 |
    | Com_analyze | 0 |
    | Com_backup_table | 0 |
    | Com_begin | 0 |
    | Com_change_db | 8882 |
    | 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 | 1353 |
    | Com_delete_multi | 0 |
    | Com_drop_db | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_table | 0 |
    | Com_flush | 0 |
    | Com_grant | 0 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_insert | 2606 |
    | Com_insert_select | 2 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_load_master_data | 0 |
    | Com_load_master_table | 0 |
    | Com_lock_tables | 9 |
    | Com_optimize | 0 |
    | Com_purge | 0 |
    | Com_rename_table | 0 |
    | Com_repair | 0 |
    | Com_replace | 15 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_restore_table | 0 |
    | Com_revoke | 0 |
    | Com_rollback | 0 |
    | Com_savepoint | 0 |
    | Com_select | 18010 |
    | Com_set_option | 123 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 0 |
    | Com_show_create | 123 |
    | Com_show_databases | 0 |
    | Com_show_fields | 123 |
    | Com_show_grants | 0 |
    | Com_show_keys | 0 |
    | Com_show_logs | 0 |
    | Com_show_master_status | 0 |
    | Com_show_new_master | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_processlist | 0 |
    | Com_show_slave_hosts | 0 |
    | Com_show_slave_status | 0 |
    | Com_show_status | 1 |
    | Com_show_innodb_status | 0 |
    | Com_show_tables | 9 |
    | Com_show_variables | 1 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_truncate | 0 |
    | Com_unlock_tables | 0 |
    | Com_update | 4824 |
    | Connections | 6377 |
    | Created_tmp_disk_tables | 11 |
    | Created_tmp_tables | 297 |
    | Created_tmp_files | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Delayed_errors | 0 |
    | Flush_commands | 1 |
    | Handler_commit | 0 |
    | Handler_delete | 2857 |
    | Handler_read_first | 4133 |
    | Handler_read_key | 60887 |
    | Handler_read_next | 902536 |
    | Handler_read_prev | 6836 |
    | Handler_read_rnd | 63729 |
    | Handler_read_rnd_next | 35524055 |
    | Handler_rollback | 0 |
    | Handler_update | 5129 |
    | Handler_write | 22144 |
    | Key_blocks_used | 2768 |
    | Key_read_requests | 339400 |
    | Key_reads | 2753 |
    | Key_write_requests | 4515 |
    | Key_writes | 1986 |
    | Max_used_connections | 144 |
    | Not_flushed_key_blocks | 0 |
    | Not_flushed_delayed_rows | 0 |
    | Open_tables | 282 | 28% of table_cache in use
    | Open_files | 397 |
    | Open_streams | 0 |
    | Opened_tables | 288 |
    | Questions | 127340 |
    | Qcache_queries_in_cache | 695 |
    | Qcache_inserts | 12961 |
    | Qcache_hits | 85002 |
    | Qcache_lowmem_prunes | 0 |
    | Qcache_not_cached | 5049 |
    | Qcache_free_memory | 31046808 |
    | Qcache_free_blocks | 258 |
    | Qcache_total_blocks | 1717 |
    | Rpl_status | NULL |
    | Select_full_join | 27 |
    | Select_full_range_join | 0 |
    | Select_range | 1444 |
    | Select_range_check | 0 |
    | Select_scan | 7550 |
    | Slave_open_temp_tables | 0 |
    | Slave_running | OFF |
    | Slow_launch_threads | 0 |
    | Slow_queries | 4 | (execution time > 10 secs)
    | Sort_merge_passes | 0 |
    | Sort_range | 1296 |
    | Sort_rows | 10819367 |
    | Sort_scan | 2207 |
    | Table_locks_immediate | 33011 |
    | Table_locks_waited | 149 |
    | Threads_cached | 18 |
    | Threads_created | 145 |
    | Threads_connected | 127 |
    | Threads_running | 1 |
    | Uptime | 2288 | 38 mins 8 secs
    +---------------------------+-----------------+

    Key Reads/Key Read Requests = 0.008111 (Cache hit = 99.991889%)
    Key Writes/Key Write Requests = 0.439867
    Connections/second = 2.787 (/hour = 10033.741)
    KB received/second = 8.437 (/hour = 30371.853)
    KB sent/second = 349.916 (/hour = 1259697.902)
    Temporary Tables Created/second = 0.130 (/hour = 467.308)
    Opened Tables/second = 0.126 (/hour = 453.147)
    Slow Queries/second = 0.002 (/hour = 6.294)
    % of slow queries = 0.003%
    Queries/second = 55.656 (/hour = 200360.140)
    </pre></body></html>

  • #2
    and my server spec are as follow

    dual xeon 2.4ghz
    2gig of ram
    raid 5 60gig harddisk

    Comment

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