You are managing a MySQL database in Cloud SQL that supports a high-volume inventory application. Recently, users have reported delays during high traffic due to lock contention. You want to minimize the time it takes to identify such issues in the future. What should you do?