search

verdict-project / verdict

Interactive-Speed Analytics: 200x Faster, 200x Fewer Cluster Resources, Approximate Query Processing
http://verdictdb.org
Apache License 2.0
248 stars 66 forks source link

[feature request] Add support for MySQL 8.0 #152

Open breadchen opened 6 years ago

breadchen commented 6 years ago

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

pyongjoo commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 notifications@github.com 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 https://github.com/mozafari/verdictdb/issues/152#issuecomment-401274478, or mute the thread https://github.com/notifications/unsubscribe-auth/ABDsL5pS6CH06sRw24siKB6WtUJ3PDSXks5uBdl9gaJpZM4UCVGn .

pyongjoo commented 6 years ago

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