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/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/refman/5.7/en/crashing.html
Nevertheless, it may be instructive to try the option as a test.) If mysqld appears to be running but not responding, try mysqladmin -u root processlist. mysqladmin -u root processlist usually is able to make a connection even in these cases, and ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
If mysqld starts to eat up CPU or memory or if it “hangs,” you can use mysqladmin processlist status to find out if someone is executing a query that takes a long time. It may be a good idea to run mysqladmin -i10 processlist status in some ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-lock-waits.html
waiting_pid The processlist ID of the thread that is waiting for the lock. blocking_pid The processlist ID of the thread that is blocking the waiting lock. These views display which sessions are blocked waiting on metadata locks, and what is ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
The best reports are those that include a full example showing how to reproduce the bug or problem. If a database table is related to the problem, include the output from the SHOW CREATE TABLE db_name.tbl_name statement in the bug report. You should ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for ...By ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
show_create_table_verbosity: Whether to display ROW_FORMAT in SHOW CREATE TABLE even if it has default value. Slave_last_heartbeat: Shows when latest heartbeat signal was received, in TIMESTAMP format. Options and Variables Introduced in MySQL 5.7 ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
PROCESS Enable the user to see all processes with SHOW PROCESSLIST. For example: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON db1.* TO 'jeffrey'@'localhost'; GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost'; ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
Creating Accounts and Granting Privileges The following examples show how to use the mysql client program to set up new accounts. These privileges enable the admin user to execute the mysqladmin reload, mysqladmin refresh, and mysqladmin flush-xxx ... To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove ...