I'm really confused because this table doesn't even have any foreign keys or external references, only a handful of columns, and the primary key is just an incrementing integer. this is just a normal use case, but inserting 200 rows via batch insert takes upwards of 4 or 5 seconds. I purged the table and did the same insert and it still took about 700ms.
worse yet, this is Amazon Aurora MySQL -- shouldn't their storage driver be better than this considering the pricing?