MySQL – ORDER BY does not sort data properly…
Imagine a developer working late at night trying to complete some simple queries for a report due the next day. No matter what she does, the resulting query will just…
Read moreTop My.CNF Optimizations for Innodb
These are the four parameters which will have the most affect on the performance of MySQL 5.1x and Innodb. If you are suffering from poor performance, try changing the…
Read moreShow Processlist and Show Full Processlist – MySQL Tip
Everyone knows that using the MySQL command Show Processlist will display all current connections, like the following : mysql> show processlist; show processlist; +—-+————-+—————–+——+———+——+———————————-+——————+ | Id | User | Host…
Read moreMySQL – Should you put an index on a Boolean field to help query performance?
I am often asked if it makes sense to place an index on a Boolean field in order to improve query performance. In general, because a boolean value can only…
Read moreMySQL – SQL Injection, and how to Prevent it
SQL injection vulnerabilities are often been described as the most serious threat for Web applications, regardless of what language they are written in . Web applications that are vulnerable to…
Read moreMySQL – Disabling Binary Logging for INSERT and UPDATE
I have run into many situations where there would be a benefit to not replicate a large INSERT or UPDATE from the MASTER to SLAVE in order to not block…
Read more