Tag - data dictionary

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.
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