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-tp-thread-group-state-table.html
This means that they are not started until there is a need to wake a new thread and there is no consumer thread. Often a thread group needs additional threads for a short while and then does not need them again for a while. In this case, they go ...
https://dev.mysql.com/doc/refman/8.0/en/replica-sql-thread-states.html
Slave has read all relay log; waiting for more updates From MySQL 8.0.26: Replica has read all relay log; waiting for more updates The thread has processed all events in the relay log files, and is now waiting for the I/O (receiver) thread to write ...In MySQL 8.0.26, incompatible changes were made to instrumentation names, including the names of thread stages, containing the terms “master”, which is changed to “source”, “slave”, which is changed to “replica”, and “mts” (for “multithreaded slave”), which is changed to “mta” (for “multithreaded ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source.html
Multi-source replication does not implement any conflict detection or resolution when applying transactions, and those tasks are left to the application if required. Channel specific replication filters can be used when the same database or table is ... MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in ...
https://dev.mysql.com/doc/refman/8.0/en/reset-persist.html
For more information about persisting system variables and the mysqld-auto.cnf file, see Section 7.1.9.3, “Persisted System Variables”. Prior to MySQL 8.0.32, this statement did not work with variables whose name contained a dot character (.), ... RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data ...
https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. These two statements are equivalent: SHOW COLUMNS FROM mytable FROM mydb; SHOW COLUMNS FROM mydb.mytable; The optional EXTENDED ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
See Section 10.4.7, “Limits on Table Column Count and Row Size”. Trailing spaces are automatically deleted from ENUM and SET member values when the table is created. If strict SQL mode is not enabled, a VARCHAR column with a length specification ... In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/static-format.html
Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to corruption). In this case, myisamchk can easily determine where each row starts and ends, so it can usually reclaim all rows except the partially ...
https://dev.mysql.com/doc/refman/8.0/en/structured-system-variables.html
The following example starts the server with three different key caches having sizes in a 3:1:1 ratio: $> mysqld --key_buffer_size=6M \ --hot_cache.key_buffer_size=2M \ --cold_cache.key_buffer_size=2M Structured variable values may be set and ... A ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-usage.html
For additional information about the differences between non-x$ and x$ views, see Section 30.4.3, “sys Schema Views”. For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-get-config.html
If sys_get_config() returns the default value and that value is NULL, it is expected that the caller is able to handle NULL for the given configuration option. By convention, routines that call sys_get_config() first check whether the corresponding ... Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the ...