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