求高人帮忙看看mysql的基准测试结果,给点优化建议
如题,能否再讲讲这个测试结果怎么看?
Date of test: 2007-07-26 17:14:19
Running tests on: Linux 2.6.9-42.ELsmp i686
Arguments:
Comments:
Limits from: mysql,pg,solid
Server version: MySQL 5.0.37 log
Optimization: None
Hardware:
alter-table: Total time: 288 wallclock secs ( 0.11 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.13 CPU)
ATIS: Total time: 13 wallclock secs ( 3.70 usr 0.14 sys + 0.00 cusr 0.00 csys = 3.84 CPU)
big-tables: Total time: 11 wallclock secs ( 3.08 usr 0.26 sys + 0.00 cusr 0.00 csys = 3.34 CPU)
connect: Total time: 43 wallclock secs (11.89 usr 6.91 sys + 0.00 cusr 0.00 csys = 18.80 CPU)
create: Warning: Can 't execute create. Check the file 'output/create-mysql-Linux_2.6.9_42.ELsmp_i686-cmp-mysql,pg,solid '
Failed (output/create-mysql-Linux_2.6.9_42.ELsmp_i686-cmp-mysql,pg,solid)
insert: Total time: 599 wallclock secs (192.87 usr 32.19 sys + 0.00 cusr 0.00 csys = 225.06 CPU)
select: Total time: 270 wallclock secs (18.97 usr 2.24 sys + 0.00 cusr 0.00 csys = 21.21 CPU)
transactions: Test skipped because the database doesn 't support transactions
wisconsin: Total time: 6 wallclock secs ( 1.40 usr 0.52 sys + 0.00 cusr 0.00 csys = 1.92 CPU)
Of 9 tests, 1 tests didn 't work
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 280.00 0.10 0.01 0.11 992
connect 3.00 2.31 &n