…to changes that really require table to be rebuilt – adding/dropping columns or indexes, changing data type, converting data to different character set – MySQL…to db1 at this stage. If you’re altering gigabyte size tables, this step may take some time…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…MySQL. Good design will help dictate how many tables are required in order to get the job done. To be good at…ALTER TABLE or OPTIMIZE TABLE > now locks small table for few seconds rather than giant 100GB table…how to create indexes. Foreign key references may add processing time to…
