MySQL Managing Storage Engines

System Databases(Schema), Storage Engines , Default MySQL files and table files

show databases;

use sys

select * from processlistG

select * from host_summaryG

Select * from user_summaryG

Select * from user_sessionG

use mysql

select * from userG

select * from pluginG

use performance_schema

use information_schema

Select * from tablesG

#In terminal 1 (MySQL)
create database db1;

use db1

#In Terminal 2 (Linux)

ls /var/lib/mysql

ls /var/lib/mysql/db1

#In terminal 1 (MySQL)
Create table tblINNODB(ID int) engine=INNODB;

#In Terminal 2 (Linux)

ls /var/lib/mysql/db1

#In terminal 1 (MySQL)
Create table tblMyISAM(ID int) engine=MYISAM;

#In Terminal 2 (Linux)

ls /var/lib/mysql/db1

#In terminal 1 (MySQL)
Create table tblMemory(ID int) engine=MEMORY;

#In Terminal 2 (Linux)

ls /var/lib/mysql/db1

#In terminal 1 (MySQL)
Create table tblCSV(ID int) engine=CSV;

#In Terminal 2 (Linux)

ls /var/lib/mysql/db1

#In Terminal 1(MySQL)

drop database db1;

DBA Master