[Novalug] [FredLug] MySQL Performance.

[Doug Needham]

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. 


Thanks,

 
Doug 
http://www.linkedin.com/in/dougneedham
http://the-data-guy.blogspot.com/



________________________________
 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.
> http://the-data-guy.blogspot.com/2012/03/increase-mysql-performance-organize.html

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
running 3.x.

Just out of curiosity, have you tried the same tests on PostgreSQL?

--
Jared Smith
_______________________________________________
FredLug mailing list
FredLug at calypso.tux.org
http://calypso.tux.org/mailman/listinfo/fredlug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://calypso.tux.org/pipermail/novalug/attachments/20120325/80f1e0b6/attachment.html