Database Blog

• MySQL and MariaDB Encryption Options

  Dec 10, 2019

  Reading Time: 4 minutes MySQL and MariaDB Encryption Options Encryption remains one of the most widely used cornerstones of data security across organizations of all sizes and industries. Why? In many cases it’s both effective and relatively simple to implement. There are two fundamental encryption capabilities that are almost universally necessary for basic data security: The ability to encrypt sensitive data “at rest”—that is, where it resides on disk—is a critical security capability for many organizations and applications, as…..

  Read more Add new comment

• MySQL Parser Deficiencies

  Jul 5, 2013

  Reading Time: 3 minutes MySQL is a very popular database for many applications. But the parser has some important deficiencies that developers need to be aware of. The parser is inconsistent and not robust in the way that it enforces statement syntax. This may lead to ambiguity and application defects that are very difficult to find. I include one example below and link to another blog article that discusses another. Inadequate Group By Parsing The MySQL group by function…..

  Read more Add new comment

• Query Rewrite: What is MySQL Doing To My Queries?

  Nov 30, 2011

  Reading Time: < 1 minute The Impact of Query Rewrite on MySQL Query Optimization When processing a query, every relational database vendor takes a number of similar steps to parse, validate, and optimize a query. MySQL does the following: Validates the query syntax — does it use valid operators, are the clauses in the proper order, etc. Validates the query semantics — are the the objects (tables, views, columns) valid database objects in the database, etc. Transforms the query —…..

  Read more Add new comment