pt-upgrade select sleep(5000000)

16 views
Skip to first unread message

Eric

unread,
Apr 27, 2012, 12:30:26 PM4/27/12
to Percona Discussion
Hi All,
I am trying to use pt-upgrade to compare query run-times between MySQL
5.0.58 and Percona 5.1.61.
and I am getting a problem where the script tries to run a select
sleep(5000000) on whatever host i specify first.

pt-upgrade h=host1 h=host2 --compare query_times --convert-to-select --
continue-on-error slow.log

Is there a way to make the pt-upgrade not perform this initial sleep?

thanks,
Eric


Eric

unread,
Apr 27, 2012, 12:54:39 PM4/27/12
to Percona Discussion
Please Disregard.

I realize now that i am trying to compare queries that take 3-10
Minutes to execute and its actually running in the background.
Tool will probably work if just wait long enough.

I used some smaller queries that take < 1 minute an the tool is
working great.

Significant query time differences
# Query ID host1:3306 host2:3306 %Increase %Threshold
# ================== ================ ================ =========
==========
# E252E33DFDCED0DE-1 17s 29s
70.59 1


Percona instance is much faster for this particular query.

Thanks,
Reply all
Reply to author
Forward
0 new messages