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
Introduction to MySQL Database Administration. What is MySQL? MySQL is the most popular open source SQL database management system and it is developed, distributed and supported by Oracle Corporation. Initially MySQL was introduced by MySQLAB organization and acquired by SUN MICRO SYSTEMS then MySQL acquired… Read More
There is no excerpt because this is a protected post.
