MySQL 8 -- A New Beginning

Dave Stokes (03.Nov.2018 at 11:10, 50 min)
Talk at Madison PHP Conference 2018 (English - US)

Rating: 4 of 5

MySQL 5.7 was the next received version of the most popular database on the web. But now MySQL is available with many new features plus improved performance. First there is a true data dictionary to store meta data instead of a series of files that tie up inodes; the good news is that you can now have millions of tables in a schema and the bad news is that you can not have millions of tables in a schema. Common Table Expressions and Windowing Functions to make it easier to write sub-queries and to perform analytics on your data. The new scheduler handles higher data contention levels, you get rue descending indexes, UTF8MB4 support (and it is the default character set), roles, and better JSON support.

Who are you?

Claim talk

Talk claims have been moved to the new Joind.in site.

Please login to the new site to claim your talk

Want to comment on this talk? Log in or create a new account or comment anonymously

Write a comment

 
Please note: you are not logged in and will be posting anonymously!
= six minus five

Comments

Rating: 4 of 5

03.Nov.2018 at 13:03 by Hrushikesh Ghatpande (13 comments) via Web2 LIVE

Lots of great information, I think there is so much new that it was probably hard to fit everything in one presentation (glad that there are two!)

Rating: 4 of 5

04.Nov.2018 at 06:39 by Corey Halpin (6 comments) via Web2 LIVE

I'll definitely be going back to my notes from this talk to see how we can use these new features in our application. I would have appreciated more information on how well (or if?) these new features comply with the SQL standards.

Rating: 4 of 5

04.Nov.2018 at 12:32 by Juan P Martinez Rios (16 comments) via Web2 LIVE

Lots of great info but way too fast

Rating: 4 of 5

04.Nov.2018 at 21:30 by Tony Dexter (4 comments) via Web2 LIVE

Good overview of improvements over previous version.

Rating: 5 of 5

07.Nov.2018 at 13:28 by Nick Escobedo (6 comments) via Web2 LIVE

Very knowledge and good information!

© Joind.in 2018