Re:Dynimize: Speed Up MySQL with CPU Performance Virtualization
by davidyeager on Wednesday May 09, 2018 @03:32AM
(#17028016)
These specific tests we did were read only where the working set fits into memory, so SSD vs HDD doesn’t matter because they were CPU bound tests to highlight the performance improvements. So storage isn’t a factor here. If that wasn’t the case then faster storage would help make it more CPU bound and Dynimizer would make a bigger impact when using SSD vs HDD.
Re:Dynimize: Speed Up MySQL with CPU Performance Virtualization
by esterly on Wednesday May 09, 2018 @12:16AM
(#17027374)
If you have a DB bigger than RAM yes SSD makes a huge difference. I haven't considered non SSD in servers for 3 years when factoring in engineering cost https://dba.stackexchange.com/a/59903 see DHH circa 2009 https://signalvnoise.com/posts/1509-mr-moore-gets-to-punt-on...
https://dynimize.com/blog/discussions/dynimizer-mysql-cross-...
It seems to me the only system with SSDs (Ivy Bridge) sees higher transactions per second improvement than the other systems.
https://dynimize.com/performanceSpeedup