It takes 8 minutes for mysql to create and delete indexes... current Environment: -------------- table row: 30W version 5.0.45-community-nt System XP CPU2.11G MEM2G test statement :----------------------
Create index I _atian ON gaopinzi (atian) drop index I _atian ON gaopinzi
Solution: adjust the parameter configuration of my. ini. Increase the size by 10 times. ------------------------------------------------------------ the original
Read_buffer_size = 64Kread_rnd_buffer_size = 256Ksort_buffer_size = bytes = 2Minnodb_log_buffer_size = 1 M [SQL] drop index I _atian ON gaopinzi
Affected row: 322750 time: 459.031 s my. ini increase by 10 times read_buffer_size = 80Mread_rnd_buffer_size = 80Msort_buffer_size = bytes = 200Minnodb_log_buffer_size = 100 m ql] drop index I _atian ON gaopinzi affected rows: 322750 time: 33.766
[SQL] create index I _atian ON gaopinzi (atian)
Affected rows: 322750 time: 35.890 s