Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
performance_schema_users_size Command-Line Format --performance-schema-users-size=# System Variable performance_schema_users_size Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value -1 (signifies autoscaling; do not assign ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
For example, Oracle Database users are familiar with querying tables in the Oracle data dictionary. INFORMATION_SCHEMA and Privileges For most INFORMATION_SCHEMA tables, each MySQL user has the right to access them, but can see only the rows in the ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
The user-selected rule by which the division of data is accomplished is known as a partitioning function, which in MySQL can be the modulus, simple matching against a set of ranges or value lists, an internal hashing function, or a linear hashing ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-rag.html
To specify the table for retrieving the vector embeddings to use as context, set the @options variable: mysql> SET @options = JSON_OBJECT( "vector_store", JSON_ARRAY("DBName.VectorStoreTableName"), "model_options", JSON_OBJECT("language", ...This ...
https://dev.mysql.com/doc/workbench/en/wbcopytables.html
It uses the same syntax as the MySQL Utilities: For TCP/IP connections: username[:password]@host:port For local socket connections: username[:password]@::socket_path --source-password: Passes the connection password of the data source. Option ...It ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-tarball.html
In the second of these lines, replace the placeholder @@MCMD_USER@@ with the name of the system user that runs the MySQL Cluster Manager agent (note that this must not be the system root account). When the agent is configured as a daemon, cluster ...
https://dev.mysql.com/doc/refman/8.4/en/windows-postinstallation.html
If you configured MySQL using MySQL Configurator, the root user is created automatically with the password you supplied. Before assigning a password, you might want to try running some client programs to make sure that you can connect to the server ... GUI tools exist that perform most of the tasks described in this section, including: MySQL Configurator: Used to configure the MySQL ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-document-ids.html
// using a book's unique ISBN as the object ID myColl.add( { _id: "978-1449374020", title: "MySQL Cookbook: Solutions for Database Developers and Administrators" }).execute(); Use find() to fetch the newly inserted book from the collection by its ...
https://dev.mysql.com/doc/mysql-installer/en/server-type-network.html
You can set the level of access control based on the Windows user (or users) running the client as follows: Minimum access to all users (RECOMMENDED). If the minimum-access option is too restrictive for the client software, use this option to reduce ... Server Configuration Type Choose the MySQL server configuration type that describes your ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
Summaries for finer levels are unavailable, such as per thread, account, user, or host. Instruments with a higher volatility index (for example, SESSION = 5) are created and destroyed for every user session. The setup_instruments table lists ...row ...row *************************** NAME: stage/sql/executing ENABLED: NO TIMED: NO PROPERTIES: FLAGS: NULL VOLATILITY: 0 DOCUMENTATION: NULL ...