> > Qus 2. Is there any other way to compute the db size (other > than disk > > quota). > > > > du -s mysql_data_directory
If you want to know the size of a /single/ database (i.e. schema) then this method works if there's just one database in the mysql_data_directory. If there are multiple databases and they only contain MyISAM tables then `du -s mysql_data_directory/database_name` does the trick, but if a database also contains InnoDB tables then you're out of luck, since these are stored in the InnoDB tablespace, which is 'shared' by all InnoDB tables from all databases/schemas. To measure the size of my databases I use the 'show table status' command and I ignore .frm file size. Kind regards, -- Martijn -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this message and any attachments. ASML is neither liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
