hey does anyone know why mariadb/mysql would chug hard when inserting rows into a table with only 1 million rows and a single secondary index on a single column

Follow

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?

this use case may be better suited to Cassandra but that's not what we have today right now

Sign in to participate in the conversation
Awoo Space

Awoo.space is a Mastodon instance where members can rely on a team of moderators to help resolve conflict, and limits federation with other instances using a specific access list to minimize abuse.

While mature content is allowed here, we strongly believe in being able to choose to engage with content on your own terms, so please make sure to put mature and potentially sensitive content behind the CW feature with enough description that people know what it's about.

Before signing up, please read our community guidelines. While it's a very broad swath of topics it covers, please do your best! We believe that as long as you're putting forth genuine effort to limit harm you might cause – even if you haven't read the document – you'll be okay!