On Fri, 8 Jun 2001, Udayavani Udayavani wrote:
> It has a table called "table1" this table has no records.
>
> But due to this table we are losing the 16 MB of space in our quota.
>
> I think its due to these files :
> Can we minimise the space accquired by "table1.ISD" by any means?
>
> What is the significance of all the 3 files?
Issue command "OPTIMIZE TABLE table1". About files: ISD is datafile, ISM
is indexfile and "frm" is place where table format is kept.
Also I suggest you to use newer MyISAM table format instead of ISAM. You
can do this with command "ALTER TABLE table1 TYPE=MYISAM". This worksonly
if MySQL is 3.23.x.MyISAM is faster and smaller in many circumstances.
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
/_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php