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-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
Release: Enable optimizations but omit debugging information to reduce the build size. For tarball installs, patching of mysqld with a tool like patchelf is required. By default, this option is disabled and server builds contain no tooling. If ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
To set the maximum core file size, use LimitCore in override.conf rather than the --core-file-size option for mysqld_safe. mysqld_safe options not understood by mysqld can be specified in override.conf or environment variables. If you install MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html
mysqlx_max_allowed_packet Command-Line Format --mysqlx-max-allowed-packet=# System Variable mysqlx_max_allowed_packet Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 67108864 Minimum Value 512 Maximum Value 1073741824 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...For more information about the relationship between the three wait event tables, see Section 29.9, “Performance Schema Tables for Current and Historical ...
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/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: NULL normalized_pattern: NULL The rule specifies a pattern template indicating which SELECT ... To ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-trx-table.html
TRX_WEIGHT The weight of a transaction, reflecting (but not necessarily the exact count of) the number of rows altered and the number of rows locked by the transaction. Transactions that have changed nontransactional tables are considered heavier ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
The size of the list is controlled by the profiling_history_size session variable, which has a default value of 15. The LIMIT row_count clause may be given to limit the output to row_count rows. If LIMIT is given, OFFSET offset may be added to begin ...Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL ...