What are the directories in MySQL
This article mainly explains "what are the catalogs in MySQL". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the catalogs in MySQL"?
After the MySQL installation is complete, a directory is generated on disk, which is called the MySQL installation directory. The installation directory for MySQL contains subdirectories and configuration files with the suffix .ini. In order to learn MySQL better, beginners must understand the meaning and function of each subdirectory under the MySQL installation directory, and then explain it in detail for the MySQL installation directory.
Bin directory: used to place executable files, such as mysql.exe, mysqld.exe, mysqlshow.exe. Wait.
Data directory: used to place some log files and databases.
Include directory: used to place some header files, such as mysql.h, mysqld_ername.h, and so on.
Lib directory: the library file used to place some columns.
Share directory: used to store character set, language and other information.
In addition to the above five directories, the MySQL installation directory also has several configuration files with the suffix .ini, different configuration files represent different meanings, of which my.ini is the configuration file being used, and other configuration files are templates for configuration files suitable for different databases, and the appropriate database type is described in the file name.
My.ini: is the configuration file used in the MySQL database.
My-huge.ini: a configuration file suitable for very large databases.
My-large.ini: a configuration file suitable for large databases.
My-medium.ini: a configuration file for medium-sized databases.
My-small.ini: a configuration file suitable for small databases.
My-template.ini: is the template for the configuration file that the MySQL configuration wizard writes to the my.ini file.
My-innodb-heavy-4G.ini: indicates that the configuration file is only valid for the InnoDB storage engine, and that the server's memory cannot be less than 4GB.
Thank you for your reading, these are the contents of "what are the catalogs in MySQL?" after the study of this article, I believe you have a deeper understanding of what the catalogs in MySQL have, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
