Re:Tuning Your DBMS Automatically with Machine Learning
by j_s on Saturday June 03, 2017 @07:24PM
(#14479049)
Any techniques, recommendations, and/or open source tools to simplify the archiving step you mentioned?
[ Parent
| on HN ]
Re:Tuning Your DBMS Automatically with Machine Learning
by seorphates on Saturday June 03, 2017 @08:33PM
(#14479279)
That's one of those things where money can go a long way quickly - fat i/o (including network if you're off-loading, sharding, peering, vdbs etc.), good cpu, efficient log sizes. Sticking to the basics is probably the best - if you're running high transaction and data change rates then the collective throughput "off" of your transaction server(s) is every bit as important as the throughput "on" the server(s).