Search Results
https://dev.mysql.com/doc/refman/9.7/en/diagnostics-area.html
Diagnostics Area Structure Diagnostics Area Information Items How the Diagnostics Area is Cleared and Populated How the Diagnostics Area Stack Works Diagnostics Area-Related System Variables Diagnostics Area Structure The diagnostics area contains ...For the RETURNED_SQLSTATE, MESSAGE_TEXT, and MYSQL_ERRNO values for particular errors, see Server Error Message ...
https://dev.mysql.com/doc/refman/9.7/en/table-size-limit.html
You are using the MEMORY (HEAP) storage engine; in this case you need to increase the value of the max_heap_table_size system variable. The effective maximum table size for MySQL databases is usually determined by operating system constraints on ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
row *************************** EVENT_NAME: e EVENT_SCHEMA: d EVENT_DEFINITION: INSERT INTO d.t VALUES ROW(NULL, NOW(), FLOOR(RAND()*100)) EVENT_TYPE: RECURRING 1 row in set (0.00 sec) If an event's definer has privileges sufficient to set global ...
https://dev.mysql.com/doc/refman/9.7/en/cache-index.html
For example: SET GLOBAL keycache1.key_buffer_size=128*1024; Key cache parameters are accessed as members of a structured system variable. The key cache referred to in a CACHE INDEX statement can be created by setting its size with a parameter ...| ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-functions-general-purpose.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). MySQL Server supports a keyring service that enables internal components and plugins to store ...The keyring functions are contained in a plugin library file, which also contains a keyring_udf plugin that must be enabled prior to function ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-params-api.html
For information about MySQL server system variables relating to NDB Cluster, see Section 25.4.3.9.2, “NDB Cluster System Variables”. For a discussion of MySQL server options for NDB Cluster, see Section 25.4.3.9.1, “MySQL Server Options for ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-gtid-repair.html
The server instances in the new InnoDB Cluster will receive the correct transaction set as part of the setup process. AdminAPI's clusterSet.status() command warns you if an InnoDB Cluster's GTID set is inconsistent with the GTID set on the primary ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
These types are supported as in the MySQL server with the following exceptions: String argument and return types can use the utf8mb4 or binary character sets; use of other character sets for these raises an error. This restriction applies to ...
https://dev.mysql.com/doc/refman/9.7/en/assigning-passwords.html
If the read_only system variable is enabled, use of account-modification statements such as CREATE USER or ALTER USER additionally requires the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). Required credentials for clients that ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-sql-command.html
Again, this is straightforward, as a MySqlDataReader object is not required to store results, a variable is used instead. When a connection has been established with the MySQL database, the next step enables you to perform database operations. This ...