Hi Neo4j Team,
I am trying to import data from an Azure-hosted MySQL database into Neo4j.
I have two MySQL databases with similar data/schema:
- Database A: contains approximately 713 tables and imports successfully.
- Database B: contains approximately 873 tables and fails during the import.
The important point is that both databases are hosted on Azure MySQL and I am using the same Neo4j setup and connection method. The s
maller database imports successfully, while the larger database consistently times out.
For the larger database, I receive:
[504] Timeout waiting for job to complete
I have also previously encountered:
[500] SyntaxError: Unexpected token 'P' ... TLS handshake timeout
I would like to understand whether this could be related to Neo4j resource/tier limitations or whether there is something specific in the larger MySQL database causing the import to take longer.
Specifically:
- Does Neo4j inspect the MySQL schema, tables, columns, indexes, etc. during the connection/verification process?
- Does Neo4j read actual table data during the connection/verification stage, or only during the import stage?
- Is there a limitation on the number of tables or amount of MySQL data that can be imported?
- Could the larger number of tables cause the import job to exceed a timeout?
- Is there a way to increase the timeout or import the database in batches?
- Could this behavior be related to the Neo4j Free tier/resource limits?
- Is there a recommended way to identify which table or schema component is causing the timeout?
I can provide the table count, schema information, row counts, and relevant logs if needed.
Environment:
- Source: Azure MySQL
- Destination: Neo4j
- Import method: Neo4j web/Data Importer
- Smaller database: X tables — works
- Larger database: Y tables — timeout
Any guidance on how to successfully import the larger database would be appreciated.
Thanks