If MySQL is configured with --with-debug you can use this option to get a trace file of what mysqld is doing. The debug_options string often is 'd:t:ofile_name'. The default is 'd:t:i:omysqld.trace'.