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