Day 11 MySQL System Database

Previous days we discuss Variables and configurations which are quite important for DBA to know. As stated earlier there are some system database MySQL has which will also contains very important information. Now on we will spend some time on discussion on those system databases. Today we will discuss about “mysql” system database. On latest version Oracle is moving most of the variables into System databases, so It could be possible that in future this databases will be more used and contains more information(from MySQL Ver 8.0 on but in our blog we will discuss till 5.7.x version).

Mysql database contains table related to following:

  • User related Tables: when you create user and provide access the information goes into these tables:

User,db, tables_priv, columns_priv ,procs_priv, proxies_priv

  • Object related Tables
  • Event,func, plugin, proc
  • Log related tables
    • General_log, slow_log
  • Time Zone related Tables
    • Time_zone.*
  • Replication related Tables
  • Optimizer related Tables

 

 

Reference:

https://www.ppgia.pucpr.br/pt/arquivos/techdocs/mysql/server-administration.html#system-database

Advertisements
This entry was posted in General, MySQL, Others, What I learned today and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.