Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Import is slow, when tracking is configured #13318

Closed
silverasu opened this issue May 30, 2017 · 0 comments
Closed

Import is slow, when tracking is configured #13318

silverasu opened this issue May 30, 2017 · 0 comments
Assignees
Labels
Bug A problem or regression with an existing feature
Milestone

Comments

@silverasu
Copy link

silverasu commented May 30, 2017

When tracking functionality is activated, phpmyadmin will make 2 select queries after every insert. This makes big database import very slow.

Query log, while tracking is active:

INSERT INTO `test` (`id`) VALUES(1)
                  467 Query     SELECT MAX(version) FROM `phpmyadmin`.`PMA_tracking` WHERE `db_name` = 'dump'  AND `table_name` = 'test'  AND FIND_IN_SET('INSERT',tracking) > 0
                  467 Query     SELECT tracking_active FROM `phpmyadmin`.`PMA_tracking` WHERE db_name = 'dump'  AND table_name = 'test'  ORDER BY version DESC LIMIT 1
                  468 Query     INSERT INTO `test` (`id`) VALUES(2)
                  467 Query     SELECT MAX(version) FROM `phpmyadmin`.`PMA_tracking` WHERE `db_name` = 'dump'  AND `table_name` = 'test'  AND FIND_IN_SET('INSERT',tracking) > 0
                  467 Query     SELECT tracking_active FROM `phpmyadmin`.`PMA_tracking` WHERE db_name = 'dump'  AND table_name = 'test'  ORDER BY version DESC LIMIT 1

Query log, while tracking is not configured:

INSERT INTO `test` (`id`) VALUES(1)
INSERT INTO `test` (`id`) VALUES(2)

Fix: remove tracking functionality, while importing?

@nijel nijel self-assigned this Jun 13, 2017
@nijel nijel added the Bug A problem or regression with an existing feature label Jun 13, 2017
@nijel nijel added this to the 4.7.2 milestone Jun 13, 2017
nijel added a commit that referenced this issue Jun 13, 2017
We won't use it anyway, so it's better to avoid that query.

Issue #13318

Signed-off-by: Michal Čihař <michal@cihar.com>
@nijel nijel closed this as completed in 4f30297 Jun 13, 2017
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jun 22, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Bug A problem or regression with an existing feature
Projects
None yet
Development

No branches or pull requests

2 participants