[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 >
[SLAVE root@db001 ~]# rpm -qi Percona- Server- server- 51-5.1. 56-rel12. 7.224.rhel5 Server- server- 51 Relocations: (not relocatable) gni.percona. com Databases Source RPM: Percona- Server- 51-5.1. 56-rel12. 7.224.rhel5. src.rpm www.gnu. org/licenses/ gpl-2.0. html www.percona. com/
Name : Percona-
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.
Group : Applications/
Size : 45149140 License: GPL version 2 http://
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://
Summary : Percona Server (GPL), 12.7, Revision 224 for Red Hat Enterprise Linux 5
[SLAVE root@db001 log]# tail -f slow_queries.log 1332597874;
# 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=
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' * priv.h: 735: { SLOG_F_TMP_DISK, "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_
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' * test/Percona- Server- 5.1.56 >
kormoc@kormoc: ~/Downloads/