On Fri, July 20, 2007 12:32, Andrew Rosolino said: > > Whenever I alter a mysql table like add a new field it gets really slow > and > all other processes lag. > Is there a memory variable I can adjust for this? > -- > View this message in context: Without more information it might be hard to answer. A general though: Alter Table causes the entire table to be re-created in its new form and then the old one deleted and the new one renamed. For a large table that is a significant bit of work (cpu, disk and memory). It might help if you could give the size of the table and what the alter involved (for example generating a new index would take even more time).
------ William R. Mussatto Systems Engineer http://www.csz.com 909-920-9154 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
