Comment 6 for bug 963225

[SLAVE root@db001 ~]# rpm -qi Percona-Server-server-51-5.1.56-rel12.7.224.rhel5
Name : Percona-Server-server-51 Relocations: (not relocatable)
Version : 5.1.56 Vendor: Percona, Inc
Release : rel12.7.224.rhel5 Build Date: Fri 15 Apr 2011 02:15:42 PM PDT
Install Date: Wed 27 Apr 2011 04:52:24 PM PDT Build Host: sm1u02.gni.percona.com
Group : Applications/Databases Source RPM: Percona-Server-51-5.1.56-rel12.7.224.rhel5.src.rpm
Size : 45149140 License: GPL version 2 http://www.gnu.org/licenses/gpl-2.0.html
Signature : DSA/SHA1, Mon 18 Apr 2011 11:28:10 AM PDT, Key ID 1c4cbdcdcd2efd2a
Packager : Percona, Inc Development Team <email address hidden>
URL : http://www.percona.com/
Summary : Percona Server (GPL), 12.7, Revision 224 for Red Hat Enterprise Linux 5

[SLAVE root@db001 log]# tail -f slow_queries.log
# User@Host: User[User] @ Host [ip]
# Thread_id: 22729487 Schema: db Last_errno: 0 Killed: 0
# Query_time: 5.082390 Lock_time: 0.014276 Rows_sent: 2 Rows_examined: 15797857 Rows_affected: 0 Rows_read: 7718504
# Bytes_sent: 140 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 1044720
# InnoDB_trx_id: 2A2544B6B
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0
use db;
SET timestamp=1332597874;

and that timestamp maps to Sat, 24 Mar 2012 14:04:34 GMT, so it's not an old log by any means.

All of our databases are on the same point release and same rpm and show the same log format.

I downloaded the src.rpm from http://www.percona.com/downloads/Percona-Server-5.1/Percona-Server-5.1.56-12.7/source/ and grepped for the strings I'm seeing and they appear to be set.

kormoc@kormoc: ~/Downloads/test/Percona-Server-5.1.56 > grep -rin 'Tmp_table_on_disk' *
sql/log.cc:2428: "# QC_Hit: %s Full_scan: %s Full_join: %s Tmp_table: %s Tmp_table_on_disk: %s\n" \
sql/mysql_priv.h:735: { SLOG_F_TMP_DISK, "tmp_table_on_disk" },
sql/mysqld.cc:7076: "Log only the queries that followed certain execution plan. Multiple flags allowed in a comma-separated string. [qc_miss, full_scan, full_join, tmp_table, tmp_table_on_disk, filesort, filesort_on_disk]",

and there are no matches for the string pt-query-digest looks for

kormoc@kormoc: ~/Downloads/test/Percona-Server-5.1.56 > grep -rin 'Disk_tmp_table' *
kormoc@kormoc: ~/Downloads/test/Percona-Server-5.1.56 >