Mysql » Historique » Version 1
Gilles Grandgérard, 25/06/2014 16:13
| 1 | 1 | Gilles Grandgérard | h1. Mysql Active Log SQL |
|---|---|---|---|
| 2 | 1 | Gilles Grandgérard | |
| 3 | 1 | Gilles Grandgérard | <pre> |
| 4 | 1 | Gilles Grandgérard | SUDO -s |
| 5 | 1 | Gilles Grandgérard | mysql --defaults-file=/etc/mysql/debian.cnf |
| 6 | 1 | Gilles Grandgérard | </pre> |
| 7 | 1 | Gilles Grandgérard | |
| 8 | 1 | Gilles Grandgérard | <pre> |
| 9 | 1 | Gilles Grandgérard | SQL:> |
| 10 | 1 | Gilles Grandgérard | SET global log_output = 'FILE'; |
| 11 | 1 | Gilles Grandgérard | SET global general_log_file='mysql_general.log'; |
| 12 | 1 | Gilles Grandgérard | SET global general_log = 1; #active |
| 13 | 1 | Gilles Grandgérard | SET global general_log = 0; #deactive |
| 14 | 1 | Gilles Grandgérard | EXIT |
| 15 | 1 | Gilles Grandgérard | </pre> |
| 16 | 1 | Gilles Grandgérard | |
| 17 | 1 | Gilles Grandgérard | <pre> |
| 18 | 1 | Gilles Grandgérard | tail -f /var/lib/mysql/mysql_general.log |
| 19 | 1 | Gilles Grandgérard | </pre> |