PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...Stop the server to ensure that no activity occurs in the new database while it is being ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...For ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-concurrent-ddl.html
Prior to MySQL 8.0.27, DDL operations on the donor and recipient MySQL Server instances, including TRUNCATE TABLE, are not permitted during a cloning operation. DDL operations that are not permitted during a cloning operation regardless of the ...A ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-stop.html
On the recipient MySQL server instance, you can retrieve the processlist identifier (PID) for a cloning operation from the PID column of the clone_status table. If necessary, you can stop a cloning operation with a KILL QUERY processlist_id ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
For source/replica replication connections, the configured compression algorithms and compression level are available from multiple sources: The Performance Schema replication_connection_configuration table has COMPRESSION_ALGORITHMS and ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin.html
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS implements an INFORMATION_SCHEMA table that exposes more detailed monitoring information for failed connection attempts. For more information about this table, see Section 28.6.2, “The INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/constraints.html
MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot ...Because of this, constraint handling is a bit different in MySQL than in other ...
https://dev.mysql.com/doc/refman/8.0/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/debugging-server.html
This command also provides some useful information even if you have not compiled MySQL for debugging! If the problem is that some tables are getting slower and slower you should try to optimize the table with OPTIMIZE TABLE or myisamchk. If you are ...
https://dev.mysql.com/doc/refman/8.0/en/differences-from-ansi.html
For example, in MySQL, privileges for a table are not automatically revoked when you delete a table. You must explicitly issue a REVOKE statement to revoke privileges for a table. We try to make MySQL Server follow the ANSI SQL standard and the ...