Many of our users, developers and database administrators, keep asking our team about EverSQL’s indexing recommendations algorithm.

(Peter Zaitsev) In this blog post, I’ll look at whether optimizing indexing is always the key to improving MySQL query performance (spoiler, it isn’t).

(Krzysztof Ksiazek) Security of data is critical for any organisation. It’s an important aspect that can heavily influence the design of the database environment.

(Rob Gravelle) 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.

(Dave Stokes) 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.

(Kedar Vaijanapurkar) Today lets talk a little about converting a MySQL table to CSV (Excel). My friend was looking to export MySQL to Excel, I saw couple of questions for export MySQL tables to CSV on forums.

(Tiago J.) Since the release of Group Replication, one of its main security features is IP Address Whitelisting. This allows us to control whoever can send requests to enter in a group.

(Alexander Rubin) In this blog post, we’ll look at ways you can use MySQL 5.7 generated columns (or virtual columns) to improve query performance.

(Øystein Grøvlen) Last month I published a blog post at mysqlserverteam.com about how the Query Optimizer in MySQL 8.0 takes advantage of that InnoDB provides buffer estimates per table and index.

(Harin Vadodaria) Starting with MySQL 8.0.4, we are changing the default authentication plugin for MySQL server from mysql_native_password to caching_sha2_password. Correspondingly, libmysqlclient will now use caching_sha2_password as the default authentication mechanism, too.