Summary: | dev-db/mysql:5.6 - adjusting default values in my.cnf | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | Tomáš Mózes <hydrapolic> |
Component: | Current packages | Assignee: | Gentoo Linux MySQL bugs team <mysql-bugs> |
Status: | RESOLVED FIXED | ||
Severity: | normal | ||
Priority: | Normal | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | Linux | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- |
Description
Tomáš Mózes
2014-10-08 13:58:50 UTC
(In reply to Tomas Mozes from comment #0) > innodb_log_file_size = 5M (5.6 default 48MB) This one is a little difficult to change automatically. It requires a user to delete the old ib_logfile{0,1} files or the server will refuse to start. It really should be done by the admin. I will look at the others. Seems like in 5.6 it's not that complicated anymore. I tried resing from 5MB to default 48MB. 2014-10-08 16:12:27 6171 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=20221136 2014-10-08 16:12:27 6171 [Warning] InnoDB: Starting to delete and rewrite log files. 2014-10-08 16:12:27 6171 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2014-10-08 16:12:27 6171 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2014-10-08 16:12:28 6171 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2014-10-08 16:12:28 6171 [Warning] InnoDB: New log files created, LSN=20221136 See also: http://www.percona.com/blog/2013/09/05/my-favorite-secret-mysql-5-6-feature/ Done. Thanks for the pointers. Though I did limit table_open_cache to 400 for now (5.5 default but still greatly improved). I may revisit this after testing how the default ulimit of 1024 would be affected or any issues from it. |