[Novalug] [FredLug] MySQL Performance.

Alex Smith (K4RNT) shadowhunter@gmail.com
Tue Mar 27 13:45:06 EDT 2012


That was weird, I received the emails in this thread in reverse order -
enough that I almost didn't know what you guys were talking about... ;)

On Sun, Mar 25, 2012 at 10:01, Doug Needham <sheridan3003@yahoo.com> wrote:

> 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@gmail.com>
> *To:* "novalug@calypso.tux.org" <novalug@calypso.tux.org>; fredlug <
> FredLug@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@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@calypso.tux.org
> http://calypso.tux.org/mailman/listinfo/fredlug
>
>
>
> _______________________________________________
> Novalug mailing list
> Novalug@calypso.tux.org
> http://calypso.tux.org/mailman/listinfo/novalug
>
>


-- 
" ' With the first link, the chain is forged. The first speech censured,
the first thought forbidden, the first freedom denied, chains us all
irrevocably.' Those words were uttered by Judge Aaron Satie as wisdom and
warning... The first time any man's freedom is trodden on we’re all
damaged." - Jean-Luc Picard, quoting Judge Aaron Satie, Star Trek: TNG
episode "The Drumhead"
- Alex Smith (K4RNT)
- Dulles Technology Corridor (Chantilly/Ashburn/Dulles), Virginia USA
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.firemountain.net/pipermail/novalug/attachments/20120327/51489736/attachment.htm>


More information about the Novalug mailing list