icon Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog! | Welcome! Please register to access all of our features.

» Surpass Web Hosting Forums » Discussions » PHP, MySQL » Managing an oversized MySQL Table

PHP, MySQL General PHP questions. Or go to our PHPsuexec Forum >>

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
Old June 19th, 2008, 8:59 PM   #1 (permalink)
Registered User
Comfy Contributor
 
pulpfriction's Avatar
 
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
pulpfriction is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old June 20th, 2008, 12:54 AM   #2 (permalink)
Race Surpass
Super #1
 
MarkRH's Avatar
 
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
MarkRH is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On