Chris Nizzardini

Salt Lake City, Utah Developer / Human / Blogger

SQL

MySQL Optimization Tip: Checking for Differences in Queries.

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 [...]

, ,

MySQL Slow Query Log – Analyzing, Parsing, and Optimizing Slow Queries

Simple methods for analyzing and parsing information out of the MySQL slow query log and then optimizing the slow queries.

, , ,

MySQL Temporary Tables Example – Optimizing PHP Applications

Learn how MySQL temporary tables can optimize your web application.

, , , , ,

MySQL Trigger – How To, Example, Tutorial, and Syntax

How to create MySQL Triggers including examples, tutorials, and syntax on creating MySQL Triggers.

,

Enable or Disable MySQL 5.0 Slow Query Log Dynamically Without a Server Restart

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.

,

Random Musings on MySQL Order By Optimizations

Some ideas on improving MySQL ORDER BY. How to optimize MySQL ORDER BY and other MySQL musings.

,

MySQL INNER JOIN on Multiple Parameters and Condtions

How to Optimize MySQL for multiple parameters and conditions on JOINS statements. Learn how in this blog.

, ,

What is PDO Error HY093: Debug/Fix MySql PHP PDO Error HY093

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.

, , ,

Use MySQL HAVING to Get Past Error 1111 Invalid Use of Group Function

Learn how to fix MySQL Error 1111 – Invalid Use of Group Function in this blog post.

, , ,

MySQL InnoDb inserts are slow, really slow!

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 [...]

, ,

Previous Posts