Look at DBIx::Class::QueryLog and Log::Log4perl::Appender::DBIx::Class and the trace section of DBI. I think you can do pretty deep logging but I've never tried and when I've needed a log I've generally used DBI->trace to a tmp file.

I also am not sure how the reconnection stuff is is handled. I've been lucky enough that it's always "just worked" for everything I've done. You could dive the guts of the relevant Storage/Engine modules though I suspect the reconnect stuff is (at least partly) handled in the relevant DBD modules.