| PHP, MySQL General PHP questions. Or go to our PHPsuexec Forum >> |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
|
|
#1 (permalink) |
|
Registered User
Comfy Contributor
Joined in Jan 2005
110 posts
Gave thanks: 2
Thanked 0 times
|
Managing an oversized MySQL Table
HI all, we have a data table that is a bit big for it's own good. We have deleted a truck load of records from it but it's file size hasn't changed. Can anyone let us know how we go about crunching down the space we have freed up.
Thanks in advance. W.
__________________
If everything was idiot proof, they would build a better idiot www.itcommunications.com.au |
|
|
|
|
|
#2 (permalink) |
|
Race Surpass
Super #1
Joined in Jul 2006
Lives in Oklahoma City, OK
Hosted on sh102
1,222 posts
Gave thanks: 18
Thanked 86 times
|
Might want to read this: MySQL :: MySQL 5.0 Reference Manual :: 12.5.2.5 OPTIMIZE TABLE Syntax
__________________
|
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Rate This Thread | |
|
|