Comments - Waiting for table metadata lock - during parallel database loads
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hi,
What I mean by multiple database loads is running 2 or 20 database loads in parallel.
The script I have loads "x"databases in parallel (some I wrote to reload Sybase, Oracle and Informix database servers). The issue I have found is MySQL prevents any other ALTER statements from executing while another ALTER statement is in progress.
You don't specify, but perhaps you were running into locking issues when restoring from a mysqldump? See the mysqldump article for various settings.