source: pkg/security/vinnie/main/mysql-5.1/trunk/debian/additions/innotop/changelog.innotop @ 6989

Revision 6989, 15.4 KB checked in by alanbach-guest, 3 years ago (diff)
  • Updated mysql-5.1 from lenny-backports
Line 
1Changelog for innotop:
2
32009-03-09: version 1.7.1
4
5   Changes:
6   * Don't display the CXN column if only one connection is active in
7     the current view
8
9   Bugs fixed:
10   * fixed bug where trying to aggregate the time column would result
11     in a crash if the time column had an undef value in it, which is
12     the case when a thread is in the 'Connect' state
13   * updated innotop.spec file to reflect current version
14
152009-02-23: version 1.7.0
16
17   Changes:
18   * supports a central config (/etc/innotop/innotop.conf)
19   * changed the default home directory config to ~/.innotop/innotop.conf
20     (away from .ini)
21   * embedded InnoDBParser.pm into innotop so it can be run with no
22     installation
23   * no longer writes a new config file by default
24   * added --skipcentral (skip reading central config) and --write (write
25     a config if none were loaded at start-up)
26   * if no config file is loaded, connect to a MySQL database on
27     localhost using mysql_read_default_group=client
28   * embedded maatkit's DSNParser.pm and added support for --user,
29     --password, --host, --port
30   * changed default mode from T (InnoDB Transactions) to Q (Query List)
31   * in addition to connected threads, now displays running and cached
32     threads in statusbar
33   * don't load connections from a config file if any DSN information or
34     a username or password is specified on the command-line
35   
36   Bugs fixed:
37   * fixed bug preventing utilization of command-line options that
38     override default config settings if no config file was loaded
39   * fixed a bug where migrating from an old version of the config will
40     delete ~/innotop.ini, if it exists.  Now uses File::Temp::tempfile().
41
422007-11-09: version 1.6.0
43
44   * S mode crashed on non-numeric values.
45   * New user-defined columns crashed upon restart.
46   * Added --color option to control terminal coloring.
47
482007-09-18: version 1.5.2
49
50   * Added the ability to monitor InnoDB status from a file.
51   * Changed W mode to L mode; it monitors all locks, not just lock waits.
52
532007-09-16: version 1.5.1
54
55   * Added C (Command Summary) mode.
56   * Fixed a bug in the 'avg' aggregate function.
57
582007-09-10: version 1.5.0
59
60   Changes:
61   * Added plugin functionality.
62   * Added group-by functionality.
63   * Moved the configuration file to a directory.
64   * Enhanced filtering and sorting on pivoted tables.
65   * Many small bug fixes.
66
672007-07-16: version 1.4.3
68
69   Changes:
70   * Added standard --version command-line option
71   * Changed colors to cyan instead of blue; more visible on dark terminals.
72   * Added information to the filter-choosing dialog.
73   * Added column auto-completion when entering a filter expression.
74   * Changed Term::ReadKey from optional to mandatory.
75   * Clarified username in password prompting.
76   * Ten thousand words of documentation!
77
78   Bugs fixed:
79   * innotop crashed in W mode when InnoDB status data was truncated.
80   * innotop didn't display errors in tables if debug was enabled.
81   * The colored() subroutine wasn't being created in non-interactive mode.
82   * Don't prompt to save password except the first time.
83
842007-05-03: version 1.4.2
85
86   This version contains all changes to the trunk until revision 239; some
87   changes in revisions 240:250 are included.
88
89   MAJOR CHANGES:
90
91   * Quick-filters to easily filter any column in any display
92   * Compatibility with MySQL 3.23 through 6.0
93   * Improved error handling when a server is down, permissions denied, etc
94   * Use additional SHOW INNODB STATUS information in 5.1.x
95   * Make all modes use tables consistently, so they can all be edited,
96     filtered, colored and sorted consistently
97   * Combine V, G and S modes into S mode, with v, g, and s hot-keys
98   * Let DBD driver read MySQL option files; permit connections without
99     user/pass/etc
100   * Compile SQL-like expressions into Perl subroutines; eliminate need to
101     know Perl
102   * Do not save all config data to config file, only save user's customizations
103   * Rewritten and improved command-line option handling
104   * Added --count, --delay, and other command-line options to support
105     run-and-exit operation
106   * Improve built-in variable sets
107   * Improve help screen with three-part balanced-column layout
108   * Simplify table-editor and improve hotkey support
109   * Require Perl to have high-resolution time support (Time::HiRes)
110   * Help the user choose a query to analyze or kill
111   * Enable EXPLAIN, show-full-query in T mode just like Q mode
112   * Let data-extraction access current, previous and incremental data sets
113     all at once
114
115   MINOR CHANGES:
116
117   * Column stabilizing for Q mode
118   * New color rules for T, Q, W modes
119   * Apply slave I/O filter to Q mode
120   * Improve detection of server version and other meta-data
121   * Make connection timeout a config variable
122   * Improve cross-version-compatible SQL syntax
123   * Get some information from the DBD driver instead of asking MySQL for it
124   * Improved error messages
125   * Improve server group creation/editing
126   * Improve connection/thread killing
127   * Fix broken key bindings and restore previously mapped hot-keys for
128     choosing columns
129   * Some documentation updates (but not nearly enough)
130   * Allow the user to specify graphing char in S mode (formerly G mode)
131   * Allow easy switching between variable sets in S mode
132   * Bind 'n' key globally to choose the 'next' server connection
133   * Bind '%' key globally to filter displayed tables
134   * Allow aligning columns on the decimal place for easy readability
135   * Add hide_hdr config variable to hide column headers in tables
136   * Add a feature to smartly run PURGE MASTER LOGS in Replication mode
137   * Enable debug mode as a globally configurable variable
138   * Improve error messages when an expression or filter doesn't compile or has
139     a run-time error; die on error when debug is enabled
140   * Allow user-configurable delays after executing SQL (to let the server
141     settle down before taking another measurement)
142   * Add an expression to show how long until a transaction is finished
143   * Add skip_innodb as a global config variable
144   * Add '%' after percentages to help disambiguate (user-configurable)
145   * Add column to M mode to help see how fast slave is catching up to master
146
147   BUG FIXES:
148
149   * T and W modes had wrong value for wait_status column
150   * Error tracking on connections didn't reset when the connection recovered
151   * wait_timeout on connections couldn't be set before MySQL 4.0.3
152   * There was a crash on 3.23 when wiping deadlocks
153   * Lettercase changes in some result sets (SHOW MASTER/SLAVE STATUS) between
154     MySQL versions crashed innotop
155   * Inactive connections crashed innotop upon access to DBD driver
156   * set_precision did not respect user defaults for number of digits
157   * --inc command-line option could not be negated
158   * InnoDB status parsing was not always parsing all needed information
159   * S mode (formerly G mode) could crash trying to divide non-numeric data
160   * M table didn't show Slave_open_temp_tables variable; incorrect lettercase
161   * DBD drivers with broken AutoCommit would crash innotop
162   * Some key bindings had incorrect labels
163   * Some config-file loading routines could load data for things that didn't
164     exist
165   * Headers printed too often in S mode
166   * High-resolution time was not used even when the user had it
167   * Non-interactive mode printed blank lines sometimes
168   * Q-mode header and statusbar showed different QPS numbers
169   * Formulas for key-cache and query-cache hit ratios were wrong
170   * Mac OS "Darwin" machines were mis-identified as Microsoft Windows
171   * Some multiplications crashed when given undefined input
172   * The commify transformation did not check its input and could crash
173   * Specifying an invalid mode on the command line or config file could crash
174     innotop
175
1762007-03-29: version 1.4.1
177
178   * More tweaks to display of connection errors.
179   * Fixed a problem with skip-innodb in MySQL 5.1.
180   * Fix a bug with dead connections in single-connection mode.
181   * Fix a regex to allow parsing more data from truncated deadlocks.
182   * Don't load active cxns from the config file if the cxn isn't defined.
183
1842007-03-03: version 1.4.0
185
186   * Further tweak error handling and display of connection errors
187   * More centralization of querying
188   * Fix forking so it doesn't kill all database connections
189   * Allow user to run innotop without permissions for GLOBAL variables and status
190
1912007-02-11: version 1.3.6
192
193   * Handle some connection failures so innotop doesn't crash because of one server.
194   * Enable incremental display in more modes.
195   * Tweaks to colorizing, color editor, and default color rules.
196   * Tweaks to default sorting rules.
197   * Use prepared statements for efficiency.
198   * Bug fixes and code cleanups.
199   * Data storage is keyed on clock ticks now.
200
2012007-02-03: version 1.3.5
202
203   * Bug fixes.
204   * More tools for editing configuration from within innotop.
205   * Filters and transformations are constrained to valid values.
206   * Support for colorizing rows.
207   * Sorting by multiple columns.
208   * Compress headers when display is very wide.
209   * Stabilize and limit column widths.
210   * Check config file formats when upgrading so upgrades go smoothly.
211   * Make D mode handle many connections at once.
212   * Extract simple expressions from data sets in column src property.
213     This makes innotop more awk-ish.
214
2152007-01-16: version 1.3
216
217   * Readline support.
218   * Can be used unattended, or in a pipe-and-filter mode
219     where it outputs tab-separated data to standard output.
220   * You can specify a config file on the command line.
221     Config files can be marked read-only.
222   * Monitor multiple servers simultaneously.
223   * Server groups to help manage many servers conveniently.
224   * Monitor master/slave status, and control slaves.
225   * Columns can have user-defined expressions as their data sources.
226   * Better configuration tools.
227   * InnoDB status information is merged into SHOW VARIABLES and
228     SHOW STATUS information, so you can access it all together.
229   * High-precision time support in more places.
230   * Lots of tweaks to make things display more readably and compactly.
231   * Column transformations and filters.
232
2332007-01-16: version 1.0.1
234   * NOTE: innotop is now hosted at Sourceforge, in Subversion not CVS.
235     The new project homepage is http://sourceforge.net/projects/innotop/
236   * Tweak default T/Q mode sort columns to match what people expect.
237   * Fix broken InnoDBParser.pm documentation (and hence man page).
238
2392007-01-06: version 1.0
240   * NOTE: innotop is now hosted at Sourceforge, in Subversion not CVS.
241     The new project homepage is http://sourceforge.net/projects/innotop/
242   * Prevent control characters from freaking terminal out.
243   * Set timeout to keep busy servers from closing connection.
244   * There is only one InnoDB insert buffer.
245   * Make licenses clear and consistent.
246
2472006-11-14: innotop 0.1.160, InnoDBParser version 1.69
248   * Support for ANSI color on Microsoft Windows (more readable, compact
249     display; thanks Gisbert W. Selke).
250   * Better handling of $ENV{HOME} on Windows.
251   * Added a LICENSE file to the package as per Gentoo bug:
252     http://bugs.gentoo.org/show_bug.cgi?id=147600
253
2542006-11-11: innotop 0.1.157, InnoDBParser version 1.69
255   * Add Microsoft Windows support.
256
2572006-10-19: innotop 0.1.154, InnoDBParser version 1.69
258   * Add O (Open Tables) mode
259   * Add some more checks to handle incomplete InnoDB status information
260
2612006-09-30: innotop 0.1.152, InnoDBParser version 1.69
262   * Figured out what was wrong with package $VERSION variable: it wasn't
263     after the package declaration!
264
2652006-09-28: innotop 0.1.152, InnoDBParser version 1.67
266   * Make more efforts towards crash-resistance and tolerance of completely
267     messed-up inputs.  If innotop itself is broken, it is now much harder to
268     tell, because it just keeps on running without complaining.
269   * Fix a small bug parsing out some information and displaying it.
270
2712006-09-05: innotop 0.1.149, InnoDBParser version 1.64
272   * Try to find and eliminate any parsing code that assumes pattern matches
273     will succeed.
274
2752006-09-05: innotop 0.1.149, InnoDBParser version 1.62
276   * Make innotop crash-resistant, so I can declare it STABLE finally.
277   * Instead of using SQL conditional comments, detect MySQL version.
278
2792006-08-22: innotop 0.1.147, InnoDBParser version 1.60
280   * Fix some innotop bugs with undefined values, bad formatting etc.
281
2822006-08-19: innotop 0.1.146, InnoDBParser version 1.60
283   * Make innotop handle some unexpected NULL values in Q mode.
284   * Add OS wait information to W mode, so it is now "everything that waits."
285   * Center section captions better.
286   * Make R mode more readable and compact.
287   * Make InnoDBParser parse lock waits even when they've been waiting 0 secs.
288
2892006-08-12: innotop 0.1.139, InnoDBParser version 1.59
290   * Add more documentation
291   * Tweak V mode to show more info in less space.
292   * Fix a bug in G mode.
293
2942006-08-10: innotop 0.1.132, InnoDBParser version 1.58
295   * Handle yet more types of FK error... it will never end!
296   * Handle some special cases when DEADLOCK info truncated
297   * Add a bit more FK info to F mode in innotop
298   * More tests added to the test suite
299
3002006-08-07: innotop 0.1.131, InnoDBParser version 1.55
301   * Fix another issue with configuration
302   * Handle another type of FK error
303
3042006-08-03: innotop 0.1.130, InnoDBParser version 1.54
305   * Fix an issue loading config file
306   * Add heap_no to 'D' (InnoDB Deadlock) mode to ease deadlock debugging.
307
3082006-08-02: innotop 0.1.128, InnoDBParser version 1.54
309   * Parse lock wait information from the TRANSACTION section.
310   * Even more OS-specific parsing... pain in the butt...
311   * Add 'W' (InnoDB Lock Wait) mode.
312   * Fix some minor display issues with statusbar.
313
3142006-08-02: innotop 0.1.125, InnoDBParser version 1.50
315   * Don't try to get references to Perl built-in functions like time()
316   * Handle more OS-specific variations of InnoDB status text
317   * Add some more information to various places in innotop
318
3192006-08-01: innotop 0.1.123, InnoDBParser version 1.47
320
321   * Enhance S and G modes: clear screen and re-print headers
322   * Don't crash when deadlock data is truncated
323   * Make Analyze mode say how to get back to whatever you came from
324   * Display 'nothing to display' when there is nothing
325   * Add ability to read InnoDB status text from a file (mostly helps test)
326   * Add table of Wait Array Information in Row Op/Semaphore mode
327   * Add table of lock information in InnoDB deadlock mode
328   * Ensure new features in upgrades don't get masked by existing config files
329   * Tweak default column choices for T mode
330   * Enhance foreign key parsing
331   * Enhance physical record and data tuple parsing
332   * Enhance lock parsing (handle old-style and new-style formats)
333
3342006-07-24: innotop 0.1.112, InnoDBParser version 1.36
335
336   * InnoDBParser enhancements for FK error messages.
337   * A fix to innotop to prevent it from crashing while trying to display a FK
338     error message.
339   * Some minor cosmetic changes to number formatting in innotop.
340
3412006-07-22: innotop 0.1.106, InnoDBParser version 1.35
342
343   * InnoDBParser is much more complete and accurate.
344   * Tons of bug fixes.
345   * Add partitions to EXPLAIN mode.
346   * Enhance Q mode header, add T mode header.
347   * Share some configuration variables across modes.
348   * Add formatted time columns to Q, T modes.
349   * Add command-line argument parsing.
350   * Turn off echo when asking for password.
351   * Add option to specify port when connecting.
352   * Let display-optimized-query display multiple notes.
353   * Lots of small improvements, such as showing more info in statusbar.
354
3552006-07-02: innotop 0.1.74, InnoDBParser version 1.24
356
357   * Initial release for public consumption.
Note: See TracBrowser for help on using the repository browser.