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