How To View Binding Params Via profileSQL=true In MySQL
Description: View the prepared statement binding parameters via profileSQL=true in MySQL.
Key points:
- in
application.propertiesappendlogger=Slf4JLogger&profileSQL=trueto the JDBC URL (e.g.,jdbc:mysql://localhost:3306/bookstoredb?createDatabaseIfNotExist=true&logger=Slf4JLogger&profileSQL=true)
Output sample:
| If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices" | If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you. |
|
|
|
