PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-log-status-table.html
The log_status table informs the online backup which point it should copy up to in the source's binary log and gtid_executed record, and the relay log for each replication channel. It also provides relevant information for individual storage ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
The setup_instruments table lists the name of the instrumentation point, with the prefix wait/synch/mutex/. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
For a prepared statement created by a stored program, these columns point to the stored program. The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary protocol. This is accessed ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
At this point, the real statement type is unknown, the type will be refined after SQL parsing. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
After upgrading to MySQL 8.0.29, the format of the mysqld-auto.cnf option file remains the same until the first time a SET PERSIST or SET PERSIST ONLY statement is issued, and at that point it is changed to a new format, even if the system variable ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
However, removing options for a plugin from the my.cnf file may not be sufficient to uninstall it if at some point INSTALL PLUGIN has also been used. Server plugins must be loaded into the server before they can be used. It is also possible to ...
https://dev.mysql.com/doc/refman/8.0/en/privilege-changes.html
The in-memory tables become effective for access control at that point. If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
For example, if you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who ...
https://dev.mysql.com/doc/refman/8.0/en/query-attributes.html
Attributes exist until statement execution ends, at which point the attribute set is cleared. The most visible part of an SQL statement is the text of the statement. As of MySQL 8.0.23, clients can also define query attributes that apply to the ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
An equivalence class may not be used as an endpoint of a range. A character class may not be used as an endpoint of a range. You should keep in mind that positional indexes are based on 16-bit chunks and not on code points. This section discusses ...