Comments - Waiting for table metadata lock - during parallel database loads

8 years, 2 months ago Stephen Werner


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.

7 years, 2 months ago Ian Gilfillan

You don't specify, but perhaps you were running into locking issues when restoring from a mysqldump? See the mysqldump article for various settings.

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.