im upgrading our mariadb database from PRIMARY KEY INT AUTO_INCREMENT to UUID PRIMARY KEY. We have around 80 tables with multiple relations between them. I've build a migration script to change the id field to BINARY(16) and created for every row a Uuid v4. Then i've updated the relations with the new uuid (also as BINARY(16)). When i run multiple queries to do a performance benchmark, i have an average performance decrease from 15% on my local docker environment. The id field is a PRIMARY KEY. The relation fields are marked as index and have Foreign Key constraints.
What can i do to improve the performance?
Most of the tables has round about 200k entries. The whole database has a size of 3.2GB