EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL EXPLAIN limits and errors.

 | July 24, 2006 |  Posted In: Insight for Developers

Running EXPLAIN for problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this tool a lot you probably noticed it is not always provide adequate information. Here is list of things you may wish to watch out. EXPLAIN can be wrong – this does not happen very often but it […]

Read More

Handling big result sets

 | June 26, 2006 |  Posted In: Insight for Developers

Sometime it is needed to handle a lot of rows on client side. Usual way is send query via mysql_query and than handle the result in loop mysql_fetch_array (here I use PHP functions but they are common or similar for all APIs, including C). Consider table:

Read More

How Web Services world affect LAMP Stack

 | May 22, 2006 |  Posted In: Insight for Developers

In connection to my previous post I was thinking how Web 2.0 with its massive use of Web Services affect LAMP Stack ? Well actually there are serious difference both for client and server application development which you might want to take into account. If you’re developing Web Service Server application you will most likely […]

Read More

Speedup your LAMP stack with LigHTTPD

 | May 21, 2006 |  Posted In: Insight for Developers

Apache Web server could frequently be bottleneck for your LAMP stack, or you might be wasting resources on your web servers. The problem with Apache server comes from “client per process” architecture which you have to stick to at least for dynamic content served by PHP or ModPerl. With “client per process” you end up […]

Read More

Descending indexing and loose index scan

 | May 9, 2006 |  Posted In: Insight for Developers

Comments to my previous posts, especially this one by Gokhan inspired me to write a bit about descending indexes and about loose index scan, or what Gokhan calls “better range” support. None of these are actially related to Innodb tables in general – these are features MySQL should get for all storage engines at some […]

Read More

My Innodb Feature wishes

 | May 4, 2006 |  Posted In: Insight for Developers

At Users Conference Heikki did good presentation about Innodb planned features. I did not see some of big and tiny wishes listed so I was making notes. Here is what I’d like to see Packed indexes. In many cases then difference in Performace with MyISAM and Innodb is huge for read only workload it is […]

Read More