Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
One technique MySQL uses is to maintain some system information in the B-tree node in uncompressed form, thus facilitating certain in-place updates. To avoid frequent compression failures in write-intensive workloads, such as for OLTP applications, ...These properties make this compression technique unsuitable for use in an update-intensive database ...
https://dev.mysql.com/doc/refman/8.4/en/install-component.html
For subsequent server restarts, any components listed in mysql.component are loaded by the loader service during the startup sequence. A component provides services that are available to the server and other components; see Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...In order of occurrence, cloning operation stage events include: stage/innodb/clone (file copy): Indicates progress of the file copy phase of the cloning ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...The ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
You can precede the SELECT by IGNORE or REPLACE to indicate how to handle rows that duplicate unique key values. If you want to have indexes in the created table, you should specify these before the SELECT statement: mysql> CREATE TABLE bar (UNIQUE ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
When the Performance Schema instruments a request (server command or SQL statement), it uses instrument names that proceed in stages from more general (or “abstract”) to more specific until it arrives at a final instrument name. Statement ...
https://dev.mysql.com/doc/refman/8.4/en/compatibility.html
MySQL Server has many extensions to the SQL standard, and here you can find out what they are and how to use them. You can also find information about functionality missing from MySQL Server, and how to work around some of the differences. We are ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G *************************** 1. For example, thread/sql/one_connection ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
If there are suppressed queries when the window ends, the server logs a summary that indicates how many there were and the aggregate time spent in them. The slow query log consists of SQL statements that take more than long_query_time seconds to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
The MySQL server is capable of maintaining statement digest information. Digesting occurs in the parser regardless of whether the Performance Schema is available, so that other features such as MySQL Enterprise Firewall and query rewrite plugins ...