Search Results
https://dev.mysql.com/doc/workbench/en/wb-preferences-general-editors.html
If the value of SqlMode is not set, the default value of the SQL_MODE session variable defined by the server stays unchanged during operations with the server. If you choose to not set the SqlMode property, ensure that the default SQL_MODE variable ...The property has the following functions: Sets the SQL_MODE DBMS session variable to the value stored in the SqlMode property of the document when performing reverse engineering, forward engineering, or synchronization ...
https://dev.mysql.com/doc/refman/9.7/en/declare-handler.html
For a list of MySQL error codes, see Server Error Message Reference. For a list of SQLSTATE values, see Server Error Message Reference. DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN -- body of handler END; For information about how the server ...
https://dev.mysql.com/doc/refman/9.7/en/set-statement.html
Descriptions for those forms that are not associated with a specific server capability appear in subsections of this section: SET var_name = value enables you to assign values to variables that affect the operation of the server or clients. SET ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-responses-failure-expel.html
You can use the group_replication_member_expel_timeout system variable to allow additional time between the creation of a suspicion and the expulsion of the suspect member. You can adjust the cache size limit using the ...A suspicion is created ...
https://dev.mysql.com/doc/refman/9.7/en/identifiers.html
mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. The server SQL mode is controlled as described in ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-accounts-table.html
To set the table size explicitly, set the performance_schema_accounts_size system variable at server startup. The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-hosts-table.html
To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-ndb-cluster-tables.html
This is done by default in the background at regular intervals as determined by the ndb_metadata_check_interval system variable, unless disabled using ndb_metadata_check or overridden by setting ndb_metadata_sync. Historically, information about the ...Automatic synchronization in NDB attempts to detect and synchronize automatically all mismatches in metadata between the NDB Cluster's internal dictionary and the MySQL Server's ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-users-table.html
To set the table size explicitly, set the performance_schema_users_size system variable at server startup. The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and ...