summaryrefslogtreecommitdiff
path: root/sql-bench/Results/alter-table-mysql-Linux_2.2.16_SMP_alpha
blob: 3bc6b5449a59f652fdd122ee90397861e24e10e5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Testing server 'MySQL 3.23.31' at 2001-12-17 12:46:42

Testing of ALTER TABLE
Testing with 1000 columns and 1000 rows in 20 steps
Insert data into the table
Time for insert (1000) 0 wallclock secs ( 0.05 usr  0.07 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Time for alter_table_add (992): 195 wallclock secs ( 0.17 usr  0.09 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Time for create_index (8):  3 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Time for drop_index (8):  4 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Time for alter_table_drop (496): 155 wallclock secs ( 0.06 usr  0.04 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Total time: 357 wallclock secs ( 0.28 usr  0.20 sys +  0.00 cusr  0.00 csys =  0.00 CPU)