create-mysql-NT_4.0 909 Bytes
Newer Older
unknown's avatar
unknown committed
1
Testing server 'MySQL 3.23.37' at 2001-04-19 13:54:45
2 3 4 5 6

Testing the speed of creating and droping tables
Testing with 10000 tables and 10000 loop count

Testing create of tables
unknown's avatar
unknown committed
7
Time for create_MANY_tables (10000): 231 wallclock secs ( 3.27 usr  1.58 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
8 9

Accessing tables
unknown's avatar
unknown committed
10
Time to select_group_when_MANY_tables (10000): 196 wallclock secs ( 1.48 usr  1.77 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
11 12

Testing drop
unknown's avatar
unknown committed
13
Time for drop_table_when_MANY_tables (10000): 169 wallclock secs ( 1.41 usr  1.42 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
14 15

Testing create+drop
unknown's avatar
unknown committed
16 17 18
Time for create+drop (10000): 134 wallclock secs ( 3.78 usr  2.89 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Time for create_key+drop (10000): 167 wallclock secs ( 5.98 usr  2.77 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Total time: 897 wallclock secs (15.94 usr 10.42 sys +  0.00 cusr  0.00 csys =  0.00 CPU)