Sep 8, 2024 · Backend Development

How to Monitor and Optimize SQL Performance in Spring Boot with p6spy

Learn how to seamlessly integrate the open‑source p6spy tool into a Spring Boot 3.2.5 application to automatically log SQL statements, measure execution times, customize logging formats, and fine‑tune database performance using both MyBatis and JPA examples.

MyBatisSQL MonitoringSpring Boot

0 likes · 8 min read

How to Monitor and Optimize SQL Performance in Spring Boot with p6spy

Lobster Programming

Aug 6, 2024 · Backend Development

How to Log MyBatis SQL and Execution Time with Config, Plugins, and p6spy

This guide explains three common ways to output MyBatis SQL statements and their execution times—using simple configuration logging, a custom MyBatis interceptor plugin, and the third‑party p6spy library—along with code examples and practical considerations for development and production environments.

MyBatisPerformance MonitoringSQL Logging

0 likes · 8 min read

How to Log MyBatis SQL and Execution Time with Config, Plugins, and p6spy