search

philipmat / discogs-xml2db

Imports the discogs.com monthly XML dumps into databases
Apache License 2.0
207 stars 76 forks source link

It's normal? #147

Closed pablo-reyes-cabrera closed 2 months ago

pablo-reyes-cabrera commented 3 months ago

Hi. I am applying foreign keys through the following command : mysql/exec_sql.sh < mysql/AssignForeignKeys.sql The process has been running for 24 hours and is still not finished. Is this normal (MacBook Pro m2 32GB)? The process in the activity monitor shows a high % of CPU usage.

thanks in advance,

Pablo Reyes

philipmat commented 2 months ago

It may be. It's a very large dataset... You could run SHOW FULL PROCESSLIST; and see what MySQL processes are taking place