MySQL Administration – day 3

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

show databases;

use sys

select * from processlist\G

select * from host_summary\G

Select * from user_summary\G

Select * from user_session\G

use mysql

select * from user\G

select * from plugin\G

use performance_schema

use information_schema

Select * from tables\G

#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;

Author: Sauras Pandey

Sauras Pandey is an MCP, SQL Server DBA/Architect with 9+ years of experience working in a variety of environments

Leave a Reply

Your email address will not be published.