https://dev.mysql.com/mysql-innodb-cluster-production-deployment.html
When working in a production environment, the MySQL server instances which make up an InnoDB cluster run on multiple host machines as part of a network rather than on single machine as described in Section 21.2.6, “Sandbox Deployment of InnoDB ...
https://dev.mysql.com/mysql-more-results.html
mysql_more_results() true if more results exist from the currently executed statement, in which case the application must call mysql_next_result() to fetch the results. bool mysql_more_results(MYSQL *mysql) This function is used when you execute ...
https://dev.mysql.com/mysql-shell-tutorial-javascript-indexes-create.html
In the following example, "Text(40)" represents the number of characters to index and true indicates that the field cannot contain any NULL values. field("Name", "TEXT(40)", true).execute() Query OK (0.04 sec) To drop an index, pass to the ...
https://dev.mysql.com/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. When the optimizer evaluates plans ...
https://dev.mysql.com/partitioning-selection.html
p5) VALUES -> (24, 'Tim', 'Greene', 3, 1), (26, 'Linda', 'Mills', 2, 1); Query OK, 2 rows affected (0.06 sec) Records: 2 Duplicates: 0 Warnings: 0 The preceding is true for both INSERT statements and REPLACE statements that write multiple rows.
https://dev.mysql.com/password-management.html
(This means that in the examples just shown, the statements that explicitly name the account for jeffrey fail unless the current user is jeffrey.) This is true even if the change is attempted for another user by a privileged user; however, such a ...
https://dev.mysql.com/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use ...
https://dev.mysql.com/performance-schema-statement-digests.html
The MySQL server is capable of maintaining statement digest information. The digesting process converts each SQL statement to normalized form (the statement digest) and computes a SHA-256 hash value (the digest hash value) from the normalized ...
https://dev.mysql.com/performance-schema-thread-filtering.html
For the Performance Schema to monitor a thread, these things must be true: The thread_instrumentation consumer in the setup_consumers table must be YES. This includes wait, stage, statement, and transaction events and affects logging to these ...
https://dev.mysql.com/plugin-data-structures.html
The same is not true for a library that contains server plugins. (0 = false, 1 = true) MYSQL_THDVAR_BOOL(name, opt, comment, check, update, default) MYSQL_SYSVAR_BOOL(name, varname, opt, comment, check, update, default) String system variables of ...
