关于mysql

Mysql 是一个快速的,多线程,多用户,支持强大的SQL 的数据库管理系统。MySQL Server适用于关键任务,重载生产系统以及嵌入大规模部署的软件。


MySQL是一个数据库管理系统。

数据库是数据的结构化集合。


MySQL数据库是关系型的。

关系数据库将数据存储在单独的表中,而不是将所有数据放在一个大的库中。逻辑模型具有数据库,表,视图,行和列等对象,可提供灵活的编程环境。

SQL is defined by the ANSI/ISO SQL Standard. The SQL standard has been evolving since 1986 and several versions exist. In this manual, SQL-92 refers to the standard released in 1992, SQL:1999 refers to the standard released in 1999, and SQL:2003 refers to the current version of the standard. We use the phrase the SQL standard to mean the current version of the SQL Standard at any time.


Internals and Portability

  • Written in C and C++.

  • Tested with a broad range of different compilers.

  • Works on many different platforms. See https://www.mysql.com/support/supportedplatforms/database.html.

  • For portability, uses CMake in MySQL 5.5 and up. Previous series use GNU Automake, Autoconf, and Libtool.

  • Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL tool (http://developer.kde.org/~sewardj/).

  • Uses multi-layered server design with independent modules.

  • Designed to be fully multithreaded using kernel threads, to easily use multiple CPUs if they are available.

  • Provides transactional and nontransactional storage engines.

  • Uses very fast B-tree disk tables (MyISAM) with index compression.

  • Designed to make it relatively easy to add other storage engines. This is useful if you want to provide an SQL interface for an in-house database.

  • Uses a very fast thread-based memory allocation system.

  • Executes very fast joins using an optimized nested-loop join.

  • Implements in-memory hash tables, which are used as temporary tables.

  • Implements SQL functions using a highly optimized class library that should be as fast as possible. Usually there is no memory allocation at all after query initialization.

  • Provides the server as a separate program for use in a client/server networked environment, and as a library that can be embedded (linked) into standalone applications. Such applications can be used in isolation or in environments where no network is available.

Security

  • A privilege and password system that is very flexible and secure, and that enables host-based verification.

  • Password security by encryption of all password traffic when you connect to a server.


mysql 命名 MySQL以联合创始人Monty Widenius的女儿My 命名。 由mSQL 演变而来,标志为海豚。

标签: Ubuntu CentOS mysql
相关文章
评论留言
发布留言