Ways to test MySQL performance?

Hey Sp,

I’m curious how one goes about benchmarking a certain database schema against another and what tests would resemble typical activity for a game, and a webserver?

Is there a way to generate dummy data in a database? I’m also curious if it’s possible for the dummy data to be generated with relationships between the data?