Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-examples.html
This result is the same whatever the binary logging format is on the replication source server. If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions.html
For tips on improving your replication performance, including using a single secondary server as the source, see Section 19.4.7, “Improving Replication Performance”. For information on security measures specific to servers in a replication ...
https://dev.mysql.com/doc/refman/9.7/en/serialized-dictionary-information.html
SDI data is not updated when the MySQL server is upgraded to a new release or version. The MySQL server uses an internal API that is accessed during DDL operations to create and maintain SDI records. In addition to storing metadata about database ...
https://dev.mysql.com/doc/refman/9.7/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/9.7/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. If the server was started with the --skip-show-database option, you cannot use this statement at all unless you have the SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/solaris-installation-pkg.html
You must have root privileges to perform this operation: $> pkgadd -d mysql-9.7.0-solaris11-x86_64.pkg The following packages are available: 1 mysql MySQL Community Server (GPL) (i86pc) 9.7.0 Select package(s) you wish to process (or 'all' to ...
https://dev.mysql.com/doc/refman/9.7/en/sys-memory-global-total.html
The memory_global_total and x$memory_global_total views have these columns: total_allocated The total bytes of memory allocated within the server.
https://dev.mysql.com/doc/refman/9.7/en/thread-pool-information-schema-tables.html
Thus, the MySQL server holds the mutex of the thread group while producing the snapshot. But it does not hold mutexes on all thread groups at the same time, to prevent a statement against TP_THREAD_STATE from blocking the entire MySQL server. Note ...
https://dev.mysql.com/doc/refman/9.7/en/windows-extract-archive.html
To install MySQL manually, do the following: If you are upgrading from a previous version then refer to Section 3.11, “Upgrading MySQL on Windows” before beginning the upgrade process. Make sure that you are logged in as a user with ...
https://dev.mysql.com/doc/refman/9.7/en/x-plugin-disabling.html
The X Plugin can be disabled at startup by either setting mysqlx=0 in your MySQL configuration file, or by passing in either --mysqlx=0 or --skip-mysqlx when starting the MySQL server. Alternatively, use the -DWITH_MYSQLX=OFF CMake option to ...