PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/error-log-format.html
This indicates which part of the server produced the message, and is consistent with general query log and slow query log messages, which include the connection thread ID. The ID included in error log messages is that of the thread within mysqld ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-windows.html
Prior to MySQL 5.7, this is reversed: --log-error takes precedence over --console.) If --log-error is not given, or is given without naming a file, mysqld writes the error log to a file named host_name.err in the data directory, unless the ... On ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't ยป have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/5.7/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create.html
This reduces the network traffic that would otherwise request the entire table from the server for local processing. To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the ...
https://dev.mysql.com/doc/refman/5.7/en/firewall.html
This helps harden MySQL Server against attacks such as SQL injection or attempts to exploit applications by using them outside of their legitimate query workload characteristics. Note MySQL Enterprise Firewall is an extension included in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/floating-point-types.html
MySQL also supports this optional precision specification, but the precision value in FLOAT(p) is used only to determine storage size. The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for single-precision ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-data-definition-statements.html
Note If the group is deployed in single-primary mode, then this is not a problem, because all changes are performed through the same server, the primary. In a Group Replication topology, care needs to be taken when executing data definition ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-data-manipulation-statements.html
This coordination serves two purposes: (i) check whether the transaction should commit or not; (ii) and propagate the changes so that other servers can apply the transaction as well. As there are no primary servers (sources) for any particular data ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
When deploying in single-primary mode, this option must be set to FALSE. Group Replication operates in the following different modes: single-primary mode multi-primary mode The default mode is single-primary. It is not possible to have members of ...