I started with the command line
Code: Select all
root@b3:~# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5628
Server version: 5.1.49-3-log (Debian)
...
mysql> set global general_log = 'ON';
Query OK, 0 rows affected (0.00 sec)
mysql> show tables
-> ;
ERROR 1046 (3D000): No database selected
mysql> Bye
Output in the mysql.log file during the system update:
Code: Select all
130611 17:27:30 5628 Query set global general_log = 'ON'
130611 17:27:51 5628 Query show tables
130611 17:27:54 5628 Quit
130611 17:29:03 5629 Connect root@localhost on
5629 Query set autocommit=0
5629 Quit
130611 17:29:56 5630 Connect root@localhost on
5630 Refresh
/usr/sbin/mysqld, Version: 5.1.49-3-log ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
well, I set the global_log variable to ON, as can be seen from the output of mysql.log in /var/log/mysql/)
"show tables", "quit" are my command sequence from within the mysql command (including the error of omitting the ';').
During system update, the query "set autocommit=0", followed by "quit" have been added to the output.
That's all.
It seems, that nothing has been queried by the system update.
The command "set autocommit=0" will be executed without errors, if typing it in manually.