Re: if you know the answer,please answer immediately contd

[mailinglists]

Take a look at http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html and 
http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html & 
http://groups.google.be/groups?hl=nl&lr=&ie=UTF-8&threadm=cb9qd5%241oqt%241%40FreeBSD.csie.NCTU.edu.tw&rnum=3&prev=/groups%3Fq%3Dmyisamchk%2Bmonitoring%26hl%3Dnl%26lr%3D%26ie%3DUTF-8%26selm%3Dcb9qd5%25241oqt%25241%2540FreeBSD.csie.NCTU.edu.tw%26rnum%3D3

What platform are you using?

Rik

Op zaterdag 25 december 2004 06:17, schreef sirisha gnvg:
> myisamchk

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

if you know the answer,please answer immediately contd

[sirisha gnvg]

 
 
I am a student and we are doing project in mysql database monitoring.Yesterday 
I posted my doubts regarding that project to this forum.
 
I got reply from Mr.Harish, his suggestion is to use show table status 
 or myisamchk -d -v  .Thank you sir for your reply.
 
Actually i haven't made the queations clearer.
 
This is what we have to do in our project,we have to monitor mysql database and 
continously calculate memory already used by and free memory available for each 
database(or table),each log file,each temporary table(mysql temporary 
tables).If free memory is less than a certain percentage we have to send an 
alert box to the user asking him to backup those tables and logfiles.
So we need information about both used space and free space not just the size 
of those tables or log files.
 
I asked to give details about the tables myisamchk  works on.By that question I 
mean that because Myisamchk is giving details about memory used by tables those 
details should have been stored in some system tables or files.We need the 
names of those system tables or files.
   
   So if you have information regarding any of the above issues please 
answer immediately.
 
yours sincerely,
sirisha.  


Yahoo! India Matrimony: Find your life partneronline.