Tag Info

Hot answers tagged

2

mysqldump, or .sql files, which is what that module uses is probably the least efficient way to import a database (the only less efficient way I can think of is to import and commit each row at once). If you want to speedup the import process, you should change the method. There are several things that you can do in the MySQL configuration that will speed ...


1

Assuming that the script contains only INSERTs, UPDATEs and DELETEs to the target table(s), and that the app never attempts row locks (SELECT ... FOR UPDATE/SHARE) or DML on those tables, then the script shouldn't affect the app except for the increased load on the DB server. When the script commits, the changes will instantly become visible to new ...


1

You can specify your queries per table with the QUERY parameter with Data Pump export. For example: QUERY=employees:"WHERE department_id > 10 AND salary > 10000" With the above, only those rows are exported from the employees table, that have department_id > 10 AND salary > 10000. More information in the official documentation: ...



Only top voted, non community-wiki answers of a minimum length are eligible