List:Commits« Previous MessageNext Message »
From:Dmitry Lenev Date:December 16 2010 7:21am
Subject:Re: bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054
View as plain text  
Hello Davi!

* Davi Arnaut <davi.arnaut@stripped> [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
Thread
bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054Davi Arnaut14 Dec
Re: bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054Magne Mæhre15 Dec
Re: bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054Dmitry Lenev16 Dec
  • Re: bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054Davi Arnaut16 Dec
    • Re: bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054Dmitry Lenev16 Dec
      • Re: bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054Davi Arnaut16 Dec
        • Re: bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054Dmitry Lenev16 Dec
          • Re: bzr commit into mysql-5.1-bugteam branch (davi:3520) Bug#42054Davi Arnaut16 Dec