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:
(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?
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:
(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?