PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-other-options.html
myisamchk supports the following options for actions other than table checks and repairs: --analyze, -a Command-Line Format --analyze Analyze the distribution of key values. This improves join performance by enabling the join optimizer to better ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-first-start.html
Each cluster node process must be started separately, and on the host where it resides. If all has gone well, and the cluster has been set up correctly, the cluster should now be operational. Note The IP address shown for a given NDB Cluster SQL or ... Starting the cluster is not very difficult after it has been ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-disk-data.html
Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: 216 (65536) The minimum and maximum possible sizes of extents for tablespace data ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-runtime-configuration.html
If there are Performance Schema configuration changes that must be made at runtime using SQL statements and you would like these changes to take effect each time the server starts, put the statements in a file and start the server with the init_file ... Specific Performance Schema features can be enabled at runtime to control which types of event collection ...
https://dev.mysql.com/doc/refman/8.0/en/session-state-tracking.html
The tracker mechanism provides a means for MySQL connectors and client applications to determine whether any session context is available to permit session migration from one server to another. Examples of when transactions might reasonably be ...A ...
https://dev.mysql.com/doc/refman/8.0/en/starting-server.html
(For Windows, see Section 2.3.4.5, “Starting the Server for the First Time”.) For some suggested commands that you can use to test whether the server is accessible and working properly, see Section 2.9.3, “Testing the Server”. This section ...Start the server like this if your installation includes systemd support: $> systemctl start mysqld Substitute the appropriate service name if it differs from mysqld (for example, mysql on SLES ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
Clients can prevent installation of SIGPIPE handlers by specifying the CLIENT_IGNORE_SIGPIPE option to mysql_real_connect() at connect time. On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
For more complete information, see Section 12.10, “Supported Character Sets and Collations”. For example, the default collations for utf8mb4 and latin1 are utf8mb4_0900_ai_ci and latin1_swedish_ci, respectively. The INFORMATION_SCHEMA ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
MySQL supports an IGNORE keyword for INSERT, UPDATE, and so forth. See the section for the statement that you are using (Section 15.2.7, “INSERT Statement”, Section 15.2.17, “UPDATE Statement”, and so forth). Normally, errors occur for ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
It is permitted to insert, select, and update geometrically invalid geometries, but they must be syntactically well-formed. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial ...Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...