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/performance-schema-startup-configuration.html
It is possible that a plugin installed later may create the instrument, at which time the name is recognized and configured. For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON If the server is unable to allocate ... To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to ...
https://dev.mysql.com/doc/refman/8.0/en/charset-examples.html
Example 2: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 ) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci; This time we have a column with a latin1 character set and a default collation. The following ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
There are additional write costs to consider when using a secondary index on a virtual column due to computation performed when materializing virtual column values in secondary index records during INSERT and UPDATE operations. A secondary index ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
Options on the command line take precedence over values specified in option files and environment variables, and values in option files take precedence over values in environment variables. MYSQL_HOST The default host name used by the mysql ... This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication.html
Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There is a built-in group membership service that keeps the view of the group consistent and available for all servers at ... This chapter explains MySQL Group Replication and how to install, configure and monitor ...MySQL Group ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-in-core-file.html
Large core files can be problematic for a number of reasons including the time it takes to write them, the amount of disk space they consume, and the challenges associated with transferring large files. A core file records the status and memory ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. Using prepared ...For ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html
The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is needed, MySQL refers again to the temporary table. The optimizer may index the table with a hash index to make ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns because the ...Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components-installation.html
As of MySQL 8.0.33, components provide access to MySQL Enterprise Data Masking and De-Identification functionality. Previously, MySQL implemented masking and de-identification capabilities as a plugin library file containing a plugin and several ...