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.
