connect-mysql-NT_4.0 1.4 KB
Newer Older
1
Testing server 'MySQL 3.23.25 beta' at 2000-09-27  2:55:59
2 3 4 5 6

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

Testing connection/disconnect
7
Time to connect (10000): 32 wallclock secs (10.92 usr 11.08 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
8 9

Test connect/simple select/disconnect
10
Time for connect+select_simple (10000): 37 wallclock secs (12.31 usr 11.61 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
11 12

Test simple select
13
Time for select_simple (10000):  4 wallclock secs ( 0.86 usr  1.70 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
14 15

Testing connect/select 1 row from table/disconnect
16
Time to connect+select_1_row (10000): 38 wallclock secs (12.33 usr 12.44 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
17 18

Testing select 1 row from table
19
Time to select_1_row (10000):  5 wallclock secs ( 1.13 usr  1.70 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
20 21

Testing select 2 rows from table
22
Time to select_2_rows (10000):  6 wallclock secs ( 0.97 usr  1.97 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
23 24

Test select with aritmetic (+)
25
Time for select_column+column (10000):  6 wallclock secs ( 1.06 usr  1.67 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
26 27

Testing retrieval of big records (65000 bytes)
28
Time to select_big (10000): 55 wallclock secs (19.89 usr  8.75 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
29

30
Total time: 183 wallclock secs (59.48 usr 50.92 sys +  0.00 cusr  0.00 csys =  0.00 CPU)