[feature request] Add support for MySQL 8.0

[breadchen]

Cause we need window function when create sample，maybe MySQL 8.0 is the only option ？

[pyongjoo]

Interesting that no one replied to this. We are rewriting some internal computations, and the new module won't rely on the window functions.

Our testing for the new version has not finished yet, so we haven't disclosed the new version. Right at the moment, it works with MySQL 5.5 or after.

[breadchen]

Good to know this, cause we are still using MySQL 7.0 in our product system.
One more question, is it possible to use VerdictDB to generate Histogram for MySQL.
For example we are doing Sharding on MySQL(spread data to MySQL databases and tables, access data through a middleware) . As I know VerdictDB uses SQL to collect statistical information from database, could I use that information to build Histogram and then use it in CBO?

[barzan]

Yes, it should be fairly straightforward to use a sample to compute stats using VerdictDB faster. Just write a SQL query for computing the histogram and route it through VerdictDB and put the output back in the historgram tables

…

-------- Barzan Mozafari, PhD Assistant Professor Computer Science and Engineering University of Michigan 2260 Hayward St. Ann Arbor, MI 48109-2121 Office: 4769 Beyster Phone: 734-763-3669 Twitter: https://twitter.com/BarzanMozafari

On Fri, Jun 29, 2018 at 12:08 PM, oldbread ***@***.***> wrote: Good to know this, cause we are still using MySQL 7.0 in our product system. One more question, is it possible to use VerdictDB to generate Histogram for MySQL. For example we are doing Sharding on MySQL(spread data to MySQL databases and tables, access data through a middleware) . As I know VerdictDB uses SQL to collect statistical information from database, could I use that information to build Histogram and then use it in CBO? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#152 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABDsL5pS6CH06sRw24siKB6WtUJ3PDSXks5uBdl9gaJpZM4UCVGn> .

[pyongjoo]

Now it should work with MySQL 5.5 or above. We have a tutorial here: https://docs.verdictdb.org/getting_started/quickstart/