எளிய தமிழில் MySQL - [ 1 to 30 Pages ]

Database --> Its a software to store data in a structured way.
SQL --> Structure Query Language - Its a language used to store data in database.
RDBMS --> Its management software used to connect the data database.

Now coming to MYSQL : Its a RDBMS software , Free software under GPL.

It as server and client.
MYSQL Client --> Front end Tool / Console Prompt in windows / Shell prompt, we type the command here.
MYSQL Server --> Will take the command from client and execute in server , which we can't see.It just gives the result.

Things MYSQL client does ,

Authentication for password check.
SQL queries will be changed to tokens , that tokens will be given to MYSQL server.
To monitor the Encrypt and compress network.
Then it gets the response from server and displays to the front end tool.

Things MYSQL Server does ,

Gets the request from client and then sends the response . _Management Layer & Storage Engine _ are responsible for this. ( Memory , Disk & Network are interconnected to these layer mentioned above )

Management Layer

Gets the request from client and கீழ இருக்கிற எல்லா வேலையும் பண்ணும் ,

connection decrypt or encode.
Queries check and parse them.
Get the Catched queries from Query cache
Then it sends to Storage Engine.
Disk and memory logs are its responsibility.

Storage Engine Layer

Database, tables , indexes are taken care here or managing.
Above related logs are taken care.
It also sends data to other MYSQL servers via network is also done.

INSTALLATION

sudo apt-get install mysql-server mysql-client

sudo mysql_secure_installation

Gave y & 0

In short , remove the anonymous user , only root can be executed only in localhost & remove the test database.

CONFIGURATION

cat /etc/mysql/my.cnf --> எல்லா configurationனும் இங்க தான் இருக்கும். OR /etc/mysql/mysql.conf.d/mysqld.cnf

create a backup file of the configuration like below,

sudo cp my.cnf my.cnf_bk_june172024 [ TBD , change in the config location ? ]

port = 3306
user = mysql
data dir = /var/lib/mysql
bind-address = 127.0.0.1
log_error = /var/log/mysql/error.log

[ Parameters to be seen ]

Query Cache [ TBD , where to put these values ? ]

All the queries which are executed in MYSQL Server , results are stored in cache.

query_cache_limit = 1m
query_cache_size = 16m

m --> MB
This m can be raised or decreased depends on the RAM.

Server Stop & Start

sudo service mysql restart
sudo service mysql stop
sudo service mysql start

MYSQL Client Installation

There are many in market,

sudo apt-get install MySQL-workbench --> second mostly used
sudo apt-get install MySQL-navigator
sudo apt-get install emma
sudo apt-get install MySQL-admin
sudo apt install phpmyadmin -y --> Best in market --> 1st