Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The column_statistics table has these characteristics: The table contains statistics for ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use PAM (Pluggable Authentication Modules) to ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-numbers.html
The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals. Approximate-value data types and numeric literals are handled as floating-point numbers.
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-wiki-format.html
When editing or defining an advisor, you can enter text in Wiki format in the Problem Description, Advice, Recommended Action, and Links and Further Reading text boxes. You can format and highlight text and add hyperlinks, using the notation listed ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
These terms are commonly used in information about the MySQL database server. Files with this extension are always included in backups produced by the mysqlbackup command of the MySQL Enterprise Backup product. Files with this extension are always ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the command line or in an option file. Most of them can be changed dynamically at runtime using the SET ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
Some menu items are not available in the MySQL Workbench Community Edition of this application, and are available only in the MySQL Workbench Commercial Editions. 9.1.1.1.1 The File Menu Use the File menu to open a project, begin a new project, or ...
https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
These three types can be the target (destination), source, or both. You can also select or deselect individual objects and modify their direction during the synchronization. For example, you can synchronize tables from a model to your database, ...
https://dev.mysql.com/doc/workbench/en/wb-default-schema.html
When you first open MySQL Workbench a default schema, mydb appears as the leftmost tab of the Physical Schemas section of MySQL Workbench as the following figure shows. You can begin designing a database by using this default schema. Figure 9.32 ...