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/connection-control-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The file name suffix differs per platform (for example, .so for Unix and Unix-like systems, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Since there are typically two fragment replicas, and assuming that this is so, each fragment_num value should appear twice in the table, on two different data nodes from the same node group. Generally, such a refusal is due to duplicate keys ... The ...In addition, a client may choose to end a scan before all potentially matching rows have been examined; this occurs when using an SQL statement containing a LIMIT or EXISTS clause, for ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-connection-compression.html
required: Compression algorithm negotiation occurs as for preferred mode, but if no common algorithm is available, the connection request terminates with an error. As the compression level for an algorithm increases, the data compression ratio ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
SSL certificate and key files are generated in the data directory. A password for the superuser is set and stored in the error log file. Important Repository setup RPM file names begin with mysql-84-lts-community to highlight the default active ...
https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html
The file must be located in the directory named by the plugin_dir system variable. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
You must specify the schema name if the trigger is not in the default schema: mysql> DROP TRIGGER test.ins_sum; If you drop a table, any triggers for the table are also dropped. Trigger names exist in the schema namespace, meaning that all triggers ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-advantages.html
(10 data file descriptors for each of the 10 clients, and 10 index file descriptors shared among the clients.) Index reads are slower. For example, you can put data from different months into separate tables, compress some of them with myisampack, ... MERGE tables can help you solve the following problems: Easily manage a set of log ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-gtids.html
With these options set, the group member does not persist file names and file positions in the replication metadata repositories for these channels. The alternative UUID must be different from the server UUIDs of the members. It must also be ...The ... Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server ...
https://dev.mysql.com/doc/refman/8.0/en/estimating-performance.html
In MySQL, an index block is usually 1,024 bytes and the data pointer is usually four bytes. This index would require storage of about 500,000 * 7 * 3/2 = 5.2MB (assuming a typical index buffer fill ratio of 2/3), so you probably have much of the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. The DATA_TYPE value is the type name only with ...The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column ...