Timeline for MySQL Optimization Guidance Needed
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Aug 21 at 20:07 | history | suggested | tripleee | CC BY-SA 4.0 |
Remove spammy promotion
|
| Aug 19 at 17:55 | review | Suggested edits | |||
| S Aug 21 at 20:07 | |||||
| Jun 24, 2020 at 1:25 | comment | added | danblack | Recommend watching percona.com/resources/videos/… as a talk how to use tools to diagnose memory leaks. Recommend as a test enable memlock so that all initial memory is allocated and you can tell the difference between initial allocated buffers that are used, and a potential memory leak. | |
| Jun 24, 2020 at 0:55 | comment | added | enyceexdanny | @WilsonHauck sorry for the late response. Been pretty crazy with the current situation of things. I've been noticing that mysql memory usage will keep growing until OOM. Settings haven't changed much from original post. Any ideas? | |
| Apr 1, 2020 at 11:12 | comment | added | Wilson Hauck | @enyceexdanny Let me know when you can Skype Talk with me, please. | |
| Apr 1, 2020 at 1:53 | comment | added | danblack |
An alternate view on max_connect_errors is that a network gitch that results in 10 errors will leave your database inaccessible and you'll be scratching your head for ages to work out why you can't connect and restarting the database server "magicly fixes it". If you are confident of your network/firewall rules, there's no need for any low setting IMHO. To check you're limits have had an effect check /proc/$(pidof mysqld)/limits. If you are changing the file limit in a systemd, you'll need to alter the service with LimitNOFILE.
|
|
| Apr 1, 2020 at 1:10 | comment | added | enyceexdanny | Also, when checking the file-max, it's currently showing: more /proc/sys/fs/file-max 3285843 | |
| Apr 1, 2020 at 0:56 | comment | added | enyceexdanny | So do I change both fs.file-max = 128000, soft nofile 128000, hard nofile 128000? | |
| Mar 27, 2020 at 18:21 | history | answered | Wilson Hauck | CC BY-SA 4.0 |