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 
<database name> or myisamchk -d -v <table_name> .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.

Reply via email to