A feature of the MySQL server that is used a lot, and yet is a
source of much user confusion, code complexity, and
multiprocessor lock contention, is logging. Query logging, slow
query logging, and the new 5.1 feature, "log to table".[Read more]
I've removed most all of that stuff from Drizzle (and removed two
or three sets of now-no-longer-necessary mutex locks in the
process), and replaced it with hooks into a logging plugin
subsystem, and have implemented two plugins for it. One logs to a
file, and the other logs to syslog.
The output looks almost completely unlike the current MySQL
logging. There are no hash-prefixed pseudocomments, for one
thing. And there is no distinction between the query log and the
slow query log. Queries get logged, and the amount of time each
query takes gets logged with it. This subsumes the "micro-slow
patch" that is spreading around in the MySQL legacy world.
The current format is …