alter-table-mysql-nt_4.0

来自「开启mysql的远程连接的方法 mysql-noinstall-5.1.6-al」· 0 代码 · 共 17 行

Testing server 'MySQL 3.23.37' at 2001-04-19 13:10:14

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.13 usr  0.31 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

Time for alter_table_add (992): 1246 wallclock secs ( 0.52 usr  0.22 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

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

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

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

Total time: 2342 wallclock secs ( 0.91 usr  0.59 sys +  0.00 cusr  0.00 csys =  0.00 CPU)