PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
However, a user that requires an SSL connection must have been created before the server joining the group connects to the donor. new_member> SET GLOBAL group_replication_recovery_use_ssl=1; new_member> SET GLOBAL group_replication_recovery_ssl_ca= ...Configuring SSL for Group Replication Recovery Recovery is performed through a regular asynchronous replication ...
https://dev.mysql.com/doc/refman/5.7/en/invoking-programs.html
For example, the mysql program interprets the first nonoption argument as a database name, so the command mysql --user=root test indicates that you want to use the test database. The most frequently used of these are the --host (or -h), --user (or ...$> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin with a single or double dash (-, --) specify program ... To invoke a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
In the example, the trigger body is a simple SET that accumulates into a user variable the values inserted into the amount column. In a BEFORE trigger, you can also change its value with SET NEW.col_name = value if you have the UPDATE privilege for ...Here is a simple example that associates a trigger with a table, to activate for INSERT ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-nodes-groups.html
(You should be aware that the number of LDM threads increases with the value of this parameter, but not in a strictly linear fashion, and that there are additional constraints on setting it; see the description of MaxNoOfExecutionThreads for more ...
https://dev.mysql.com/doc/refman/5.7/en/testing-server.html
For example: $> bin/mysqld_safe --user=mysql & If mysqld_safe fails, see Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”. If you have assigned a password for the root account already, you'll also need to specify -p on the ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...This section assumes that ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
if the user ID of the owner of the .frm, .MYD, or .MYI file is different from the user ID of the mysqld process, OPTIMIZE TABLE generates a "cannot change ownership of the file" error unless mysqld is started by the root user. The table and indexes ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
Then the BKA algorithm builds keys to access the table to be joined for all rows in the buffer and submits these keys in a batch to the database engine for index lookups. For BKA to be used, the batched_key_access flag of the optimizer_switch system ...Benefits of BKA include improved join performance due to more efficient table ... In MySQL, a Batched Key Access (BKA) Join ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. Tables that summarize events in similar ways often have similar sets of summary columns and differ only in the grouping columns used to determine how events are ...The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
As a table, updates to the applier metadata repository are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, even in ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...