Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-thread-states.html
Processing events from schema table The thread is doing the work of schema replication. Shutting down Syncing ndb table schema operation and binlog This is used to have a correct binary log of schema operations for NDB. Committing events to binlog ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-gr-memory-monitoring-ps-sample-queries.html
row *************************** EVENT_NAME: memory/group_rpl/write_set_encoded COUNT_ALLOC: 1 COUNT_FREE: 0 SUM_NUMBER_OF_BYTES_ALLOC: 45 SUM_NUMBER_OF_BYTES_FREE: 0 LOW_COUNT_USED: 0 CURRENT_COUNT_USED: 1 HIGH_COUNT_USED: 1 ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-server.html
Copy the script to the /etc/init.d directory with the name mysql and make it executable: cp mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql After installing the script, the commands needed to activate it to run at system startup depend on ... MySQL distributions on Unix and Unix-like system include a script named mysql.server, which starts the MySQL server using ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript.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/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 ...