Matadata (INFORMATION_SCHEMA) WHAT IS METADATA ? As per definition it is DATA ABOUT DATA. In MySQL METADATA stored in INFORMATION_SCHEMA. INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a… Read More
MySQL Clients Learning Objectives : List the available clients for administrative tasks and their basic purposes. Invoke mysql clients and common command line options. Invoke and us the MySQL command line client MySQL. Use the mysqladmin for administrative clients APIs (Drivers and Connectors). Overview… Read More
LOG FILES IN MySQL. Before going to look on logfiles we need to know what is the use of my.cnf file. By default my.cnf file will be in /etc/my.cnf location, when ever you try to restart MySQL server look for my.cnf in /etc/ location.
|
1 2 |
[root@ip-172-31-39-223 ec2-user]# ll /etc/my.cnf -rw-r--r--. 1 root root 1066 Sep 10 10:32 /etc/my.cnf |
Installing MySQL on Amazon linux Using the MySQL Yum Repository In this article we will see steps to install MySQL on Amazon Linux Using the MySQL Yum Repository Use below link to create EC2 instance Launch linux virtual server ec2 instance in aws Steps to… Read More
Improving MySQL installation Security(UNIX Platform). 1.The mysql_secure_installation programs enables security improvement . Set password for root accounts. Remove remote root accounts. Remove anonymous accounts. Remove the test database. 2.Invoking the program It will prompt for actions to perform . Only applicable to Unix/Linux operating systems.… Read More
MySQL installation using generic binaries-UNIX Platform. In this article we will come to know install MySQL using generic binaries. Learning Objectives : Choose the proper type of MySQL server software distribution. Get an overview of MySQL installation tasks. Load time zone tables. Start and Stop… Read More
MySQL Architecture -2(Disk space & Error logs). How MySQL will use disk space Disk space used primarily for files in the server’s data directory –> A sub directory for each database in the data directory. Data directory depends on distribution platform ,operating system. For Windows… Read More
MySQL Architecture When a query comes to MySQL from Client program it will go to Query parsing (hear it will check for SQL syntax by checking every character in SQL query and generate SQL_ID for each SQL query.) then it will sent to Optimization (Creates… Read More
MySQL Database Client programs & MySQL Workbench Below are few MySQL DB client programs MySQL – Mysql is a program actually connects to database. Most MySQL distributions include all of these programs, except for those programs that are platform-specific. (For example, the server startup scripts… Read More
Client/Server architecture of MySQL Networked environment using a client/server model. -central acts as server -Various client programs connects to the server and make requests. Components Of MySQL Installations : The MySQL Database also follows the client and server model architecture and following are the components… Read More
