Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Limiting mysql log file size

Tags:

database

logging

mysql

logfile

I have a mysql log file that regularly goes over 30gb, this sucks when you realise that your server is full because of this file. I need a simple solution to limit this file to about 1gb, i don't need logs that run that long, and i'd rather avoid this problem in the future.

Any ideas? Thanks

like image 905
Gregg Horton Avatar asked Nov 28 '12 20:11

Gregg Horton

People also ask

Does log file have limit?

The limiting factor for log files on a storage media is the currently available free storage size and not how old a log file is or how old its entries are.

What is a reasonable log file size?

A good STARTING POINT for your log file is twice the size of the largest index in your database, or 25% of the database size.

Does MySQL have a size limit?

You are using a MyISAM table and the space required for the table exceeds what is permitted by the internal pointer size. MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).

1 Answers

To specify it in the my.cnf file, backup your current my.cnf file (always recommended), stop slave, stop the MySQL server and place the following option:

   # relay log restrictions
   relay-log-space-limit=15G

Then save and quit the file and start MySQL. Unless you configured differently, MySQL will automatically start the slave thread.

like image 124
echo_Me Avatar answered Oct 13 '22 14:10

echo_Me
Sign in to Comment

Related questions

MySQL ALTER TABLE on tables too large to duplicate
Django project using wrong (old) database settings
Using Trigger to update table in another database
Profiling advice - trying to pinpoint site loading issue
MySQL SELECT a field as NULL if not existent in table
Retrieve data from database and display it dynamically in the rows of the table using textboxes
PHP proc_open problems on windows
Optimize group by sub query in Mysql
MySQL database engine: MyISAM for information_schema but InnoDB for other databases
Mysql: unknown variable, can't run any mysql applications, doesn't seem to be to do with my.cnf
COUNT() function each time, or store the value and increment it by one?
Generating large Excel files from MySQL data with PHP from corporate applications
How to select data from multiple tables using joins/subquery properly? (PHP-MySQL)
How to string format SQL IN clause with Python
Tricky SQL query involving consecutive values
PHP code is suddenly showing up in my web page rather than executing - wasn't doing this before?
Best way to store sort order/priority?
Designing Repeating PHP/MySQL Task
Hierarchical table - how to get paths of the items [linked lists in MySQL]
MySql SET intersection

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!