On 9/02/2016 11:23 p.m., Tony Peña wrote: > Hi > > I want to modify the /usr/lib/squid3/log_db_daemon script, but I'm not know > very knowledge about PERL, so if i want to modify to get on the mysql > table, not epoch_time, and date_time in human readable i guess first change > the scheme... Hi Tony, If you change the stored format to be human-text then you have to change *everything* touching or using that data. the logger, the database functions procedures, the display logics. Right down to sorting and comparisions between any two records by the DB software itself. Just listing the records in the right order now needs to account for leap-things (from years to nanoseconds), local machine clock skew, governments changing your local TZ offsets (daylight savings) schedule, etc, etc. It is a huge amount of avoidable complexity and performance drag all the way through the code. So, leave it all as the efficient epoch internally and do the time conversion exactly once: at the point where its actually being displayed to a human. MySQL provides a built-in function for reformatting timestamps if it is the point doing the display. <https://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_from-unixtime> Amos _______________________________________________ squid-users mailing list squid-users@xxxxxxxxxxxxxxxxxxxxx http://lists.squid-cache.org/listinfo/squid-users
