| Name | Modified | Size |
|---|---|---|
| .. | ||
| README | 16 years ago | 7 KB |
| track2sql.php | 15 years ago | 20 KB |
| Change | User | Description | Committed |
|---|---|---|---|
| 7621 | Stewart Lord | Updated create table statements to use the IF NOT EXISTS condition. This allows SQL to be... fed into an existing database without errors/warnings. « |
15 years ago |
| 7620 | Stewart Lord | Minor update to Track2SQL to avoid timezone unset issue and split() function deprecated i...n PHP 5.3. « |
15 years ago |
| 7338 | Stewart Lord | Rolled-back change 7209. This removes the endTime column from the process table. Track2S...QL no longer attempts to analyze 'completed' entries. This change was influenced by three factors: - Analyzing 'completed' entries significantly degrades performance (about 2.75x slower in my tests). - In some versions of PHP (5.2.8) the strtotime() function suffers from a memory leak. - The 'completed' entries are not part of Vtrack output. « |
16 years ago |
| 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. « |
16 years ago |
| 7199 | Stewart Lord | Updated Track2SQL readme file to reflect schema changes. | 16 years ago |
| 7198 | Stewart Lord | It is now possible to accumulate output from multiple invocations of track2sql in a singl...e database. Previously, the processKey was a incrementing value that always started at zero. Therefore, processKeys from separate runs of track2sql would collide if inserted into the same databse. Now, track2sql uses a 36 character universally unique identifier (UUID) for each process. UUIDs give us reasonable confidence that the process keys will never collide. One consequence of this change is that the schema is slightly different. The type of the processKey column is now a 36 character varchar instead of a integer. Another side-effect of this change is that the output of track2sql cannot be predicted and will always be different even when processing the same log file. Track2sql performance is largely unaffected, however, insert and select performance may degrade somewhat due to the larger key size. « |
16 years ago |
| 7197 | Stewart Lord | Fixed a bug where incomplete process lines such as: 'journal rotation', produced invalid... SQL output. Log entries with process lines that fail to pass a basic sanity check are now ignored. The added check is rather crude and therefore performance is largely unaffected. « |
16 years ago |
| 7193 | Stewart Lord | Fixed a bug where 'pages reordered' data could be mistaken for 'pages i/o' data, if the '...pages reordered' line was not preceded by a 'pages i/o' line. « |
16 years ago |
| 7104 | Stewart Lord |
Follow-on to 7098. The quote() function now wraps and escapes the given string. |
16 years ago |
| 7098 | Stewart Lord | Fixed a sqlite incompatibility. Backslash is not a valid way to escape quotes in sqlite.... Quote-quote ('') is valid in both mysql and sqlite. Replaced use of addslashes with a quote() function that replaces occurrences of single-quotes with two single quotes. « |
16 years ago |
| 6424 | Stewart Lord |
Updated track2sql disclaimer. Addded a link to the readme file from the script itself. |
17 years ago |
| 6379 | Stewart Lord | Fixed a bug where track2sql failed to properly extract some table usage data if 'pages re...ordered' were reported. « |
17 years ago |
| 6289 | Stewart Lord | Minor update to track2sql. - Added version and usage information. Can be viewed &n...bsp; 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. « |
17 years ago |
| 6010 | Stewart Lord | Fixed a bug where track2sql failed to properly parse lock times in 2007.2 log files. This... was due to a small change in the log file format. « |
18 years ago |
| 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. « |
18 years ago |
| 5883 | Stewart Lord | Fixed minor typo in README. | 18 years ago |
| 5858 | Stewart Lord | Added disclaimer to script. | 18 years ago |
| 5857 | Stewart Lord | Initial add of track2sql to the public depot. | 18 years ago |