MySQL / MariaDB Storage Engine

To see what storage engine is used by the server by default you can use the following command in the MySQL/MariaDB shell:

show variables like '%storage_engine';

You can view a list of supported engines using:

show engines\G;

To find out what storage engine your tables are using by schema use this command. You might want to filter by TABLE_SCHEMA to see a specific database.

select TABLE_SCHEMA, TABLE_NAME, ENGINE 
from information_schema.tables;

You can view statistics about a particular engine using the following (adjust for the relevant engine):

show engine innodb status\G

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How to create a backdated story on Medium

SQL Challenge: Case Study

Bootcamp: protecting the engineering culture during hyper growth

Running Electron on Apple Silicon (M1) Mac

Running Terminal app using Rosetta for x64 mode

Simple Image Steganography in Python

How to develop yourself as a developer. Very simple advice — read

Fayre Welcomes Apollo to Make Development Faster, Smoother and Safer

[Kubernetes] Access external services via Kubernetes service inside a Kubernetes cluster

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Praj Basnet

Praj Basnet

More from Medium

Getting Started With Version Control Systems -A practical approach on git

How to connect your pc to Gitlab with ssh

git ignore folder files in eclipse project

How to create JSON in PowerShell