Search Results
https://dev.mysql.com/doc/refman/9.7/en/identifier-case-sensitivity.html
The lower_case_table_names system variable also affects how the server handles identifier case sensitivity, as described later in this section. How table and database names are stored on disk and used in MySQL is affected by the ...Consequently, the ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-create-table-external.html
For general information about setting system variables, see Section 7.1.9, “Using System Variables”. Tables are implicitly created in file-per-table tablespaces when the innodb_file_per_table variable is enabled, which it is by default. Known ...
https://dev.mysql.com/doc/internals/en/differences-master-slave.html
The following is the main rule: (P-rpl-correct) If a replication master and slave reside on identical environments (D-identical-environments) and the server states are identical (D-identical-server-states), and @@client.binlog_format!=STATEMENT, ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-optimization.html
Note If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the data dictionary, which use InnoDB. A server restart or the first opening of the mysql.index_stats and ... Applications ...
https://dev.mysql.com/doc/refman/9.7/en/replication-mode-change-online-concepts.html
To change the replication mode online, it is necessary to set the gtid_mode and enforce_gtid_consistency variables using an account that has privileges sufficient to set global system variables; see Section 7.1.9.1, “System Variable Privileges”.
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
Before You Begin Model Handles Overview Query the Model Handle Define Model Handle Assign Session Variable to Model Handle What's Next Before You Begin Review the The Model Catalog. Model Handles Overview If you set the model handle name to a ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-model-handles.html
Before You Begin Model Handles Overview Query the Model Handle Defining Model Handle Assign Session Variable to Model Handle What's Next Before You Begin Review the The Model Catalog. Model Handles Overview If you set the model handle name to a ...
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/ipv6-brokers.html
For more information, see the bind_address description in Section 7.1.8, “Server System Variables”. If you do not have a public IPv6 address that enables your system to communicate over IPv6 outside your local network, you can obtain one from ...The Wikipedia IPv6 Tunnel Broker page lists several brokers and their features, such as whether they provide static addresses and the supported routing ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-information-commands.html
In addition, you can obtain information about mysql client commands that are independent of the MySQL server and thus are also available for use when connected to the MySQL Cluster Manager agent. You can also use most standard mysql client commands ... Online help is available in the MySQL Cluster Manager client for MySQL Cluster Manager client ...