Differences

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

--- mysqlcommands [2019/02/15 17:13] – [MySQL Commands] z0hpvk
+++ mysqlcommands [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 22: / Line 22: @@
 show variables like '%bin%';
-set global slow_query_log = ON; (Like ALTER SYSTEM scope=MEMORY)
+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>