Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

optimizing and reindexing

Status
Not open for further replies.
richardko

richardko

Programmer
Jun 20, 2006
127
US
Hi,
I just deleted a bunch of old records from a Mysql table. The table has 32 indexes. Initially the phpMyAdmin showed that the table was 190MB and now it is at 186MB. I expected the size to be much smaller but its not. Do I need to compact mysql? If so can anyone give me an idea?
Also, do I need to reindex the table ?
thanks
 
Sort by date Sort by votes
i googled it and saw that:
OPTIMIZE TABLE tablename,
reduced the size.
Also, mysql, I guess doesnt have to be reindexed.
thanks for looking
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
416
penguinspeaks
penguinspeaks
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
396
EdLentz
EdLentz
Yossi Nixon
  • Locked
  • Question
MySQL CPU usage and CPU wait
Replies
1
Views
127
feherke
feherke
jyothi12389
  • Locked
  • Question
create a schedule and MYSQL loading csv data to table
Replies
0
Views
106
jyothi12389
jyothi12389
peekay
  • Locked
  • Question
ODBC in VB6 and MySql
Replies
4
Views
131
ChrisHirst
ChrisHirst

Part and Inventory Search

Sponsor

Back
Top