Re:Dynimize: Speed Up MySQL with CPU Performance Virtualization
by martin_ on Wednesday May 09, 2018 @02:11PM
(#17032279)
grogers explained my intent well, especially around the promotion of a replica to a primary work load (thank you). I think we're arguing semantics between optimizing machine code and rewriting mysqld. I want to emphasize that Dynamizer looks super awesome, and I do intend to try it, so no offense was intended. Well done!
[ Parent
| on HN ]
Re:Dynimize: Speed Up MySQL with CPU Performance Virtualization
by davidyeager on Wednesday May 09, 2018 @03:51PM
(#17033340)
Thanks! Sorry for terse tone... just responding quickly from a smartphone while travelling :-) Your concerns are definitely valid and we are working on improving the situation.
Dynimizer can detect a drastic workload change as you described and reoptimize in response. That’s the default operation which can be turned off. What has been observed is that if we optimized for say a write-heavy workload and then change it to read-only without reoptimizing (or vice versa), it will still show an improvement, just not as much. Hope that makes sense.