SQL
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 [...]
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.
12 06 2010
So I was doing some MySQL database optimization tests this morning when I got my database engines mixed up. Thats when I stumbled on something horrible….InnoDb is really slow when it comes to inserts! Like really slow. I performed 10,000 inserts on MyIsam and it executed in about 1/10th of a second. The same inserts [...]