MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 1551 to 1560 of 1673 total results

20.7.9 Monitoring Group Replication Memory Usage with Performance Schema Memory Instrumentation

https://dev.mysql.com/doc/refman/8.0/en/mysql-gr-memory-monitoring-ps-instruments.html

From MySQL 8.0.30, Performance Schema provides instrumentation for performance monitoring of Group Replication memory usage. The memory/group_rpl/ Performance Schema instrumentation was updated in 8.0.30 to extend monitoring of Group Replication ...

6.5.1.3 mysql Client Logging

https://dev.mysql.com/doc/refman/8.0/en/mysql-logging.html

Mar 7 12:39:25 myhost MysqlClient[20824]: SYSTEM_USER:'oscar', MYSQL_USER:'my_oscar', CONNECTION_ID:23, DB_SERVER:'127.0.0.1', DB:'--', QUERY:'USE test;' Mar 7 12:39:28 myhost MysqlClient[20824]: SYSTEM_USER:'oscar', MYSQL_USER:'my_oscar', ... The ...

6.6.8 mysql_migrate_keyring — Keyring Key Migration Utility

https://dev.mysql.com/doc/refman/8.0/en/mysql-migrate-keyring.html

The --ssl-fips-mode option differs from other --ssl-xxx options in that it is not used to establish encrypted connections, but rather to affect which cryptographic operations to permit. The mysql_migrate_keyring utility migrates keys between one ...

6.4.2 mysql_secure_installation — Improve MySQL Installation Security

https://dev.mysql.com/doc/refman/8.0/en/mysql-secure-installation.html

The --ssl-fips-mode option differs from other --ssl-xxx options in that it is not used to establish encrypted connections, but rather to affect which cryptographic operations to permit. This program enables you to improve the security of your MySQL ...

22.3.3.1 Create, List, and Drop Collections

https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-collections-operations.html

For example, to drop the flags collection from the current schema, issue: mysql-js> db.dropCollection("flags") The dropCollection() method is also used in MySQL Shell to drop a relational table from a schema. In MySQL Shell, you can create new ...

22.4.3.1 Create, List, and Drop Collections

https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-collections-operations.html

For example, to drop the flags collection from the current schema, issue: mysql-py> db.drop_collection("flags") The drop_collection() method is also used in MySQL Shell to drop a relational table from a schema. In MySQL Shell, you can create new ...

6.4.3 mysql_ssl_rsa_setup — Create SSL/RSA Files

https://dev.mysql.com/doc/refman/8.0/en/mysql-ssl-rsa-setup.html

To make the files available, copy them to a directory that is readable (but not writable) by clients: For local clients, the MySQL installation directory can be used. Instead, consider using MySQL server to generate missing SSL and RSA files ...

6.5.1 mysql — The MySQL Command-Line Client

https://dev.mysql.com/doc/refman/8.0/en/mysql.html

When used interactively, query results are presented in an ASCII-table format. mysql is a simple SQL shell with input line editing capabilities. When used noninteractively (for example, as a filter), the result is presented in tab-separated format.

6.6.9.3 Using mysqlbinlog to Back Up Binary Log Files

https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html

If this causes a conflict with the ID of a replica server or another mysqlbinlog process, use --connection-server-id to specify an alternative server ID. If you use mysqlbinlog --raw to back up the files, the --result-file option produces output ...

7.1 The MySQL Server

https://dev.mysql.com/doc/refman/8.0/en/mysqld-server.html

There are performance and reliability considerations depending on the type of table (transactional or nontransactional) and whether you use replication. The following discussion covers these MySQL server configuration topics: Startup options that ...

Displaying 1551 to 1560 of 1673 total results