Search Results
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
In particular, INSERT or UPDATE statements for the mysql.user system table that refer to literal passwords are logged as is, so you should avoid such statements. Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-filtering.html
| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ... The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ... This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
When a new table row is inserted, the statement that produced the row digest value is stored as the current sample statement associated with the digest. The MySQL server is capable of maintaining statement digest information. The digesting process ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
When a new table row is inserted, the statement that produced the row digest value is stored as the current sample statement associated with the digest. The Performance Schema automatically sizes the values of several of its parameters at server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-characteristics.html
Some of the setup tables have columns that can be modified to affect Performance Schema operation; some also permit rows to be inserted or deleted. The name of the performance_schema database is lowercase, as are the names of tables within it. Many ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage-common-layer.html
Performance Aids: This includes multiple I/O threads for parallel operations, thread concurrency, database checkpointing, bulk insert handling, and more. A MySQL pluggable storage engine is the component in the MySQL database server that is ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...