News for hackers. Stuff that matters.
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?
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).