opensubscriber
   Find in this group all groups
 
Unknown more information…

n : newpki-users@newpki.org 26 July 2006 • 10:58PM -0400

Problem with file space used by the mysql BD
by Romain BOTTAN

REPLY TO AUTHOR
 
REPLY TO GROUP




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                     newpki-users@newp...
Automated List Manager                           majordomo@newp...

Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

Related Messages

opensubscriber is not affiliated with the authors of this message nor responsible for its content.