PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqld-multi.html
Some notes about mysqld_multi: Most important: Before using mysqld_multi be sure that you understand the meanings of the options that are passed to the mysqld servers and why you would want to have separate mysqld processes. If the servers that you ... mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
--post-query=value Command-Line Format --post-query=value Type String The file or string containing the statement to execute after the tests have completed. --post-system=str Command-Line Format --post-system=str Type String The string to execute ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
Nonetheless, most advanced database management systems have evolved some means of determining the physical location to be used for storing specific pieces of data in terms of the file system, hardware or even both. In addition, an NDB table that ...
https://dev.mysql.com/doc/refman/8.0/en/recovery-from-backups.html
Now, suppose that we have a catastrophic unexpected exit on Wednesday at 8 a.m. To recover, first we restore the last full backup we have (the one from Sunday 1 p.m.). To not lose them, we would have needed to have the MySQL server store its MySQL ...The full backup file is just a set of SQL statements, so restoring it is very easy: $> mysql < backup_sunday_1_PM.sql At this point, the data is restored to its state as of Sunday 1 ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
If you do not have the relay log files, but still have the applier metadata repository, you can check it to determine how far the replication SQL thread has executed in the source's binary log. A replica server creates two replication metadata ...
https://dev.mysql.com/doc/refman/8.0/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. If you have a repeatable test case that demonstrates the bug, please enter it into ...We need to obtain as much information as possible from you to be able to track down the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-recover.html
If the PRIVILEGE_CHECKS_USER account should have been permitted to execute the transaction, but has been misconfigured, grant the missing privileges to the account, use a FLUSH PRIVILEGES statement or execute a mysqladmin flush-privileges or ... If ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
After an unexpected halt of a replica, upon restart the replication SQL thread must recover information about which transactions have been executed already. Important Some factors outside the control of replication can have an impact on the ... In ...
https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
SHOW COLUMNS displays information only for those columns for which you have some privilege. The optional FULL keyword causes the output to include the column collation and comments, as well as the privileges you have for each column. The value is ...
https://dev.mysql.com/doc/refman/8.0/en/system-variable-privileges.html
For some system variables, setting the session value may have effects outside the current session and thus is a restricted operation that can be done only by users who have a special privilege: As of MySQL 8.0.14, the privilege required is ...(For ...