percona-toolkit icon indicating copy to clipboard operation
percona-toolkit copied to clipboard

pt-query-digest :--create-history-table out of action

Open kaerdo opened this issue 8 years ago • 1 comments

create-history-table,create-review-table || Yes or no out of action
Cause a lot of “ CREATE DATABASE/TABLE IF NOT EXISTS” ,lot of metadata_locks pt-query-digest version 3.0.4 mysq version :5.7

kaerdo avatar Aug 26 '17 07:08 kaerdo

CLA assistant check
All committers have signed the CLA.

CLAassistant avatar Aug 26 '17 07:08 CLAassistant

Thank you for your contribution.

According to the comment:

# Even if the db already exists, do this in case it does not exist # on a slave.

These CREATE ... IF NOT EXIST statements are intentional. Also, these is just two tables, and you can avoid creating them by passing options --no-create-history-table and --no-create-review-table

svetasmirnova avatar Sep 14 '22 23:09 svetasmirnova