List: | General Discussion | « Previous MessageNext Message » | |
From: | Jim McAtee | Date: | July 23 2003 7:28pm |
Subject: | Is it necessary to compress tables? | ||
View as plain text |
Does MySQL automatically handle deleted row cleanup, or is it necessary to periodically do this manually for tables with a lot of deletions? If it's manual, what are the SQL commands to do this? Also, what happens when changes are made to a field definition? From, say, int to smallint, or tinyint to int, or varchar(255) to varchar(10)? Do temporary tables get created and the data copied over, or does unused space end up in the data files, to be collected later? Thanks.
Thread | ||
---|---|---|
• Is it necessary to compress tables? | Jim McAtee | 23 Jul |
• Re: Is it necessary to compress tables? | Jim McAtee | 23 Jul |
• Re: Is it necessary to compress tables? | Dan Nelson | 23 Jul |
• Re[2]: Is it necessary to compress tables? | Stefan Hinz | 24 Jul |
• Replication stopped without reason | trashMan | 24 Jul |
• Re: Replication stopped without reason | Dominicus Donny | 24 Jul |
• R: Replication stopped without reason | trashMan | 24 Jul |
• Re: R: Replication stopped without reason | Egor Egorov | 25 Jul |
• R: R: Replication stopped without reason | trashMan | 25 Jul |
• Re: Is it necessary to compress tables? | Jim McAtee | 24 Jul |
• Re: Replication stopped without reason | Info | 26 Jul |