Timeline for How to spec a machine for a particular database load?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 2, 2018 at 0:07 | comment | added | Wilson Hauck | @basedrum1 Your posting of ulimit -a indicates you are throttled only 1024 Open Files by your OS. If you will at your OS Command prompt, ulimit -n 24000 you will enable MySQL to open many fewer files during a day. To make the ulimit value persistent over the OS shutdown/restart review the content of this URL, please. glassonionblog.wordpress.com/2013/01/27/… Your specific OS may be slightly different. Review carefully. | |
| Aug 27, 2018 at 17:31 | comment | added | Wilson Hauck | @basedrum1 If the suggestions helped improve your response time, please upvote and if they really helped, maybe Accept the answer and avoid purchasing more hardware for a little while. But then, if the budget is available, buy the BEST and BIGGEST available. | |
| Aug 27, 2018 at 14:59 | comment | added | basedrum1 | Thanks for these suggestions for tuning. However, the point of the original question was to look for suggestions for what to look for in purchasing an actual piece of hardware, instead of using a VM. Regarding your tuning suggestions, I've changed most of these, as you suggest, with the exception of the max_connections, because we do have spikes that reach that high, they just were not represented in the status that was pasted here. | |
| Aug 18, 2018 at 14:11 | history | answered | Wilson Hauck | CC BY-SA 4.0 |