PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-performance.html
Figure 19.3 Using an Additional Replication Source to Improve Performance For this to work, you must configure the MySQL instances as follows: Source 1 is the primary source where all changes and updates are written to the database. If your replicas ...Also, as each replica must receive a full copy of the source's binary log, the network load on the source may also increase and create a ... As the number ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
This includes variables set within files specified using the init_file system variable. EXPLICIT The variable was set from an option file named with the --defaults-file option. EXTRA The variable was set from an option file named with the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to work without modification even if the table is altered to add a new column that the application ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-summary-tables.html
The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and summary columns that contain the aggregated values. Tables that summarize events in ... Summary tables provide aggregated information for terminated events over ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mysqld.html
If you build MySQL from source, you must invoke CMake with the -DWITH_NDB=1 or (deprecated) -DWITH_NDBCLUSTER=1 option to include support for NDB. Insert a line containing ndbcluster in the [mysqld] section of your my.cnf file. (We often refer to a ...To be used with NDB Cluster, mysqld needs to be built with support for the NDB storage engine, as it is in the precompiled binaries available from ...For more information about compiling NDB Cluster from source, see ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-transporter-details.html
sendbuffer_used_bytes The amount, in bytes, of signal data currently awaiting send by this transporter. sendbuffer_max_used_bytes The maximum amount, in bytes, of signal data awaiting send at any one time by this transporter. This table contains ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. (That is, this width is present in the metadata returned with result sets. In these cases, MySQL ...This optional display width may be used by applications to display integer values having a width less than the width specified for the column by left-padding them with ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-obtaining-parent-events.html
The relation is based on a nested set data model, so the join has several clauses. To find lock information, data_locks is the table containing child events. The data_locks table shows only existing locks, so these considerations apply regarding ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. It is therefore imperative that you back up your data before starting the upgrade process. If your MySQL installation contains a ...The only supported alternative is to restore a backup taken before ...Important Downgrade from MySQL 8.0 to MySQL 5.7, or ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session. If ...