PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-scaleout.html
Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() safe_reader_connect() safe_reader_statement() safe_writer_statement() safe_ in each function name means that the function takes care of ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-switch.html
Web clients that issue only reads (and would normally be connected to the replicas) are not shown, as they do not need to switch to a new server in the event of failure. To use CHANGE REPLICATION SOURCE TO, add all information about how to connect ... You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/9.7/en/replication-threads.html
The source creates a thread to send the binary log contents to a replica when the replica connects. When a START REPLICA statement is issued on a replica server, the replica creates an I/O (receiver) thread, which connects to the source and asks it ... MySQL replication capabilities are implemented using the following types of threads: Binary log dump ...
https://dev.mysql.com/doc/refman/9.7/en/security-plugins.html
MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. (MySQL Enterprise Edition only) MySQL Enterprise Audit, implemented using a server plugin, ...
https://dev.mysql.com/doc/refman/9.7/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/9.7/en/server-side-help-support.html
Change location into that directory and process the file with the mysql client as follows: mysql -u root -p mysql < fill_help_tables.sql The command shown here assumes that you connect to the server using an account such as root that has privileges ... MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP ...
https://dev.mysql.com/doc/refman/9.7/en/set-password.html
The new password becomes the primary password, but clients can use the account to connect to the server using either the primary or secondary password. When the read_only system variable is enabled, SET PASSWORD requires the CONNECTION_ADMIN ... SET ...
https://dev.mysql.com/doc/refman/9.7/en/stop-replica.html
This can be used to avoid deadlocks between STOP REPLICA and other SQL statements using different client connections to the replica. If the current replication event group has modified one or more nontransactional tables, STOP REPLICA waits for up ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-is-thread-instrumented.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID is enabled, UNKNOWN if the ID is unknown, or NULL if the ID is NULL. Example mysql> SELECT sys.ps_is_thread_instrumented(43); ...This is a value of ...
https://dev.mysql.com/doc/refman/9.7/en/table-cache.html
(By contrast, the index file descriptor is shared between all sessions.) The table_open_cache and max_connections system variables affect the maximum number of files the server keeps open. For example, for 200 concurrent running connections, specify ... When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 ...