MySQL is a small relational database management system, which was developed by MySQL AB Company in Sweden. It was acquired by Sun Company on June 65438+ 10/6, 2008. At present, MySQL is widely used in small and medium-sized websites on the Internet. Because of its small size, high speed and low total cost of ownership, especially open source, many small and medium-sized websites choose MySQL as the website database to reduce the total cost of ownership. The official website of MySQL is www.mysql.com.

Features of MySQL

1. Written in C and C++, tested with various compilers to ensure the portability of the source code.

2. Support AIX, FreeBSD, HP -UX, Linux, Mac OS, Novell Netware, OpenBSD, OS/2 Wrap, Solaris, Windows and other operating systems.

3. Provide APIs for various programming languages. These programming languages include C, C++, Eiffel, Java, Perl, PHP, Python, Ruby and Tcl.

4. Support multithreading and make full use of CPU resources.

5. The optimized SQL query algorithm can effectively improve the query speed.

6. It can be used as a separate application in the client-server network environment, or embedded into other software as a library to provide multilingual support. Commonly used codes such as GB 23 12 in Chinese, BIG5 in Japanese and Shift_JIS in Japanese can be used as table names and data column names.

7. Provide database connection methods such as TCP/IP, ODBC and JDBC.

8. Provide management tools for managing, checking and optimizing database operations.

9. It can handle large databases with tens of millions of records.

Application of MySQL

Compared with other large databases such as Oracle, DB2 and SQL Server, MySQL has its own shortcomings, such as small scale and limited functions (the functions and efficiency of MySQL cluster are relatively poor), but this has not reduced its popularity at all. For ordinary individual users and small and medium-sized enterprises, MySQL provides more than enough functions, and because MySQL is open source software, it can greatly reduce the total cost of ownership.

At present, the popular website architecture on the Internet is LAMP(Linux+Apache+MySQL+PHP), which uses Linux as the operating system, Apache as the web server, MySQL as the database and PHP as the server-side script interpreter. Because these four softwares are all open source softwares that follow GPL, a stable and free website system can be established without spending a penny in this way.

MySQL management

You can use command line tools to manage mysql database (command MySQL and mysqladmin), or download graphical management tools MySQL Administrator and MySQL Query Browser from MySQL's website.

PhpMyAdmin is a MySQL database system management program written in php, which allows administrators to manage MySQL databases with a Web interface.

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

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