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/password-security-user.html
On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. MySQL clients typically overwrite the command-line password argument with zeros during their ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instance-tables.html
They provide event names and explanatory notes or status information: cond_instances: Condition synchronization object instances file_instances: File instances mutex_instances: Mutex synchronization object instances rwlock_instances: Lock ...Each ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-descriptions.html
Other similar tables contain current events at different levels of the event hierarchy: events_stages_current for stage events, events_statements_current for statement events, and events_transactions_current for transaction events. For example, to ... Tables in the performance_schema database can be grouped as follows: Setup ...
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 ...