DB Wiki

User Tools

Site Tools

Trace: • postgresqlfunctions • mysqlcommands
mysqlcommands

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
mysqlcommands [2019/02/11 10:49] – [Passwords and User Accounts] z0hpvkmysqlcommands [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 21: Line 21:
 show status like '%Connections%'; show status like '%Connections%';
 show variables like '%bin%'; show variables like '%bin%';
 +
 +show engine innodb status\G
 +show processlist; <OR> SELECT * FROM information_schema.processlist ORDER BY id;
 +show open tables;
 +status;
 +
 +set persist max_connection = 1000; (Like ALTER SYSTEM scope=BOTH)
 +set persist_only max_connection = 1000; (Like ALTER SYSTEM scope=SPFILE)
 +set global slow_query_log = ON; (Like ALTER SYSTEM scope=MEMORY)
 +set session sql_mode = 'TRADITIONAL'; (Like ALTER SESSION)
 </code> </code>
  
mysqlcommands.1549882178.txt.gz · Last modified: 2025/03/08 22:23 (external edit)