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/primary-key-optimization.html
With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column or columns. If your table is big and important, but does not have an obvious column or set of columns to use as ... The primary key for a table represents the column or set of columns that you use in your most vital ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-alias.html
An alias can be used in a query select list to give a column a different name. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. In the select list of a query, a quoted column ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-mysql-sock.html
To do this, set the sticky bit on the /tmp directory by logging in as root and using the following command: $> chmod +t /tmp You can check whether the sticky bit is set by executing ls -ld /tmp. Specify a --socket option on the command line to ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-if-not-exists.html
If the statement includes IF NOT EXISTS, it is considered successful, and is logged as long as at least one user named in the statement is created; in such cases, the statement is logged as written; this includes references to existing users that ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-select.html
This includes the case that the destination table exists and IF NOT EXISTS is not given. If the destination table exists and IF NOT EXISTS is given, MySQL 8.0 ignores the statement completely; nothing is inserted or logged. SELECT always performs an ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-mysqldb.html
However, statements that would normally update this information indirectly—such GRANT, REVOKE, and statements manipulating triggers, stored routines, and views—are replicated to replicas using statement-based replication. Data modification ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slaveinit.html
For a full list of options, and information about the maximum permissible length for the string-valued options, see Section 15.4.2.1, “CHANGE MASTER TO Statement”. To set up the replica to communicate with the source for replication, configure ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-reset-replica.html
RESET REPLICA makes the replica forget its replication position, and clears the relay log, but it does not change any replication connection parameters (such as the source host name) or replication filters. For the full syntax of the RESET REPLICA ... The RESET REPLICA statement can be used to reset a multi-source ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-start-replica.html
Once you have added channels for all of the replication sources, issue a START REPLICA (or before MySQL 8.0.22, START SLAVE) statement to start replication. When you have enabled multiple channels on a replica, you can choose to either start all ...