README #2

  • //
  • guest/
  • lester_cheung/
  • track2sql/
  • README
  • Commits
# Change User Description Committed
#2 9732 Lester Cheung Renamed direcotry "track2sql" to "log_analyzer".
#1 8058 Lester Cheung Branching Steward's track2sql locally
//guest/stewart_lord/track2sql/README
#7 7209 Stewart Lord Integrating an enhancement from Michael Shield's guest
branch. Track2SQL now records the end time of each process
(when it is reported). This information is reported for every
completed process when -vserver=2|3 logging is enabled.

If verbose server logging is enabled this is more reliable than
start 'time' + 'lapse' because (by default) lapse is only reported
when it exceeds a certain threshold. If, however, vtrack=1 is
set then lapse time will be reported for every command.

Note: this change brings a schema change. It adds a
'endTime' column to the process table.
#6 7199 Stewart Lord Updated Track2SQL readme file to reflect schema changes.
#5 6424 Stewart Lord Updated track2sql disclaimer. Addded a link to the
readme file from the script itself.
#4 6289 Stewart Lord Minor update to track2sql.
 - Added version and usage information. Can be viewed
   with -v, -V or -h.
 - Added error handling for the case of a non-existent
   input file or a empty input file.
 - Removed 'drop table if exists' statements from the
   table creation SQL.
#3 5889 Stewart Lord Modified create table statements to use signed columns instead
of unsigned columns. This avoids subtraction problems that can
occur in some versions of MySQL when SQL_MODE is not set to
NO_UNSIGNED_SUBTRACTION.

Main() now sets error_reporting to E_ALL & ~E_NOTICE to
suppress notices.
#2 5883 Stewart Lord Fixed minor typo in README.
#1 5857 Stewart Lord Initial add of track2sql to the public depot.