PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-server-locks.html
The tableid is assigned to the table by NDB; the same ID is used for this table in other ndbinfo tables, as well as in the output of ndb_show_tables. The transaction ID shown in the transid column is the identifier generated by the NDB API for the ... 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 the SQL node (MySQL server) where it ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
Important The password that you set using START SLAVE is masked when it is written to MySQL Server’s logs, Performance Schema tables, and SHOW PROCESSLIST statements. You must check the replica's error log for error messages generated by the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
Instead, use mysql_query() to execute a KILL, SHOW COLUMNS, SHOW PROCESSLIST, or FLUSH statement, respectively. This also affects the operation of the SHOW VARIABLES and SHOW STATUS statements. The value of the show_compatibility_56 system variable ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
Notes The mysql_connection_id value is the same as the connection or session ID shown in the output of SHOW PROCESSLIST. It is implemented as an INFORMATION_SCHEMA plugin; you can verify that it is supported by checking the output of SHOW PLUGINS.
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
MySQL 5.7 Keywords and Reserved Words MySQL 5.7 New Keywords and Reserved Words MySQL 5.7 Removed Keywords and Reserved Words MySQL 5.7 Keywords and Reserved Words The following list shows the keywords and reserved words in MySQL 5.7, along with ...
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
Use SHOW PROCESSLIST, find the I/O and SQL threads and check their State column to see what they display. If you cannot tell from the error log what the problem was, try the following techniques: Verify that the source has binary logging enabled by ... If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
This thread is not listed in the output of SHOW PROCESSLIST, but it can be viewed as a row in the threads table, as shown here: mysql> SELECT * FROM performance_schema.threads WHERE NAME LIKE '%gtid%'\G *************************** 1. A GTID is ... A ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads.html
This thread can be identified in the output of SHOW PROCESSLIST on the source as the Binlog Dump thread. The state of this thread is shown as Slave_IO_running in the output of SHOW SLAVE STATUS. MySQL replication capabilities are implemented using ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
Because of this, SHOW PROCESSLIST displays Rolling back in the State column for the session, not only for explicit rollbacks performed with the ROLLBACK statement but also for implicit rollbacks. SET autocommit disables or enables the default ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
To obtain details about the thread, join this column with the ID column of the INFORMATION_SCHEMA PROCESSLIST table, but see Section 14.16.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”. Use the ... The ...