How can I view live MySQL queries?

by

You can log every query to a log file really easily:

mysql> SHOW VARIABLES LIKE "general_log%";

+------------------+----------------------------+
| Variable_name    | Value                      |
+------------------+----------------------------+
| general_log      | OFF                        |
| general_log_file | /var/run/mysqld/mysqld.log |
+------------------+----------------------------+

mysql> SET GLOBAL general_log = 'ON';

Do your queries (on any db). Grep or otherwise examine /var/run/mysqld/mysqld.log

Then don’t forget to 

mysql> SET GLOBAL general_log = 'OFF';

or the performance will plummet and your disk will fill!

More Related Contents:

  1. How can i write in NodeJS with MongoDB the following MySQL Select?
  2. MySQL treats password in script as database
  3. Which MySQL data type to use for storing boolean values
  4. String concatenation in MySQL
  5. How to check if mysql database exists
  6. Change auto increment starting number?
  7. SELECT * FROM multiple tables. MySQL
  8. How to get the difference between two timestamps in seconds
  9. Storing Data in MySQL as JSON
  10. How to set a maximum execution time for a mysql query?
  11. SQL keys, MUL vs PRI vs UNI
  12. How to copy a row and insert in same table with a autoincrement field in MySQL?
  13. How does a MYSQL Self-Join Work?
  14. How to change the default port of mysql from 3306 to 3360
  15. How to move columns in a MySQL table?
  16. access denied for load data infile in MySQL
  17. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  18. What is the best MySQL collation for German language
  19. quick selection of a random row from a large table in mysql
  20. MySQL error #2014 – Commands out of sync; you can’t run this command now
  21. How can we find gaps in sequential numbering in MySQL?
  22. Optimization of MySQL search using “like” and wildcards
  23. Why do I need “OR NULL” in MySQL when counting rows with a condition
  24. Find date range overlaps within the same table, for specific user MySQL
  25. MySQL on delete cascade. Test Example
  26. How to reuse auto_increment values? [duplicate]
  27. How do I alter a mysql table column defaults?
  28. Calling an url from a trigger in mysql
  29. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  30. How to count date difference excluding weekend and holidays in MySQL

Leave a Comment