Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about the components of mysql, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

Brief introduction of MySQL:

MySQL is a relational database management system, originally an open source relational database management system, originally developed by Sweden's MySQL AB company, which was acquired by Shenyang Microsystems (Sun Microsystems) in 2008. In 2009, Oracle acquired Shenyang Microsystems, and MySQL became a product of Oracle.

MySQL has become the most popular open source database in the past because of its high performance, low cost and good reliability, so it is widely used in small and medium-sized websites on Internet. With the continuous maturity of MySQL, it is also gradually used in more large-scale websites and applications. The "M" in the very popular open source software combination LAMP refers to MySQL.

The components of mysql are:

Connection pool component

Manage services and tool components

SQL interface component

Query Analyzer component

Optimizer component

Buffer component

Plug-in storage engine

Physical file

One of the most important features that distinguishes MySQL database from other databases is its plug-in table storage engine.

The MySQL plug-in storage engine architecture provides a series of standard management and service support, which are independent of the storage engine itself, such as SQL analyzer and optimizer, while the storage engine is the implementation of the underlying physical structure, and each storage engine developer can develop according to his own wishes.

It is important to note that the storage engine is based on tables, not databases.

Management tools for MySQL:

You can use command-line tools to manage MySQL databases (commands mysql and mysqladmin), or you can download the graphics management tools MySQL Administrator, MySQL Query Browser, and MySQL Workbench from MySQL's website.

PhpMyAdmin is a MySQL database system management program written by php that allows managers to use the Web interface to manage MySQL databases.

PhpMyBackupPro is also written by PHP, and you can create and manage databases through the Web interface. It can create pseudo-cronjobs, which can be used to automatically back up the MySQL database at a certain time or cycle.

In addition, there are other GUI management tools, such as mysql-front, ems mysql manager,navicat and so on.

After reading the above, do you have any further understanding of mysql database? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.