cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil lakineni <anilkumar459.lakin...@gmail.com>
Subject mysql-bin log files eating more space and DB server root fs filling up now at 98%
Date Mon, 25 Apr 2016 10:28:10 GMT
Hi All,

In Cloud DB server, the root file system reached to 98% and found that
*/var/lib/mysql/* is consumed with more space.

Inside that specified directory i found that " *mysql bin logs* " are
eating more space and files are there since one year.

My environment has enabled with DB replication.

Is it safe to purge the older mysql bin logs ? if yes, Could you please
paste the working steps here which wouldn't affect replication as some
blogs are saying that replication will be affected if we purge.

*Please recommend best solution that was already worked on production
environment*

So please suggest me the process to free up some space and clean up mysql
bin logs.

P.S. I have verified other directories and logs, they are consuming very
little space except this bin logs directory (not *ibdata1* file).

Cloud version is 4.5 and MySQL version is " 5.1.73-log "

My MySQL configuration file is,

#cat /etc/my.cnf
*[mysqld]*
*datadir=/var/lib/mysql*
*socket=/var/lib/mysql/mysql.sock*
*user=mysql*
*# Disabling symbolic-links is recommended to prevent assorted security
risks*
*symbolic-links=0*

*innodb_rollback_on_timeout=1*
*innodb_lock_wait_timeout=600*
*max_connections=1400*
*log-bin=mysql-bin*
*binlog-format = 'ROW'*
*innodb_buffer_pool_size=5500m*

*default-character-set=utf8*
*default-collation=utf8_unicode_ci*
*character-set-server=utf8*
*collation-server=utf8_unicode_ci*
*default-time-zone='+03:00'*

*# for Master / Slave*
*server-id = 1*

*[mysqld_safe]*
*log-error=/var/log/mysqld.log*
*pid-file=/var/run/mysqld/mysqld.pid*


Please let me know if any other information needed and please suggest the
process that would cleanup old logs automatically by mysql.

Hope will get some help here..

Regards,
Anil.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message