Time                       ID Action   Argument
20070512 10:58:41.731252    1 GREETING Protocol Version 10, Server Version 5.0.42-log, Server Caps 0xA22C [LONG_FLAG+CONNECT_WITH_DB+COMPRESS+PROTO_41+TRANSACTIONS+SECURE_AUTH], Charset 8 [latin1 COLLATE latin1_swedish_ci], status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.742617    1 LOGIN    from 127.0.0.1:38360, User schwenke, No Password, Client Caps 0xA205 [LONG_PASSWORD+LONG_FLAG+PROTO_41+TRANSACTIONS+SECURE_AUTH], Max. Allowed Packet 1073741824, Client Charset 8 [latin1 COLLATE latin1_swedish_ci]
20070512 10:58:41.742878    1 OK       status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.743398    1 USE      DATABASE test
20070512 10:58:41.743616    1 OK       status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.744083    1 QUERY    [ CREATE DATABASE test1]
20070512 10:58:41.744609    1 OK       affected_rows=1 status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.745120    1 CHANGE   USER TO root (NO PASSWORD) USE DB test1
20070512 10:58:41.745310    1 OK       status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.745774    1 QUERY    [CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT, c2 CHAR(10))]
20070512 10:58:41.754117    1 OK       status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.754622    1 LIST     FIELDS FROM TABLE t1
20070512 10:58:41.755084    1 RESPONSE (tabular)
20070512 10:58:41.755956    1 PREPARE  [INSERT INTO t1 (c2) VALUES (?)]
20070512 10:58:41.756249    1 OK       created STMT #1 params: 1
20070512 10:58:41.757157    1 EXECUTE  STMT #1 [INSERT INTO t1 (c2) VALUES ([CHAR]"eins")]
20070512 10:58:41.757575    1 OK       affected_rows=1 insert_id=1 status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.758101    1 EXECUTE  STMT #1 [INSERT INTO t1 (c2) VALUES ([CHAR]"zwei")]
20070512 10:58:41.758380    1 OK       affected_rows=1 insert_id=2 status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.758547    1 EXECUTE  STMT #1 [INSERT INTO t1 (c2) VALUES ([CHAR]"drei")]
20070512 10:58:41.759104    1 OK       affected_rows=1 insert_id=3 status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.759279    1 EXECUTE  STMT #1 [INSERT INTO t1 (c2) VALUES ([CHAR]"viele")]
20070512 10:58:41.759853    1 OK       affected_rows=1 insert_id=4 status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.760032    1 EXECUTE  STMT #1 [INSERT INTO t1 (c2) VALUES ([CHAR]NULL)]
20070512 10:58:41.760595    1 OK       affected_rows=1 insert_id=5 status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.760780    1 CLOSE    STMT #1 [INSERT INTO t1 (c2) VALUES (?)]
20070512 10:58:41.760835    1 REFRESH  FLUSH TABLES
20070512 10:58:41.762014    1 OK       status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.762827    1 PREPARE  [/* foobar */ SELECT c2 FROM t1]
20070512 10:58:41.763271    1 OK       created STMT #2 (no params)
20070512 10:58:41.763829    1 EXECUTE  STMT #2 [/* foobar */ SELECT c2 FROM t1]
20070512 10:58:41.764148    1 RESPONSE (binary header)
20070512 10:58:41.765394    1 RESET    STMT #2 [/* foobar */ SELECT c2 FROM t1]
20070512 10:58:41.765572    1 OK       status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.766173    1 EXECUTE  STMT #2 [/* foobar */ SELECT c2 FROM t1]
20070512 10:58:41.766923    1 RESPONSE (binary header)
20070512 10:58:41.767176    1 FETCH    STMT #2
20070512 10:58:41.768000    1 RESPONSE (binary data, 0)
20070512 10:58:41.768118    1 FETCH    STMT #2
20070512 10:58:41.768173    1 RESPONSE (binary data, 0)
20070512 10:58:41.768228    1 FETCH    STMT #2
20070512 10:58:41.768278    1 RESPONSE (binary data, 0)
20070512 10:58:41.768332    1 FETCH    STMT #2
20070512 10:58:41.768380    1 RESPONSE (binary data, 0)
20070512 10:58:41.768433    1 FETCH    STMT #2
20070512 10:58:41.768481    1 RESPONSE (binary data, 0)
20070512 10:58:41.768534    1 FETCH    STMT #2
20070512 10:58:41.768581    1 EOF      status=0x0082 [AUTOCOMMIT+LAST_ROW]
20070512 10:58:41.768658    1 CLOSE    STMT #2 [/* foobar */ SELECT c2 FROM t1]
20070512 10:58:41.768742    1 DEBUG   
20070512 10:58:41.769030    1 EOF      status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.769499    1 PING    
20070512 10:58:41.769827    1 OK       status=0x0002 [AUTOCOMMIT]
20070512 10:58:41.770129    1 STATS   
20070512 10:58:41.770610    1 MESSAGE  "ptime: 25  Threads: 1  Questions: 26  Slow queries: 0  Opens: 15  Flush tables: 2  Open tables: 1  Queries per second avg: 1.040"
20070512 10:58:41.770756    1 PROCLIST
20070512 10:58:41.771260    1 RESPONSE (tabular)
20070512 10:58:41.771442    1 QUERY    [\tDROP DATABASE test1]
20070512 10:58:41.772838    1 OK       affected_rows=1 status=0x0102 [AUTOCOMMIT+DB_DROPPED]
20070512 10:58:41.773299    1 QUIT