Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python.html
X DevAPI User Guide provides more examples of using X DevAPI to develop applications which use MySQL as a Document Store. This quick-start guide provides instructions to begin prototyping document store applications interactively with MySQL Shell.
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-userguide.html
For documentation on the concepts and usage of X DevAPI, which is implemented in MySQL Shell, see X DevAPI User Guide. MySQL Shell is an advanced client and code editor for MySQL Server. In addition to the provided SQL functionality, similar to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql.html
mysql is a simple SQL shell with input line editing capabilities. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as a filter), the result is presented in tab-separated format.
https://dev.mysql.com/doc/refman/8.4/en/not-enough-file-handles.html
There is also a “hard” limit that can be overridden only if you start mysqld_safe or mysqld as root (just remember that you also need to start the server with the --user option in this case so that it does not continue to run as root after it ...
https://dev.mysql.com/doc/refman/8.4/en/operator-precedence.html
Section 15.7.6.1, “SET Syntax for Variable Assignment”, and Section 11.4, “User-Defined Variables”, explain how MySQL determines which interpretation of = should apply. Operator precedences are shown in the following list, from highest ...
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
This enables users to set sort_buffer_size to larger values to speed up larger sorts, without concern for excessive memory use for small sorts. This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation ...
https://dev.mysql.com/doc/refman/8.4/en/password-security.html
The following sections provide guidelines that enable end users and administrators to keep these passwords secure and avoid exposing them. In addition, the validate_password plugin can be used to enforce a policy on acceptable password.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-objects-summary-global-by-type-table.html
row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: mysql OBJECT_NAME: user COUNT_STAR: 14 SUM_TIMER_WAIT: 365567592 MIN_TIMER_WAIT: 1141704 AVG_TIMER_WAIT: 26111769 MAX_TIMER_WAIT: 334783032 ... The Performance Schema maintains the ...