using pt-online-schema-change to add column,but it quit automatically

Asked by sophie.chen

Hello,
    when we use pt-online-schema-change to add the column on a table without the foreign key.the process quit automatically after doing the step:update_foreign_keys, 10, 1.from the background of the mysql,we find that it just use the below command to check the reference relationship:
SELECT table_schema, table_name FROM information_schema.key_column_usage WHERE referenced_table_schema='' AND referenced_table_name=''

    because of our mysql instance has many databases and many tables,so above select statement will last long.So can we have any method to optimize it?
    or can we have any way to escape it?

Question information

Language:
English Edit question
Status:
Expired
For:
Ubuntu percona-toolkit Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
sophie.chen (sophie.139) said :
#1

SELECT table_schema, table_name FROM information_schema.key_column_usage WHERE referenced_table_schema='xxx' AND referenced_table_name='xx'
0 row in set, 0 warning (3 hours 20 min 42.98 sec)

Revision history for this message
sophie.chen (sophie.139) said :
#2

Hello,can we have any way to escape this check?

Revision history for this message
Launchpad Janitor (janitor) said :
#3

This question was expired because it remained in the 'Open' state without activity for the last 15 days.