davidyeager

6 ms·

1. 1.▲
   MySQL and Dynimize: 3.6M Queries per Second on a Single VM(dynimize.com)

   3 points by davidyeager 6y ago|0 comments
2. 2.▲
   Reduce MySQL CPU Usage Through Dynamic Binary Optimization(dynimize.com)

   3 points by davidyeager 7y ago|0 comments
3. 3.▲
   by davidyeager 8y ago

   Lots of ‘oh shit’ moments. Lots.
4. 4.▲
   by davidyeager 8y ago

   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
5. 5.▲
   by davidyeager 8y ago

   Sure does.
6. 6.▲
   by davidyeager 8y ago

   Yes we will correct the legend in that graph, thanks for reporting it. Dynimize is the company, Dynimizer the product. We may ditch the name Dynimizer and just go with Dynimize to avoid confusion. Thoughts? It is a general purpose approach
7. 7.▲
   by davidyeager 8y ago

   For a future update we will be optionally caching optimizations to forgo the optimizations/warmup period. You can then move those cached optimizations from test to production to reduce uncertainty. Coming soon. Many advantages there ov
8. 8.▲
   by davidyeager 8y ago

   Dynimizer can react to drastic changes in workload and reoptimize depending on how you configure it.
9. 9.▲
   by davidyeager 8y ago

   That was used to highlight the maximum improvement expected. When the working set doesn’t fit into RAM then you will get some combination of a smaller amount of performance improvement plus a reduction in CPU usage. The faster the storage,
10. 10.▲
    by davidyeager 8y ago

    Fair enough. This is valuable feedback. We have provided a more secure method on our home page and will provide package managed downloads as well, however the reality is that nothing is 100% secure. In the meantime, you can just download th
11. 11.▲
    by davidyeager 8y ago

    Yes it’s definitely being used in production. We’re starting to collect production use cases and will provide some on our website soon. Here’s an example website with growing traffic using MariaDB + Dynimizer with Wordpress, and they found
12. 12.▲
    by davidyeager 8y ago

    Works with VMs or on a VPS. We have done a lot of testing on KVM, Xen, and a bit on VMware. Still need to do a bit of work to properly support containers.
13. 13.▲
    by davidyeager 8y ago

    Of course these projects were a major source of inspiration for Dynimizer. However they are not JIT compilers. They are more like virtual machines or binary translators. Today DynamoRIO and Mojo (which ended up as Intel PIN) are used for pr
14. 14.▲
    by davidyeager 8y ago

    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
15. 15.▲
    by davidyeager 8y ago

    This does not rewrite your database. It optimizes the live in-memory machine code of the mysqld (MySQL Server) process. It must run on the same OS host as the mysqld (MySQL Server) process being optimized. So if you are using this on the ma
16. 16.▲
    by davidyeager 8y ago

    Here are the slides from Percona Live 2018: https://www.percona.com/live/18/sites/default/files/slides/A...
17. 17.▲
    by davidyeager 9y ago

    Sure. You can try using it with any program that meets these requirements, and over time the scope will be expanded futher: https://dynimize.com/manual#workloadRequirements However Dynimizer has only been thoroughly stress