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/x-plugin-connection-compression.html
The benefits of compression therefore occur primarily when there is low network bandwidth, network transfer time dominates the cost of compression and decompression operations, and result sets are large. From MySQL 8.0.19, X Plugin supports ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
With the mysql_info() C API function, you can find out how many rows were copied by ALTER TABLE. To change the InnoDB table to use compressed row-storage format: ALTER TABLE t1 ROW_FORMAT = COMPRESSED; The ENCRYPTION clause enables or disables ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
The size and sign of fixed precision types such as INTEGER and DECIMAL must be the same. Referential Actions When an UPDATE or DELETE operation affects a key value in the parent table that has matching rows in the child table, the result depends on ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...For more ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-actors-table.html
This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_actors_size system variable at server startup. For each new foreground thread, the Performance Schema matches the user and host for ... The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
The table implementation uses a fixed-size, in-memory ring buffer, with old events automatically discarded as necessary to make room for new ones. row *************************** LOGGED: 2020-08-06 09:25:00.338624 THREAD_ID: 0 PRIO: System ... Of ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
The optimizer now is more complex and bases its estimate on additional factors such as table size, number of rows, and I/O block size. MySQL quickly detects that some SELECT statements are impossible and returns no rows. For each table in a join, a ... This section discusses optimizations that can be made for processing WHERE ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. See Section 10.4.7, “Limits on Table Column Count and Row Size”. The CHAR and VARCHAR ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_objects_size system variable at server startup. (Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the ...
https://dev.mysql.com/doc/refman/8.0/en/crashing.html
Fixed-size rows take a little extra space, but are much more tolerant to corruption. If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT columns), you can try to change all ...