Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What are the main features of MySQL

2025-01-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

What are the main characteristics of MySQL? I believe many inexperienced people are at a loss about it. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

1. Internal and portability

Written in C and C++. Write it in C and C++.

Test with a variety of different compilers. Through a large number of different compiler tests.

Working on many different platforms is suitable for many different platforms.

CMake is used in MySQL 5.5 and later for portability. Previous series used GNU Automake, Autoconf, and Libtool. Portability.

Designed to be fully multithreaded using kernel threads for easy use when multiple CPU are available. Multithreading support

Provides transactional and non-transactional storage engines. Supports both transactional and non-transactional storage engines.

Extremely fast B-tree disk table (MyISAM) using index compression.

Designed to make it relatively easy to add other storage engines. This is useful if you want to provide a SQL interface for the internal database.

Use a very fast thread-based memory allocation system.

Perform very fast joins using optimized nested loop joins.

Implements a hash table in memory, which is used as a temporary table.

Implement SQL functions using class libraries that should be highly optimized as quickly as possible. There is usually no memory allocation at all after the query is initialized.

Provide the server as a separate program for use in the client / server network environment and as a library that can be embedded (linked) into stand-alone applications. Such applications can be used in isolated environments or in environments where there is no network available.

2. Data type

Many data types: signed / unsigned integers 1, 2, 3, 4 and 8 byte length, floating point, double precision, character, VARCHAR, binary, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS space types.

Fixed length and variable length string types.

3. Statements and functions

Full operator and function support in the SELECT list and WHERE clause of the query.

SQL GROUP BY and ORDER BY clauses are fully supported. Group functions (COUNT (), AVG (), STD (), SUM (), MAX (), MIN (), and group_CONCAT ()) are supported.

Support left and right outer joins using standard SQL and ODBC syntax.

Aliases on tables and columns are supported as required by the standard SQL.

Delete, insert, replace, and update are supported to return the number of rows that have been changed (affected), or to return the number of matching rows by setting flags when connecting to the server.

Supports MySQL-specific SHOW statements to retrieve information about databases, storage engines, tables, and indexes. Supports information schema database, which is implemented according to the standard SQL.

The EXPLAIN statement that shows how the optimizer parses the query.

The independence of the function name from the table or column name.

You can reference tables from different databases in the same statement.

4. Security

Privileged and cryptographic systems are very flexible and secure, and support host-based authentication.

Password security is achieved by encrypting all password communications when connecting to the server.

5. Scalability and limitations

Support for large databases. We use the MySQL server for a database that contains 50 million records. We also know that some users use the MySQL server to process 200000 tables and 5000000000 rows.

Supports up to 64 indexes per table. Each index can consist of 1 to 16 columns or partial columns. The maximum index width of the InnoDB table is 767 bytes, and the maximum index width of MyISAM is 1000 bytes. Indexes can use column prefixes of CHAR, VARCHAR, BLOB, or TEXT column types.

6. Connectivity

Clients can connect to MySQL servers using a variety of protocols:

Clients can connect using TCP/IP sockets on any platform.

On Windows systems, if you start the server with the-- enable named pipe option, clients can connect using named pipes. If started with the-- shared memory option, the Windows server also supports shared memory connections. Clients can use the-- protocol=memory option to connect through shared memory.

On Unix systems, clients can connect using Unix domain socket files.

MySQL client programs can be written in multiple languages. Client libraries written in C can be used on clients written in C or C++, or in any language that provides C binding.

Available for C, C++, Eiffel, java, perl, php, python, Ruby and TCL,API, enabling MySQL clients to write in multiple languages.

The Connector/ODBC (MyODBC) interface provides MySQL support for client programs that use ODBC (Open Database Connectivity) connections. For example, you can use MS Access to connect to a MySQL server. The client can run on Windows or Unix. Connector / ODBC source is available. All ODBC 2.5 features are supported, as are many other features.

The Connector/J interface provides MySQL support for Java client programs that use JDBC connections. The client can run on Windows or Unix. Connector / J source is available.

MySQL Connector/Net enables developers to easily create .net applications that require secure, high-performance data connections to MySQL. It implements the required ADO.NET interface and integrates into tools that support ADO.NET. Developers can build applications in the .NET language of their choice. MySQL Connector/Net is a fully managed ADO.Net driver written in 100% pure language

After reading the above, have you mastered what are the main features of MySQL? If you want to learn more skills or 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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report