Hi, (I know, it's my third mail in one day... joy of planning time do
things)
I'm again faced to hard disk space problem,
I knew that the problem i faced with and reported to the mailing list
about usage of disk space in mysql would be solved in new version but it
seems not,
as a report I made the migration of the server (beta to stable) the
10.07.06 without cleaning the logs in the BD and in the raw logs of mysql.
Than the July, 17 I observed that:
logs mysql *319M, *BD mysql:* 554M
I made a clean, than:*
logs mysql *319M, *BD mysql:* 107M
*
Then taken a look on the July, 19:
logs mysql *447M, *BD mysql:* 179M
*July,26:
logs mysql *904M* BD mysql:*440M*
(the "logs mysql" is the size of */var/log/mysql)
(the "BD mysql" is the size of /var/lib/mysql)
for more details, on the BD:
17/07/06:
/var/lib/mysql# du -kxh --max-depth=1
672K ./mysql
4,0K ./test
192K ./newpki_server
672K ./NEWPKI_master_pki
374M ./NEWPKI_repository
204K ./NEWPKI_business_ca
4,1M ./NEWPKI_master_ca
288K ./NEWPKI_ssl_ra
17M ./NEWPKI_pub
18M ./NEWPKI_mail_ca
3,5M ./NEWPKI_ssl_ca
2,7M ./NEWPKI_mail_ra
440M .
After the cleaning og logs and logs_hash
**17/07/06:*
*/var/lib/mysql# du -kxh --max-depth=1*
*672K ./mysql
4,0K ./test
148K ./newpki_server
616K ./NEWPKI_master_pki
48M ./NEWPKI_repository
204K ./NEWPKI_business_ca
3,7M ./NEWPKI_master_ca
284K ./NEWPKI_ssl_ra
14M ./NEWPKI_pub
16M ./NEWPKI_mail_ca
3,2M ./NEWPKI_ssl_ca
2,7M ./NEWPKI_mail_ra
107M .
Today (july, the 26) :
/var/lib/mysql# du -kxh --max-depth=1
672K ./mysql
4,0K ./test
192K ./newpki_server
672K ./NEWPKI_master_pki
374M ./NEWPKI_repository
204K ./NEWPKI_business_ca
4,1M ./NEWPKI_master_ca
288K ./NEWPKI_ssl_ra
17M ./NEWPKI_pub
18M ./NEWPKI_mail_ca
3,5M ./NEWPKI_ssl_ca
2,7M ./NEWPKI_mail_ra
440M .
Do you know if it's normal (the growing of table seems to be less
important than on the old version and I thanks you for that ;)
*
_____________________________________________________________________
NewPKI http://www.newpki.org
User Support Mailing List [email protected]
Automated List Manager [EMAIL PROTECTED]