Doomshammer's Weblog

Today I did some inspections of slow queries on my MySQL servers and I found this sweet query from a s9y plugin:


This query seems to be performed with every site impression of your blog (when the plugin is installed). Not only that e. g. the GROUP BY makes no sense here (besides of slowing down the query), this query can take very very long time in execution (2 to 10 seconds) if you have lots of site impressions (the s9y_visitors table of the blog, where I found this, currently holds over 500.000 rows). For sure there is no rotation or expiration for this table. Dear developer of this plugin, please try again and build it more performance sparing!

• Comments (0)
• Trackbacks (0)

I found an interessting article at the MySQL Performance blog, pointing me to these benchmarks:

• MySQL vs. PostgreSQL
• RDBMS on Solaris vs. Linux

It's pretty interessting to see, that PostgreSQL is performing very well, where MySQL is suffering very quickly with increasing concurrency. Also the 2nd benchmark shows pretty good, that PostgreSQL and Solaris is a good team, and Linux/MySQL combination is also scaling very bad.

Another confirmation that I'm going the right way with my SunOS/PostgreSQL combination

• Comments (0)
• Trackbacks (0)

Here Peter Zaitsev (a former MySQL employee) writes about a new MySQL policy which is not to provide new versions to non-paying MySQL users. Luckily I am only using MySQL for my customers. All my projects are using PostgreSQL (which IMHO is ways better).

• Comments (0)
• Trackbacks (0)