alter-table-mysql-linux_2.2.1_i686-cmp-adabas,mysql

来自「开启mysql的远程连接的方法 mysql-noinstall-5.1.6-al」· 1_I686-CMP-ADABAS,MYSQL 代码 · 共 17 行

Testing server 'MySQL 3.22.18' at 1999-02-27 21:11:26

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

Time for alter_table_add (246): 28 wallclock secs ( 0.08 usr  0.01 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

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

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

Time for alter_table_drop (123): 20 wallclock secs ( 0.06 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

Total time: 52 wallclock secs ( 0.24 usr  0.05 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)