create-mysql-SunOS_5.7_sun4m 906 Bytes
Newer Older
unknown's avatar
unknown committed
1
Testing server 'MySQL 3.23.29 gamma' at 2000-12-17  1:21:57
unknown's avatar
unknown committed
2 3

Testing the speed of creating and droping tables
unknown's avatar
unknown committed
4
Testing with 10000 tables and 10000 loop count
unknown's avatar
unknown committed
5 6

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

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

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

Testing create+drop
unknown's avatar
unknown committed
16 17 18
Time for create+drop (10000): 995 wallclock secs (21.72 usr 10.16 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Time for create_key+drop (10000): 995 wallclock secs (29.17 usr 10.77 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Total time: 4844 wallclock secs (79.86 usr 40.22 sys +  0.00 cusr  0.00 csys =  0.00 CPU)