This technique is not universal in the database world. Some other database products, and some other MySQL storage engines, do not support it. 

See Also ACID, concurrency, consistent read, isolation level, lock, transaction. 

my.cnf 

 The name, on Unix or Linux systems, of the MySQL option file . See Also my.ini, option file. 

my.ini 

 The name, on Windows systems, of the MySQL option file . See Also my.cnf, option file. 

MyODBC drivers 

 Obsolete name for Connector/ODBC . See Also Connector/ODBC. 

mysql 

 The mysql  program is the command-line interpreter for the MySQL database. It processes SQL  statements, and also MySQL-specific commands such as SHOW TABLES , by passing requests to the mysqld  daemon. See Also mysqld, SQL. 

MySQL Enterprise Backup 

 A licensed product that performs hot backups  of MySQL databases. It offers the most efficiency and flexibility when backing up InnoDB  tables, but can also back up MyISAM  and other kinds of tables. See Also hot backup, InnoDB. 

mysqlbackup command 

 A command-line tool of the MySQL Enterprise Backup  product. It performs a hot backup  operation for InnoDB tables, and a warm backup for MyISAM  and other kinds of tables. See Section 30.2, “MySQL Enterprise Backup Overview”  for more information about this command. See Also hot backup, MySQL Enterprise Backup, warm backup. 

mysqlclient 

 The informal name for the library that is implemented by the file libmysqlclient , with extension .a  or .so . See Also libmysqlclient. 

mysqld 

mysqld , also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL installation. It does not spawn additional processes. MySQL Server manages access to the MySQL data directory that contains databases, tables, and other information such as log files and status files. 

mysqld  runs as a Unix daemon or Windows service, constantly waiting for requests and performing maintenance work in the background. See Also instance, mysql. 

MySQLdb 

 The name of the open-source Python  module that forms the basis of the MySQL Python API . See Also Python, Python API. 

mysqldump 

 A command that performs a logical backup  of some combination of databases, tables, and table data. The results are SQL statements that reproduce the original schema objects, data, or both. For substantial amounts of data, a physical backup  solution such as MySQL Enterprise Backup  is faster, particularly for the restore operation. 

See Also logical backup, MySQL Enterprise Backup, physical backup, restore. 

