Why do we create temp tables for MySQL imports?
Question Description:When we run MySQL imports there might be a warning that the import failed to create a temp table.
For what do we need those temp tables? Does this mean we can only import when the user has editing rights?
Answer:
We try to create temporary tables (which are gone once the session closes), to import from there. Makes the imports faster, and doesn’t compete with other write queries going to the same table during the import.
It would also work with a user that has read-only permissions, and just log a warning that it couldn’t create the temp table.
Was this article helpful?