Hi. I think you should upgrade your hardware and adjust your mysqld's parameters. Then your job will be fine.
David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/23 Adarsh Sharma <adarsh.sha...@orkash.com> > Dear all, > > Things becomes too lazy when it takes too much time. > > I am suffering from this problem when droping index of size 17.7 GB on a > table of size 24.7 GB. > This table have some more indexes of different sizes. > It takes near about 4 days to drop the index. > > Can anyone Please guide me whether it is fine in MySQL or things needed to > work on. > > > Thanks & Regards > > Adarsh Sharma > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=yueliangdao0...@gmail.com > >