I was wondering if there are any best practice recommendations on setting up databases in a dev environment versus a live environment with regards to configuration.
Should they be as similar as possible (preferably identical)? Or should the dev environment be purposefully under powered in order to push developers to write optimal queries?
This could be as simple in MySQL as setting query_cache_size and related values to lower when on the dev machine.