Scribd
Upload
3 views1 page

User Roles and Database Management Guide

The document outlines different user roles for database access, including Application User, Database User, Monitor User, Employee User, and Root User, each with specific privileges and access levels. It also provides SQL commands for creating users and granting privileges, along with server-level tuning responsibilities among teams. Additionally, it mentions key monitoring points for performance, such as process lists, CPU and RAM utilization, and load averages over different time frames.

Uploaded by

comedy Junction
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
3 views1 page

User Roles and Database Management Guide

The document outlines different user roles for database access, including Application User, Database User, Monitor User, Employee User, and Root User, each with specific privileges and access levels. It also provides SQL commands for creating users and granting privileges, along with server-level tuning responsibilities among teams. Additionally, it mentions key monitoring points for performance, such as process lists, CPU and RAM utilization, and load averages over different time frames.

Uploaded by

comedy Junction
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Application User: This user will be using for application side which will hit

database from backend.


Database user : This user is used by Database Admin for any changes or update
Monitor User: This user is used for monitor the all automated shell scripts for
security, backup etc.,
Employee User : This users connection having only read access for 24 hrs Employees
if any emergency needs
Root User : Root user credentials will be not shared to anyone it’ll be there with
only admins.

create user 'username'@'host' identified by 'password';


grant select on *.* to 'username'@'host';
grant all privileges on *.* to 'username'@'host' with grant option;

Application user privileges


Insert, update, select, excute, create, alter
delete, drop

Server level tuning...

1. Application team.
2. Database team.
3. Network team.

Checking points :
1. processlist- If any process is running more than 5min
please save it in notepad
2. CPU and RAM utilization - top
process name which is using more cpu and RAM
3. Deadlocks :
Mysql login , show engine innodb status\G

load avergae: 1.98, 2.15, 2.21

The numbers are read from left to right, and the output above means that:

load average over the last 1 minute is 1.98


load average over the last 5 minutes is 2.15
load average over the last 15 minutes is 2.21

You might also like