Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-mode-change-online-verify-transactions.html
If you emply a circular replication topology where multiple servers may have write clients, perform the second step for each source-replica connection, until you have completed the full circle. For example, if there are three servers A, B, and C, ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-db-options.html
For example, when using statement-based logging, a server running with only --binlog-do-db=sales does not write to the binary log statements for which the default database differs from sales. When using row-based logging with the same option, the ...
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 ...