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


Subject
Views
Written By
Posted
Mysqldump Taking lot of time - Stored Procedures only
233
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.