[Novalug] [FredLug] MySQL Performance.
sheridan3003 at yahoo.com
Sun Mar 25 10:01:16 EDT 2012
That is a good point, I should see how well PostgreSQL does. It has been some time since I used PostgreSQL.
My main reason for doing this is that I have been doing some data modeling and I tend to keep similar columns together the way I learned it many years ago. I decided to see if it mattered anymore.
At least for MySQL it does. When I do PostgreSQL testing I will publish those results as well.
From: Jared Smith <jared.voip at gmail.com>
To: "novalug at calypso.tux.org" <novalug at calypso.tux.org>; fredlug <FredLug at calypso.tux.org>
Sent: Saturday, March 24, 2012 6:51 PM
Subject: Re: [FredLug] MySQL Performance.
On Sat, Mar 24, 2012 at 5:41 PM, Doug Needham <sheridan3003 at yahoo.com> wrote:
> This may be a little self-promotion, but I have been doing some MySQL
> performance studies.
> I wrote a blog entry about the results.
As a recovering DBA myself (it's been eight years, two months, and
thirteen days since my last "myisamchk"!), I find your results
interesting, but not all that surprising. MySQL has all kinds of
weird performance quirks like that. The one that sticks out in my
mind was that in the MySQL 3.x series, there was a significant
performance difference between incrementing an integer in a field and
decrementing it -- to the point where a former employer of mine (and
at the time, one of the 10 largest MySQL installations in the world)
wrote all of their code to decrement counters instead of incrementing
them. To make matters worse, the 4.x series made the decrement
operation as slow as the increment, so last I checked they're still
Just out of curiosity, have you tried the same tests on PostgreSQL?
FredLug mailing list
FredLug at calypso.tux.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Novalug