And, by the way the myisamchk command will be myisamchk -dvv <table_name>
Eg: $ cd /home/mysql-data/data/test Considering the mysql data path is set in /home/mysql-data/ Here "test" is the database name. $ll -rw-rw---- 1 mysql mysql 8660 May 17 2004 abc.frm -rw-rw---- 1 mysql mysql 570 May 17 2004 abc.MYD -rw-rw---- 1 mysql mysql 1024 Dec 25 10:42 abc.MYI "abc" is the table name. So, the command which can be used is myisamchk -dvv /home/mysql-data/data/test/abc - 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]
