Running the identical python script that parses XML and inserts records into MySQL using MySQLdb package for python, I'm experiencing very different load times between a Mac Mini i5 with 8GB of RAM (OS High Sierra), and an HP Pavilion with an AMD A-10 with 12GB of RAM (Ubuntu 16.04).
The Mac Mini inserts the records at about 100 per second, while the AMD A-10 only inserts about 1 record per second. I initially thought it was because I was running full drive encryption, but after a fresh install of Ubuntu without drive encryption, the database is still bottlenecked to 1 insertion per second.
What can I do to trouble-shoot the bottleneck on the AMD machine in Ubuntu?
I checked the free memory on the AMD and about half of the RAM is still free, the swap space was not used at all. Otherwise, I'm at a loss of what to check to troubleshoot.