Search Results
https://dev.mysql.com/doc/refman/9.7/en/identifier-case-sensitivity.html
To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names. Value Meaning 0 Table and database names are stored on disk using the ...
https://dev.mysql.com/doc/refman/9.7/en/memory-use.html
The server caches information in memory as a result of GRANT, CREATE USER, CREATE SERVER, and INSTALL PLUGIN statements. For MEMORY tables explicitly created with CREATE TABLE, only the max_heap_table_size system variable determines how large a ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
This currently has the following formats: Base table: DbName/def/TblName BLOB table: DbName/def/NDB$BLOB_BaseTblId_ColNo Ordered index: sys/def/BaseTblId/IndexName Unique index: sys/def/BaseTblId/IndexName$unique The $unique suffix shown for unique ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-statistics.html
The table is persistent so that column statistics need not be created each time the server starts. The column_statistics table is not directly accessible by users because it is part of the data dictionary. sampling-rate: A number between 0.0 and 1.0 ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-status-variables.html
option_tracker_usage-MySQL_Shell Number of times a MySQL Shell user session was created. option_tracker_usage-MySQL_Shell_for_VS_Code Number of times a MySQL Shell for VS Code user session was created. option_tracker_usage:JavaScript Library Number ... The Option Tracker component supplies a number of status variables, which are described in this ...
https://dev.mysql.com/doc/refman/9.7/en/replication-howto.html
Optionally, create a separate user for your replicas to use during authentication with the source when reading the binary log for replication. Before creating a data snapshot or starting the replication process, on the source you should record the ... This section describes how to set up a MySQL server to use binary log file position based ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-model-import.html
To learn how to use ML_MODEL_IMPORT to share models, see Grant Other Users Access to a Model. Syntax Examples An example that exports a model to a table, switches users, and then imports the model from that table. Use the ML_MODEL_IMPORT routine to ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-server-management-wizard.html
The wizard provides a MySQL connection form to create a new MySQL connection, and includes a Configure Server Management option as a step-by-step approach to creating a new MySQL server connection. For a tutorial that demonstrates the following ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html
The first thing you need to do is create a suitable app.config file for your application. mysql Information: 1 : 1: Connection Opened: connection string = 'server=localhost;User Id=root;database=world;port=3306 ;password=******;logging=True' mysql ... This section describes how to set up your application to view MySQL trace ...
https://dev.mysql.com/doc/heatwave/en/hw-automl-privileges.html
mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, DELETE, UPDATE ON database_name.* TO 'user_name'@'%'; Lakehouse and Tracking/Monitoring Privileges You need the following privileges to access external Lakehouse tables that have machine learning ...