Tag: MySQL 8

Miscellaneous

Preview: Top MySQL 8 Features

Although there is no official software release for MySQL 8.0 as of yet, most insiders believe that it’s likely to arrive sometime in 2018.  In the meantime, Oracle has officially announced a tantalizing list of over two hundred new features!   We recently covered Replication Performance Enhancements.  Today’s blog will cover some of the other exciting …

Miscellaneous

Best New Features of MySQL 8

MySQL’s policy has traditionally been to produce a new general release of MySQL Community Server every 18-24 months. Believe it or not, the last general release for MySQL 5.7 was October 21, 2015, so we’re more than due for a new version of MySQL.  Well, as it happens, MySQL has unveiled a few release candidates …

Miscellaneous

PHP With MySQL: MySQL 8 Windowing Functions

Windowing functions are way to group rows of data for analysis. This provides a ‘window’ to look at only the relevant data only.  Plus there are about a dozen supporting functions to take advantage of all this. There is some carry over logically from the aggregate (or group by) functions but they open up some …

Performance, Replication

Replication Performance Enhancements in MySQL 8

Although it feels like it was only yesterday that Oracle released version 5.7 of their acclaimed MySQL Community Server, version 8 is already available as a development milestone release (DMR). No, you didn’t sleep through a bunch of releases; MySQL is jumping several versions in its numbering due to 6.0 being dropped and 7.0 being …

Troubleshooting

MySQL 8 and Common Table Expressions – An Introduction

MySQL 8 will have Common Table Expressions also known as CTEs.  I have had people asking me when  MySQL would have CTEs for years and I am glad to report they are ready for testing. What Does a CTE look like? The keyword WITH is the big hint that the statement is a CTE.  For now …