
平台论坛博客文库

› 论坛 › 数据库技术 › MySQL › 发帖很慢，看帖很快

发帖很慢，看帖很快 [复制链接]

xiyang

稍有积蓄

论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2003-05-02 14:58 |只看该作者 |倒序浏览

系统：freebsd 4.7+ mysql-standard-4.0.12-unknown-freebsd4.7-i386

在上面跑vbb，发帖子非常慢，但看帖子很快

#top
last pid: 652; load averages: 0.13, 0.09, 0.07 up 0+05:17:17 15:01:54
40 processes: 2 running, 38 sleeping
CPU states: 34.1% user, 0.0% nice, 22.5% system, 0.0% interrupt, 43.4% idle
Mem: 99M Active, 290M Inact, 70M Wired, 24M Cache, 60M Buf, 16M Free
Swap: 512M Total, 72K Used, 512M Free
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
178 mysql 31 0 55228K 33456K RUN 14:21 14.45% 14.45% mysqld
130 nobody 2 0 7056K 5904K sbwait 0:23 0.49% 0.49% httpd
128 nobody 2 0 6884K 5748K sbwait 0:23 0.49% 0.49% httpd
194 nobody 2 0 6888K 5740K sbwait 0:23 0.34% 0.34% httpd
204 nobody 2 0 6848K 5708K sbwait 0:22 0.29% 0.29% httpd
188 nobody 10 0 7340K 6196K wait 0:24 0.20% 0.20% httpd
..............................
mysql>; show status;
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 4659254 |
| Bytes_sent | 169276180 |
| Com_admin_commands | 1479 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1519 |
| 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 | 90 |
| 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 | 226 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 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 | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 26837 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| 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 | 0 |
| Com_show_variables | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2401 |
| Connections | 42 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 794 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 162 |
| Handler_read_first | 399 |
| Handler_read_key | 169668 |
| Handler_read_next | 3656598 |
| Handler_read_prev | 3665 |
| Handler_read_rnd | 3537933 |
| Handler_read_rnd_next | 7975204 |
| Handler_rollback | 0 |
| Handler_update | 2240 |
| Handler_write | 27803 |
| Key_blocks_used | 2107 |
| Key_read_requests | 1118545 |
| Key_reads | 2107 |
| Key_write_requests | 760 |
| Key_writes | 702 |
| Max_used_connections | 27 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 53 |
| Open_files | 83 |
| Open_streams | 0 |
| Opened_tables | 59 |
| Questions | 31093 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 7 |
| Select_range | 5330 |
| Select_range_check | 0 |
| Select_scan | 3806 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 8092 |
| Sort_rows | 3539268 |
| Sort_scan | 2930 |
| Table_locks_immediate | 34806 |
| Table_locks_waited | 23 |
| Threads_cached | 0 |
| Threads_created | 41 |
| Threads_connected | 22 |
| Threads_running | 1 |
| Uptime | 6069 |
+--------------------------+-----------+

复制代码

请问这是什么原因造成的？或者什么原因可能引起这样的问题？

文库|博客

返回列表

Chinaunix › 论坛 › 数据库技术 › MySQL › 发帖很慢，看帖很快