while Reseting auto increment for a table, query taking long time to update in MYSQL

Posted by urssujith on Stack Overflow See other posts from Stack Overflow or by urssujith
Published on 2010-04-21T09:58:39Z Indexed on 2010/04/21 10:13 UTC
Read the original article Hit count: 138

Filed under:
|
|

"ALTER TABLE tablename AUTO_INCREMENT = 10000000 " taking long time to update. why? i need to get optimize this query. Please help

© Stack Overflow or respective owner

Related posts about mysql

Related posts about query