Shulou(Shulou.com)05/31 Report--

Editor to share with you what are the technical characteristics of MySQL, I hope you will gain something after reading this article, let's discuss it together!

Technical characteristics of MySQL

(1) the core thread it uses is completely multithreaded and supports multiprocessors.

(2) there are many column types: 1, 2, 3, 4 and 8 byte length self-signed / unsigned integers, FLOAT, DOUBLE, CHAR, VARCHAR, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR and ENUM are similar.

(3) it implements the SQL function library through a highly advanced class library and is as fast as it is. Usually, there should not be any memory allocation after query initialization. There is no memory leak.

(4) fully support the GROUP BY and ORDER BY clauses of SQL, and support aggregate functions (COUNTO (), AVG (), STD (), SUM (), MAX () and MIN ()). You can have tables from different databases in the same query.

(5) support LEFTOUTER JON and ODBC of ANSI SQL.

(6) all columns have default values. You can use INSERT to insert a subset of table columns, and those columns that are not explicitly given values are set to their default values.

(7) MySQL can work on different platforms. Support C, C++, Java, Perl, PHP, Python and TCLAPI.

(8) the network connection can be made very quickly by using the optimized scan multiple connection (one-sweepmulti-join) tool.

(9) the SQL function library is implemented through a highly optimized class library, usually without any memory allocation after query initialization.

(10) tables from different databases can be mixed in the same query.

(11) flexible and secure permissions and password systems, and allow authentication from other hosts, passwords are more secure, because when connected to a server, all passwords are encrypted.

(12) large database processing. You can use MySQL for some databases that contain 50000000 records.

(13) there is no memory leak.

(14) all MySQL programs can use "# # help" or "_?" Option for online help.

(15) the server can provide customers with error messages in multiple languages.

(16) the client connects to MySQL using TCP/IP connections or command pipes under Linux (Socket) and NT.

(17) the MySQL-specific show command can be used to retrieve information about database tables and indexes, and the explain command can be used to determine how the optimizer solves a query.

After reading this article, I believe you have a certain understanding of "what are the technical characteristics of MySQL". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.