mysql
2 11 2011
I’ve been going through the MySQL slow query log at my new job to optimize our applications performance. It’s a bit more scary making changes when you’re the “new guy” because there are a lot of “gotchas” you haven’t quite figured out in the new platform. Well one of the queries that I wanted to [...]
5 10 2011
I performed some unscientific PHP benchmarks today pitting casting to an integer against is_numeric against preg_replace. The point was to see which is the fastest way of quickly cleaning user input before passing to a SQL query to prevent against SQL injection. Obviously this would only work on database fields that are integers. To be [...]
31 03 2011
Simple methods for analyzing and parsing information out of the MySQL slow query log and then optimizing the slow queries.
24 11 2010
Learn how MySQL temporary tables can optimize your web application.
12 11 2010
How to create MySQL Triggers including examples, tutorials, and syntax on creating MySQL Triggers.
28 10 2010
There is a way to effectively disable the MySQL slow query log dynamically without restarting the mysql daemon. Find out how by reading this blog.
9 09 2010
Some ideas on improving MySQL ORDER BY. How to optimize MySQL ORDER BY and other MySQL musings.
19 08 2010
How to Optimize MySQL for multiple parameters and conditions on JOINS statements. Learn how in this blog.
11 08 2010
What is PDO (PHP Data Objects) Error HY093? HY093 defines an improperly binded a data type. Learn about how to fix MySQL PHP PDO Error HY093 in this blog.
22 06 2010
Learn how to fix MySQL Error 1111 – Invalid Use of Group Function in this blog post.