PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. For this reason, DROP FUNCTION requires the DELETE privilege for the mysql system database. Loadable functions, as the name implies, must be loaded into ...MySQL supports automatic function loading during server startup and manual loading ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. The ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
The use of COUNT() in conjunction with GROUP BY is useful for characterizing your data under various groupings. The following examples show different ways to perform animal census operations. See Section 12.19.1, “Aggregate Function ...Counting ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
Generally, the ON clause serves for conditions that specify how to join tables, and the WHERE clause restricts which rows to include in the result set. If there is no matching row for the right table in the ON or USING part in a LEFT JOIN, a row ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
You can obtain information about data files used by Disk Data tables by querying the FILES table in the INFORMATION_SCHEMA database. These include the following: Tablespaces act as containers for other Disk Data objects. For example, you cannot have ... NDB Cluster Disk Data storage is implemented using a number of Disk Data ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the source table on the source and the replicated table on the replica use different engine ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
The plugins supported by this interface include, but are not limited to, storage engines, INFORMATION_SCHEMA tables, full-text parser plugins, partitioning support, and server extensions. MySQL distributions include several plugins that implement ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. If there is no logical unique and non-null column ... Each InnoDB table has a special index called the clustered index that stores row ...