You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
The text was updated successfully, but these errors were encountered:
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?
The text was updated successfully, but these errors were encountered: