How to speed up MySQL INSERTs/UPDATEs?

I have three large MySQL tables. They are approaching 2 million records. Two of the tables are InnoDB and are currently around 500 MB in size. The other table is MyISAM and is about 2.5 GB.

We run an import script from FileMaker to insert and update records in these tables but lately it has become very slow - only inserting a few hundred records per hour.

What can I do to increase performance to make inserts and updates happen faster?

Solution

It turns out the reason for the slowness was from the FileMaker side of things. Exporting the FileMaker records to a CSV and running INSERT/UPDATE commands resulted in very fast execution.

Fastest R equivalent to MATLAB's reshape() method?
Dictionary Keys.Contains vs. ContainsKey: are they functionally equivalent?
Parallel Framework and avoiding false sharing
How to tackle time limit exceeded error in leetcode
32-bit pointers with the x86-64 ISA: why not?
Performance implications of long double. Why does C choose 64-bits instead of the hardware's 80-bit for its default?
Local variables performance vs global in example
native memory leak of compose multiplatform
What's the fastest way to read a text file line-by-line?
Very slow recursive type
How can I shift a column in a dataframe x times into an array, apply a function, and create a new column?
How to benchmark Swift code execution?
Will an iterator surrounding an assert statement affect performance of production build?
Improve Pandas and Vectorization Performance on large dataset
Efficiently calculate an availability date from a list of project assignments and known capacity
PrimeVue Table slow if dataset >200
Efficient solution for the same-fringe problem for binary trees
Get Index of Sub Array in MongoDB
Performance implications of iterating over set with --downlevelIteration - is a new array always created?
When should I use ConcurrentSkipListMap?
How to optimize screen real estate in a J2EE struts app?
C++ replacement for C99 VLAs (goal: preserve performance)
Using compound literals inside loop in C
Performance cost of type comparisons
What is the fastest way to read in a large yaml file containing lists of lists?
Why loading some css and js file taking too long time?
Quickest way to iterate over a pandas dataframe and perform an operation on a column, when what the operation is depends on the row
Why is Query Optimizer Underestimating and Causing Data Spill to tempdb?
Can I enforce the order of XML attributes using a schema?
How can I optimize the performance of this numpy function