Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-operations.html
(Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) The operation_type column can take any one of the values READ, READ-SH, READ-EX, INSERT, UPDATE, DELETE, WRITE, UNLOCK, REFRESH, SCAN, SCAN-SH, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-events.html
This table provides information about event subscriptions in NDB. The columns of the events table are listed here, with short descriptions of each: event_id The event ID name The name of the event table_id The ID of the table on which the event ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-locks.html
This is always one of the values READ, INSERT, UPDATE, DELETE, SCAN, or REFRESH. The server_locks table is similar in structure to the cluster_locks table, and provides a subset of the information found in the latter table, but which is specific to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-operations.html
(Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) The operation_type column can take any one of the values READ, READ-SH, READ-EX, INSERT, UPDATE, DELETE, WRITE, UNLOCK, REFRESH, SCAN, SCAN-SH, ...
https://dev.mysql.com/doc/refman/8.4/en/no-matching-rows.html
Open the file in an editor, remove some insert lines (if there are more than needed to demonstrate the problem), and add your SELECT statement at the end of the file. If you have a complicated query that uses many tables but that returns no rows, ...
https://dev.mysql.com/doc/refman/8.4/en/optimization-indexes.html
Indexes also add to the cost of inserts, updates, and deletes because each index must be updated. The best way to improve the performance of SELECT operations is to create indexes on one or more of the columns that are tested in the query. The ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
Thus, if you have transactions that update, insert, or delete many rows, making the log buffer larger saves disk I/O. Consider the following guidelines for optimizing redo logging: Increase the size of your redo log files. When InnoDB has written ...
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-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 ...