MySQL Forums
Forum List  »  Backup

Mysqldump Taking lot of time - Stored Procedures only
Posted by: Karnish Master
Date: July 06, 2023 07:05AM

Anyone has any idea while taking mysqldump for stored procedure/routines, why Processlist shows "show table status like XXXX(i.e. table_name)?

Command Used :

mysqldump -f -u root -p --no-tablespaces --protocol=socket -S /tmp/socketpath.sock --no-data --no-create-db --no-create-info --routines --triggers=false --single-transaction --quick --skip-lock-tables database_name > databasename_routines.sql

The number of routines is 4000+ , however whenever we try to take mysqldump of routines it is taking a humongous amount of time, and in the show processlist its doing "show table status like ......."

Options: ReplyQuote

Written By
Mysqldump Taking lot of time - Stored Procedures only
July 06, 2023 07:05AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.