IslandSQL Episode 4: Expressions
This post was originally published on this siteIntroduction In the last episode, we extended the IslandSQL grammar covering the complete lock table statement. However, the support for expressions was very limited. It was not possible to use a date literal or to_date function to determine a…
Memory leak in MySQL 8 with indexed generated virtual columns
This post was originally published on this siteSome time ago we have observed that memory for some MySQL instances has been constantly eaten away. Investigation pointed us to memory/innodb/memory area and databases with tables having generated virtual columns, which in addition were used in indexes….
IslandSQL Episode 3: Lock Table
This post was originally published on this siteIntroduction In the last episode we extended the IslandSQL grammar to cover all DML statements as single lexer token. Now it’s time to handle the complete grammar for one DML statement. The simplest one is lock table. A good…
IslandSQL Episode 2: All DML Statements
This post was originally published on this siteIntroduction In the last episode we build the initial version of IslandSQL. An Island grammar for SQL scripts covering select statements. In this blog post we extend the grammar to handle the remaining DML statements. The full source…
IslandSQL Episode 1: Select Statement
This post was originally published on this siteIntroduction An island grammar focuses only on a small part of a grammar. The island represents the small, interesting part and the sea the rest. In this blog post, I explain the components of an island grammar for…
Star Schema Design in Oracle: Partitioning
This post was originally published on this sitePartitioning is one of the most powerful features for data warehouses in Oracle databases. In this blog post, I explain how it can be used for the physical design of star schemas. What is the recommended partitioning strategy…
2022: Live again at Conferences
This post was originally published on this siteIt has become almost a tradition for me to write an annual review of my conferences and presentations. The good news: In 2022, most of the conferences were on-site again. Additionally, there was another important event for me…
proxysql-nagios with Python 3.x
This post was originally published on this siteIf you use MySQL together with ProxySQL and if you ever wondered if very handy proxysql-nagiosscript (https://github.com/sysown/proxysql-nagios) will work with Python 3.x, I can give you an answer – yes, but at least with the current version (v….
Duplication of Oracle database on same node/cluster with skip of tablespaces
This post was originally published on this siteIn this blog post I want to write about a typical restore scenario. You need to restore a database to a historical point in time to investigate some former data or maybe even rescue some data, but need…