Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-shell.html
Replace this with the hostname of the MySQL server instance you are using as a Document Store. For instructions on setting up the world_x schema, see Section 22.4.2, “Download and Import world_x Database”. This quick-start guide assumes a ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-admin.html
Database administrators should use the following guidelines to keep passwords secure. A user who has access to modify the plugin directory (the value of the plugin_dir system variable) or the my.cnf file that specifies the plugin directory location ...MySQL stores passwords for user accounts in the mysql.user system ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
Examples of the ways query attributes may be used: A web application produces pages that generate database queries, and for each query must track the URL of the page that generated it. The most visible part of an SQL statement is the text of the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
uuid: hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh h: [0-9|A-F] tag: [a-z_][a-z0-9_]{0,31} interval: m[-n] (m >= 1; n > m) mysql.gtid_executed Table GTIDs are stored in a table named gtid_executed, in the mysql database. A global transaction identifier ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
Log files contain all statements that made any changes, so they can be used to audit the database. Not all statements which modify data (such as INSERT DELETE, UPDATE, and REPLACE statements) can be replicated using statement-based replication. For ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
(Some database systems, such as Oracle, use MINUS for the name of this operator. Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
mysql schema tables fall into two broad categories: Data dictionary tables, which store database object metadata. If the actual data dictionary version is lower than the current expected version, the server creates data dictionary tables with ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-upgrade-cluster.html
upgrade cluster {--package=|-P }package_name [{--nodeid|-n }node_id_list] [--force|-f] [--retry|-L] [--set=attribute_assignment_list] cluster_name node_id_list: node_id[, node_id[, ...]] attribute_assignment_list: ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.html
The currently bound parameter marker values are sent to server during this call, and the server replaces the markers with this newly supplied data. int mysql_stmt_execute(MYSQL_STMT *stmt) Description mysql_stmt_execute() executes the prepared ...