connect-mysql_fast-Linux_2.2.14_my_SMP_i686-cmp-mysql,pg 1.37 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Testing server 'MySQL 3.23.22 beta' at 2000-08-17 19:16:28

Testing the speed of connecting to the server and sending of data
All tests are done 10000 times

Testing connection/disconnect
Time to connect (10000): 11 wallclock secs ( 6.50 usr  1.98 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Test connect/simple select/disconnect
Time for connect+select_simple (10000): 12 wallclock secs ( 7.41 usr  2.24 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Test simple select
Time for select_simple (10000):  2 wallclock secs ( 0.47 usr  0.54 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Testing connect/select 1 row from table/disconnect
Time to connect+select_1_row (10000): 14 wallclock secs ( 7.49 usr  2.28 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Testing select 1 row from table
Time to select_1_row (10000):  2 wallclock secs ( 0.54 usr  0.83 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Testing select 2 rows from table
Time to select_2_rows (10000):  4 wallclock secs ( 0.55 usr  0.65 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Test select with aritmetic (+)
Time for select_column+column (10000):  3 wallclock secs ( 0.51 usr  0.73 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Testing retrieval of big records (7000 bytes)
Time to select_big (10000):  6 wallclock secs ( 3.12 usr  1.22 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Total time: 54 wallclock secs (26.60 usr 10.48 sys +  0.00 cusr  0.00 csys =  0.00 CPU)