by David Stokes | Oct 12, 2022 | Insight for DBAs, Insight for Developers, MySQL
Oracle releases updates to MySQL on a quarterly basis and the Release Notes for 8.0.31 arrived just before the software. This time around there are some very interesting new features that will be handy including SQL standards support, as well as over 130 bug... by David Stokes | Oct 4, 2022 | Insight for DBAs, MySQL
If you watched Finding Poorly Designed Schemas and How to Fix Them you witnessed Marcos Albe use some very interesting queries. These queries let you find tables without primary keys, tables with non-integer primary keys, tables that do not use InnoDB, tables and... by David Stokes | Sep 13, 2022 | Insight for DBAs, MySQL, PostgreSQL
First, a big thanks for the kind responses to this series, and, as requested, here is an overview of index types available in PostgreSQL. The supporting video with bonus material can be found here.PostgreSQL has several popular index types including B-tree, Hash,... by David Stokes | Sep 1, 2022 | Insight for DBAs, MySQL, Percona Software
You may have read MyRocks Use Case: Big Dataset and been intrigued enough to want to evaluate RocksDB with InnoDB. It has several advantages including requiring less storage space.So how do you start?On a fresh install of Percona Server for MySQL, install... by David Stokes | Aug 29, 2022 | Insight for DBAs, MySQL, PostgreSQL
Those new to the realm of PostgreSQL from other databases will find little gems sprinkled liberally through the software. One of those gems is the watch command. It can be used to repeatedly run a query over and over again.Pretend you are watching the progress... by David Stokes | Aug 18, 2022 | Insight for DBAs, MySQL, PostgreSQL
Thank you for the many kind responses to this series. There are many out there who have MySQL experience and are seeking to expand into PostgreSQL for reasons ranging from simple curiosity to fortifying their professional skills. Now that we have covered the... by David Stokes | Jul 28, 2022 | Insight for DBAs, MySQL, PostgreSQL
Episode 8 in the PostgreSQL for MySQL DBAs series covers materialized views. MySQL has had views for many years and they are very useful, but it has never had materialized views. Those who use materialized views appreciate their utility and here we will cover how they... by David Stokes | Jul 27, 2022 | Insight for DBAs, MySQL
MySQL 8.0 is now over four years old and Oracle released the latest quarterly offering today with MySQL 8.0.30, which comes with lots of bug fixes and some interesting additions. This is my take on the release notes for those who do not have the time to wade... by David Stokes | Jul 18, 2022 | Insight for DBAs, MySQL, PostgreSQL
Experienced MySQL DBAs exploring PostgreSQL are often shocked to learn that they will need to vacuum their tables. This is not using a Hoover brand-like device or letting a Roomba-like robot loose on the server. Vacuuming is a necessary part of maintenance on a... by David Stokes | Jul 15, 2022 | Insight for DBAs, MySQL, PostgreSQL
The differences between MySQL and PostgreSQL are often trivial but occasionally there are stark differences. A MySQL DBA wanting to optimize a query on a PostgreSQL server will hopefully have some experience with using EXPLAIN. For the uninitiated, the... by David Stokes | Jun 30, 2022 | Insight for DBAs, MySQL, PostgreSQL
Many MySQL DBAs have expressed interest in learning about PostgreSQL and this series is a guided tour through the basics. One of the ‘Wow! That is Different!’ things for MySQL DBAs looking at PostgreSQL are sequences. Sequences can be used as a rough... by David Stokes | Jun 21, 2022 | Insight for DBAs, MySQL, PostgreSQL
The videos for PostgreSQL for MySQL Database Administrators (DBA) episodes three and four are live here and here. Episode three covers a simple backup and restoration while episode four covers some handy PSL commands. For those of you who missed the first... by David Stokes | May 31, 2022 | Database Trends, Insight for DBAs, Percona Software
I am a big fan of Percona Monitoring and Management (PMM) and am happy to report that setting up Percona Platform is as easy to set up and offers a lot of value. Percona Platform reached GA status recently and I think you will find it a handy addition to your... by David Stokes | May 26, 2022 | Insight for DBAs, MySQL, Open Source
Last week at Percona Live, I was asked what book I recommend for novices seeking to learn MySQL. For a long time, there has not been a good choice for modern versions of MySQL. Luckily I had just stumbled upon such a book. Now I am happy to recommend The... by David Stokes | May 24, 2022 | Database Trends, Insight for DBAs, PostgreSQL
PostgreSQL 15 Beta 1 was announced on May 15th and to keep with the spirit of past peeks at MySQL and MariaDB products, this is a cursory glance at the release notes to see what is coming. This is a preview of all the features that will be in the General... by David Stokes | Apr 27, 2022 | Insight for DBAs, MySQL
Oracle released MySQL Server 8.0.29 on April 26th and this is a quick review of the release notes. I have put my own comments in italics.So what is in the ’29 release of MySQL Server? Does it come festooned with new, neat features or is it a big... by David Stokes | Apr 15, 2022 | Percona Events, Percona Live
Percona Live is about one month away and the schedule has a lot of content. But what are we missing?Occasionally we have speakers who cannot make the event at the last minute or discover a room with an unused time slot. So, if we had one of these speaking slots... by David Stokes | Mar 30, 2022 | Insight for DBAs, Insight for Developers, MySQL
MySQL Shell For VS Code integrates the MySQL Shell directly into VS Code development workflows and was released last week. This extension to the popular VS Code platform enables interactive editing and execution of SQL for MySQL Databases and optionally the MySQL... by David Stokes | Mar 28, 2022 | Insight for DBAs, MariaDB
MariaDB 10.9 is a preview release of the popular open source database server and is considered alpha level code (pronounced: Not for production). It offers a glimpse of the evolution of the product and introduces some new features, at least for MariaDB. Since I... by David Stokes | Mar 25, 2022 | Insight for DBAs, Monitoring, Percona Software, Security
Percona Monitoring and Management (PMM) is a multi-faceted tool that includes the Security Threat Tool which provides the ability to check your databases for potential configuration or performance problems. And boy was I shocked to find I had problems when I...