Tag - data dictionary

Webinar Wed 8/29: Databases in the Hosted Cloud

databases-in-the-cloud

Please join Percona’s Chief Evangelist, Colin Charles on Wednesday, August 29th, 2018, as he presents Databases in the Hosted Cloud at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4).
Register Now
 
Nearly everyone today uses some form of database in the hosted cloud. You can use hosted MySQL, MariaDB, Percona Server, and PostgreSQL in several […]

Read more

Webinar Wed 7/18: MariaDB 10.3 vs. MySQL 8.0

MariaDB 10.3 vs MySQL 8.0

Please join Percona’s Chief Evangelist, Colin Charles as he presents as he presents MariaDB 10.3 vs. MySQL 8.0 on Wednesday, July 18th, 2018, at 9:00 AM PDT (UTC-7) / 12:00 PM EDT (UTC-4).
Register Now
 
Technical considerations
Are they syntactically similar? Where do these two databases differ? Why would I use one over the other?
MariaDB 10.3 is […]

Read more

MySQL 8.0 General Tablespaces: File per Database (and no FRM files)

MySQL 8.0 innodb_dedicated_server

In this blog post, we’ll look at MySQL 8.0 general tablespaces.
Introduction
MySQL 8.0 (the DMR version is available now) has two great features (among others):

The new data dictionary completely removed *.frm files, which is great
The ability to create a tablespace and assign a group of tables to it (originally introduced in 5.7).

With those two options, we […]

Read more

InnoDB scalability issues due to tables without primary keys

Each day there is probably work done to improve performance of the InnoDB storage engine and remove bottlenecks and scalability issues. Hence there was another one I wanted to highlight:
Scalability issues due to tables without primary keys
This scalability issue is caused by the usage of tables without primary keys. This issue typically shows itself […]

Read more