Dear Sirisha, The command "show table status from <Database_Name>" will give you the details pertaining to the type of the table(MyISAM/InnoDB) and also the memory used.
Hope this helps you. -Harish -----Original Message----- From: sirisha gnvg [mailto:[EMAIL PROTECTED] Sent: Saturday, December 25, 2004 12:30 AM To: mysql@lists.mysql.com Subject: if you know please answer immediately >I am a student and we are doing a project in mysql database monitoring. > 1 . we found that the memory used and free memory available for tables in individual database is given by myisamchk -d -v command.But we don't have any information about the tables or files myisamchk works on.so please give information if available. > 2 . we are required to find memory used and free memory available for all types of tables,log files of mysql,temporary tables used by mysql database.We don't get help from any of our professors since they don't have working experience in mysql. >please give details to any one of the above questions if not all the questions. Yahoo! India Matrimony: Find your life partneronline. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
