From: Dmitry Lenev
Date: December 16 2010 7:21am
Subject: Re: bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054
List-Archive: http://lists.mysql.com/commits/127023
Message-Id: <20101216072102.GA15385@mockturtle>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Hello Davi!
* Davi Arnaut [10/12/14 02:35]:
> # At a local mysql-5.1-bugteam repository of davi
>
> 3520 Davi Arnaut 2010-12-13
> Bug#42054: SELECT CURDATE() is returning bad value
...
> Since this logic was being used due to ancient performance reasons,
> the solution is to simply rely on time(), which nowadays is just a
> wrapper around the somewhat fast gettimeofday function.
Could you please elaborate when has this change occurred and what
has changed?
Looking at OpenSolaris sources (yes, I know it is discontinued) I still
can see that time() uses systrap whereas gethrtime() uses something which
is called *fast*" systrap.
Also I have found the following article claiming that using gethrtime
gives boost to MySQL performance even on Solaris 10:
http://developers.sun.com/solaris/articles/mysql_perf_tune.html
And finally please note that for 5.1 we still support Solaris 8 and 9:
http://www.mysql.com/support/supportedplatforms/database.html
--
Dmitry Lenev, Software Developer
Oracle Development SPB/MySQL, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification