Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python.html
This quick-start guide provides instructions to begin prototyping document store applications interactively with MySQL Shell. The guide includes the following topics: Introduction to MySQL functionality, MySQL Shell, and the world_x example schema.
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-stored-programs.html
The other options are disabled by default and must be specified explicitly to dump the corresponding objects. To disable any of these options explicitly, use its skip form: --skip-events, --skip-routines, or --skip-triggers.
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
(This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data --routines --events > dump-defs.sql On the upgraded server: $> mysql < dump-defs.sql Because the dump file does not contain table data, it ... When contemplating a MySQL upgrade, it is prudent to install the newer version separately from your current production ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. MySQL includes a mysql_native_password plugin that implements native authentication; that is, authentication based on the password hashing method in use from before the ...
https://dev.mysql.com/doc/refman/8.4/en/obtaining-component-information.html
The mysql.component system table contains information about currently loaded components and shows which components have been registered using INSTALL COMPONENT. For example: mysql> SELECT * FROM mysql.component; ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-benchmarking.html
With simple tests, you usually test how changing one aspect (a configuration setting, the set of indexes on a table, the SQL clauses in a query) affects performance. The most important feature to try with each workload is the adaptive hash index for ... To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Access to this table should never be granted to any nonadministrative accounts. The validate_password plugin can be used to enforce a policy on acceptable password. Database ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrumentation-checking.html
It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. As described earlier, it is possible to find out by querying the setup_instruments table. Changes to this code occur often, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-model.html
The buffers are global to the server, so the instruments are displayed only in the memory_summary_global_by_event_name table, and not in other memory_summary_by_xxx_by_event_name tables. Memory used depends on the load actually seen, not the load ...