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/partitioning-maintenance.html
Rebuilds the partition; this has the same effect as dropping all records stored in the partition, then reinserting them. A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
If you are using the partitioning scheme shown previously for the employees table, you can simply use ALTER TABLE employees DROP PARTITION p0; to delete all rows relating to employees who stopped working for the firm prior to 1991. A table that is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
SQL Statement Corresponding Server Command PREPARE SQLCOM_PREPARE EXECUTE SQLCOM_EXECUTE DEALLOCATE PREPARE, DROP PREPARE SQLCOM_DEALLOCATE PREPARE Performance Schema prepared statement instrumentation covers both protocols. The Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
The row for an object is removed when the object is dropped. The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary tables. Section 29.12.6, “Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
During the extraction process, conditions that cannot be used for constructing the range condition are dropped, conditions that produce overlapping ranges are combined, and conditions that produce empty ranges are removed. The range access method ...
https://dev.mysql.com/doc/refman/8.0/en/replica-sql-thread-states.html
The Coordinator resumes scheduling when the size drops below this limit. The following list shows the most common states you may see in the State column for a replication SQL thread on a replica server. In MySQL 8.0.26, incompatible changes were ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
The safe way to restart a replica that is replicating MEMORY tables is to first drop or delete all rows from the MEMORY tables on the source and wait until those changes have replicated to the replica. When a replication source server shuts down ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-partitioning.html
DROP PARTITION) that act directly on partitions in such cases might produce different results on the source and the replica. Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
Administrative statements include ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and REPAIR TABLE. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require ...