PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
The second INSERT succeeds because the references to the table use different names. For example, if you attempt a second ALTER TABLE operation, the result may be an error Table 'tbl_name' was not locked with LOCK TABLES. To handle this, lock the ...
https://dev.mysql.com/doc/refman/8.0/en/locking-functions.html
For example, suppose that you execute these statements: SELECT GET_LOCK('lock1',10); SELECT GET_LOCK('lock2',10); SELECT RELEASE_LOCK('lock2'); SELECT RELEASE_LOCK('lock1'); The second GET_LOCK() acquires a second lock and both RELEASE_LOCK() calls ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
The type attributes for the return value are also copied from the first argument, except in the case of DECIMAL, when the second argument is a constant value. If the second argument is negative, the return type is adjusted such that its scale is 0, ...ABS(X) Returns the absolute value of X, or NULL if X is ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-unix-servers.html
One way to do so is by using command-line options: $> mysqld_safe --socket=file_name --port=port_number To start a second server, provide different --socket and --port option values, and pass a --datadir=dir_name option to mysqld_safe so that the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-binary.html
Create another text file containing the same information and save it on as C:mysql\my.ini on the other data node host, or copy the my.ini file from the first data node host to the second one, making sure to place the copy in the second data node's ...You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
LCPFragmentCompleted Checkpoint 11 INFO Node node_id: ACC Blocked num_1 and TUP Blocked num_2 times last second Undo logging is blocked because the log buffer is close to overflowing. The following table lists the most common NDB cluster log ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-wait-connected: Time (in seconds) for MySQL server to wait for connection to cluster management and data nodes before accepting MySQL client connections. ndb-wait-setup: Time (in seconds) for MySQL server to wait for NDB engine setup to complete. Ndb_api_wait_nanos_count: Total time (in nanoseconds) spent waiting for some type of signal from data nodes by this MySQL Server (SQL ... The following list includes ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.html
--connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum Value 5 Number of seconds to wait between attempts to contact management server. ndb_index_stat provides per-fragment statistical ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgm.html
--connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum Value 5 Number of seconds to wait between attempts to contact management server. --try-reconnect=number Command-Line Format ...