Browsing articles from "June, 2011"
Jun
10
2011

Enable Logging of Slow Queries (Slow Query Log) in MySQL Database

One of the main requirements for a fast web server is to has efficient and effective SQL statements or queries that are optimized. Any non-optimal SQL (Structured Query Language) commands or statements that take too long or lengthy time to execute will use up a lot of system resources, causing MySQL database to run slower, and then more and more queries backlogs queuing up, and when connection limit is reached, visitors are been denied or [...]

Sponsors