- 论坛徽章:
- 0
|
cpu 3.0 内存512台式机电脑.
mysql> status;
--------------
mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
Connection id: 163
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.0.27-community-nt-log
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 11 min 49 sec
Threads: 2 Questions: 1471 Slow queries: 0 Opens: 16 Flush tables: 1 Open t
ables: 10 Queries per second avg: 2.075
--------------
操作就是不停地插入删除或取出数据.一共三个表,每个大概30,000条数据.都加了索引,合计大小40M(导出的SQL)
大致操作比例 select:delete:insert=1:1:1
select,insert 几乎都不耗时,就是delete 每次耗时约1秒钟.
每秒钟才两个操作是不是太慢了?我记得这个论坛里有人达到200多个,哪里需要改进?请教 了.谢谢.
=======================================================
=======================================================
问题解决了.原因是因为大部分数据前面部分相同,导致索引没有起作用.谢谢各位关注.
[ 本帖最后由 wildlily980 于 2007-8-8 21:21 编辑 ] |
|