SQL Stunts

By João Osório | Personal insights and lab results related to database technologies, such as installation, security, administration, monitoring and development.

MySQL 8.0 - auto increment feature gets fixed

João Osório 2:23:00 AM mysql , transactions No comments<p>How InnoDB initializes AUTO_INCREMENT counters is actually not a bug, but a documented …

New tool: GitHub's online schema migration for MySQL

João Osório 4:07:00 AM migration , mysql , tools No comments<p>Shlomi Noach from the the Github engineering team posted the release of a new tool for …

Get a summary footprint on a MySQL server instance

João Osório 9:22:00 AM configuration , mysql , scripts No comments<p>Landing on an enterprise with ongoing projects mean that servers are often handed …

Real time query monitoring on MySQL - with 3rd party tool and without

João Osório 3:42:00 AM monitoring , mysql , performance , scripts , tools , tuning No comments<p>I've tried out Idera's MySQL Query Explorer, a free …

Real time query monitoring on MySQL using the SYS schema

João Osório 3:43:00 AM mysql , scripts , tools , tuning 1 comment<p>On an earlier post I wrote about real time query monitoring on MySQL with a third …

Using MySQL on Openshift - Red Hat's public cloud

João Osório 1:37:00 AM cloud , hosting , mysql , php , tools No comments<p>Developing a prototype, I found myself wanting a trustworthy cloud provider. …