Update for db schema #39

roman-vynar opened this Issue Aug 26, 2012 · 1 comment

2 participants



It seems https://bugs.launchpad.net/percona-toolkit/+bug/963225 is resolved on pt-query-digest side/doc.

[root@centos6 ~]# cd /var/www/html/anemometer/
[root@centos6 anemometer]# grep -r Disk_tmp_table *
install.sql: Disk_tmp_table_cnt float DEFAULT NULL,
install.sql: Disk_tmp_table_sum float DEFAULT NULL,
[root@centos6 anemometer]# grep -r Disk_filesort *
install.sql: Disk_filesort_cnt float DEFAULT NULL,
install.sql: Disk_filesort_sum float DEFAULT NULL,

So this should be changed to:
< Tmp_table_on_disk_cnt float DEFAULT NULL,
< Tmp_table_on_disk_sum float DEFAULT NULL,
< Filesort_on_disk_cnt float DEFAULT NULL,
< Filesort_on_disk_sum float DEFAULT NULL,



Hi Roman,

Wow, thanks for bringing this to my attention -- I realized although I have the correct table definitions on my local copy, I neglected to put all of the table schema changes into the install.sql. You're totally right that those columns are missing. I'll fix that.

@gtowey gtowey pushed a commit that referenced this issue Aug 31, 2012
Gavin Towey added tmp/filesort on disk columns to schema (fix issue #39) 2f68f63
@gtowey gtowey closed this Aug 31, 2012
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment