EmergencyEMERGENCY? Get 24/7 Help Now!

Are PHP persistent connections evil ?

 | November 12, 2006 |  Posted In: Insight for Developers

As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is probably one of the reasons some people delay migration to this extension. The reason behind using persistent connections is of course reducing number of connects which are rather expensive, even though they are much faster […]

Read More

When EXPLAIN can be misleading

 | November 12, 2006 |  Posted In: Insight for Developers

One think I can see with people using EXPLAIN is trusting it too much, ie assuming if number of rows is reported by EXPLAIN is large query must be inefficient. It may not be the case. The question is not only about stats which may be wrong and which is why you may want to […]

Read More

Wishes for new “Pure PHP” MySQL driver

 | October 28, 2006 |  Posted In: Insight for Developers

If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ . I’m to meet the team (Georg, Andrey etc) which will be developing this driver during my visit to Open Source Database Conference in November so I thought it would […]

Read More

Small things are better

 | October 8, 2006 |  Posted In: Insight for Developers

Yesterday I had fun time repairing 1.5Tb ext3 partition, containing many millions of files. Of course it should have never happened – this was decent PowerEdge 2850 box with RAID volume, ECC memory and reliable CentOS 4.4 distribution but still it did. We had “journal failed” message in kernel log and filesystem needed to be […]

Read More

APC or Memcached

 | September 27, 2006 |  Posted In: Insight for Developers

A while back I did Cache Performance Comparison for LAMP Stack. Looking at this data you can see memcached is about 5 times as slow as APC, and this is with tests done on localhost – with network difference is going to be larger, even with fastest network. Such latency can add up especially if […]

Read More

Alternatives of PHP ?

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

When I loaded GigaBytes of XMLs into mysql database with PHP script, I was thinking about PHP alternatives. Why do I need that ? 1. PHP is slow – I’m speaking about area of data processing and implementation of algorithms 2. No good cli debugger – I’m just tired of debugging with ‘echo’ and ‘var_dump’ […]

Read More

Wrong GROUP BY makes your queries fragile

 | September 6, 2006 |  Posted In: Insight for Developers

This is probably well known issue for everyone having some MySQL experience or experience with any other SQL database. Still I see this problem in many production applications so it is worth to mention it, especially as it is connected to MySQL Performance. No it might not affect MySQL Performance per say but it limits […]

Read More