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]

Reply via email to