PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
It is not true for names of columns, constraints, databases, partitions, statements prepared with PREPARE, tables, triggers, users, and user-defined variables. If you plan to set the lower_case_table_names system variable to 1 on Unix, you must ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
The writer quota is enforced by the throttling mechanism if the queue size of the certifier or the binary log applier exceeds a user defined threshold. Whenever the size of one of these queues exceeds the user-defined threshold, the throttling ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-start-phases.html
Initialization consists of the following steps: Obtain a node ID Fetch configuration data Allocate ports to be used for inter-node communications Allocate memory according to settings obtained from the configuration file When a data node or SQL node ...More complete information can be found in NDB Cluster Start Phases, in the NDB Internals ... This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 4.5.4, “mysqldump — A Database Backup Program”). This strategy ...The following instructions describe how to do this for a source server and for a replica ...You should not attempt to use these instructions to make a binary backup by copying files ...
https://dev.mysql.com/doc/refman/5.7/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code. For a ...CONDITION statement declares a named error condition, associating a name with a condition that needs specific ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-transactions.html
INNODB_LOCKS: Each transaction in InnoDB that is waiting for another transaction to release a lock (INNODB_TRX.TRX_STATE is LOCK WAIT) is blocked by exactly one blocking lock request. That blocking lock request is for a row or table lock held by ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-linux-quick.html
Note Installation packages for MySQL Shell are available only for a limited number of Linux distributions, and only for 64-bit systems. For supported Linux distributions, the easiest way to install MySQL Shell on Linux is to use the MySQL APT ...If ...
https://dev.mysql.com/doc/refman/5.7/en/nested-loop-joins.html
For example, if 10 rows are read into a buffer and the buffer is passed to the next inner loop, each row read in the inner loop can be compared against all 10 rows in the buffer. A join buffer is never allocated for the first nonconstant table, even ... MySQL executes joins between tables using a nested-loop algorithm or variations on ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT Statements”. For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if ...Use the following procedure: Execute a FLUSH TABLES statement or a mysqladmin flush-tables ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-instances-table.html
Information available in this table provides a real-time snapshot of the active connections to the server. (Additional information is available in socket summary tables, including network activity such as socket operations and number of bytes ...