Category: MySql

  • Queries to see rapidly what your MySql is doing NOW

    Queries to see rapidly what your MySql is doing NOW

    Those queries are useful to admin MySQL instances using mysql client. 1) Check active processes/connections running mysql> show processlist; the previous statement doesn’t show all queries text running. To see the complete statements running use: mysql> show processlist; –or– mysql> show full processlist G; the running queries statements could bee quite long. Use the “G”…