Is there a standard approach to monitor the performance of an application and its database, which is still in design?
What I'm doing so far: I develop queries and tests directly in mysql workbench and monitor the msec used per query. On top of that I'm using mocha tests in node.js to test the database api and also try here to measure the typical impact on the database.
The standard approach I know is: do your design and one day, as the amount of data has grown, there is a bad surprise, that the database needs to be optimized. I'm asking for good practices to monitor performance from the beginning.