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/server-plugins.html
MySQL Enterprise Edition includes a thread pool plugin that manages connection threads to increase server performance by efficiently managing statement execution threads for large numbers of client connections. MySQL supports an plugin API that ...
https://dev.mysql.com/doc/refman/8.0/en/sys-diagnostics.html
Be careful with the medium setting and especially the full setting, which has a large performance impact. Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...
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/select-into.html
INTO DUMPFILE writes a single row to a file without any formatting. If the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. If the query returns multiple rows, error 1172 occurs ...
https://dev.mysql.com/doc/refman/8.0/en/static-format.html
The expected row length in bytes for static-sized rows is calculated using the following expression: row length = 1 + (sum of column lengths) + (number of NULL columns + delete_flag + 7)/8 + (number of variable-length columns) delete_flag is 1 for ...It is also the fastest of the on-disk formats due to the ease with which rows in the data file can be found on disk: To look up a row based on a row number in the index, multiply the row number by the row length to calculate the row ...
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/mysql-cluster-programs-ndb-print-backup-file.html
This option is enabled by default; to disable it, use --no-print-rows. --rowid-file Command-Line Format --rowid-file=path Type File name Default Value [none] File to check for row ID. This can be any of the files (.Data, .ctl, or .log file) found in ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
However, prior to MySQL 8.0.21, when row-based replication is in use, a CREATE TABLE ... SELECT is now recorded and applied as one transaction when row-based replication is in use. You can precede the SELECT by IGNORE or REPLACE to indicate how to ... 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 ...