News for hackers. Stuff that matters.

A comment on Tuning Your DBMS Automatically with Machine Learning.

Re:Tuning Your DBMS Automatically with Machine Learning by gerdesj on Saturday June 03, 2017 @07:04PM (#14478979)
On GitHub: "No description, website, or topics provided."

In the article: "and collects its Amazon EC2 instance type and current configuration"

... and I switched off.

I recently diagnosed a MySQL latency snag on a well known cloudy platform for a customer. I run rather a lot of comparative bonnie++, MySQL bench and Lord knows what else. I was able to convince the customer that my office PC ran MariaDB better simply because my single SSD on a rather shag Lenovo PC (a cast off from another customer!) had better i/o and latency than whatever they were being given by said cloudy provider.

I suggest you start with the basics: CPU, RAM, disc I/O and latency, network I/O and latency. Optimise those first and then work up the stack (and down, then back up etc.)

If you start with "assume a spherical EC instance" you may not be considering the whole problem -> solution -> realisation thing.

[ Parent | on HN ]
Re:Tuning Your DBMS Automatically with Machine Learning by matt4077 on Sunday June 04, 2017 @03:05AM (#14480233)
You should have stayed on: They get 80% lower 99%-quantile latency, and I don't see anything that would make their process dependent on bad hardware. Ignoring a chance for such improvements by just twiddling a few config parameters doesn't sound like a winning strategy.

(Not that I agree with your diatribe against cloud providers. They all have options with excellent performance, such as locally-connected SSDs)

[ Parent | on HN ]
Re:Tuning Your DBMS Automatically with Machine Learning by hashhar on Sunday June 04, 2017 @02:23AM (#14480140)
But then there's the issue of cost. Tuning performance on the software side only costs time and expertise but not money. And management doesn't really want to spend money unless you tell them they are going under within a week.
[ Parent | on HN ]
Re:Tuning Your DBMS Automatically with Machine Learning by throwanem on Sunday June 04, 2017 @08:28AM (#14481165)
Sounds like GP is a contractor. In that world, time and expertise is money - contracting rates aren't perceived as a sunk cost the way salaries are - and an SSD won't cost more than a few hours' billable time would. (Less than one hour, for high-end firms.)
[ Parent | on HN ]