mysql - ib_logfile files taking up too much space

Unnamed User

• October 05, 2024 08:28

hello
there is little space left in the disk area of ​​the partition where the centos operating system is installed.

/var/lib/mysql
ib_logfile0
ib_logfile1

there are 2 - 10 gb log files.

if we stop mysql and delete these files and then run it again, will it cause a problem?

or how can we reduce the size of these files without endangering the operation of the system.

if this process is risky, what are the unnecessary files that we can delete in the operating system partition without taking any risks.

Regards

• 

  cPRex Jurassic Moderator

  • October 07, 2024 14:57

  Hey there!  On your server, you only have two partitions - / and /home.  In your case, / includes *everything* on the machine that isn't inside /home, so all logs, databases, user creation data, the OS, cPanel itself, and many other things.

  Do you have a value set for innodb_log_file_size inside the /etc/my.cnf configuration file for MySQL?

  0

Please sign in to leave a comment.