mysqlconfigurer icon indicating copy to clipboard operation
mysqlconfigurer copied to clipboard

InnoDB Log File Size recommendations

Open drupaladmin opened this issue 8 months ago • 0 comments

InnoDB Log File Size InnoDB Log File Size innodb_log_file_size has to be changed every new recomendations, i think its depending on time of creation, i just increased it from 41943040 to 58720256, thats just an increase of about 40%, but before, it was way less than 1 hour of logging, now it increased to 915 minutes of log, i'm sure next time, innodb_log_file_size will be decreased and than its way less than 1 hour. As a lot of databases, queries (and log of innodb) differs per daytime like you see here: qsw1zwyd

(queries per second last 7 days) Maybe it would be a good idea to create a longer view of logfilesize or only look on LogFileSize on highest number of queries / logs.

Maybe i also have some missconfiguration or i have to adjust it more often to get better results?

drupaladmin avatar Jun 06 '24 07:06 drupaladmin