forked from innotop/innotop
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Changelog
441 lines (365 loc) · 19 KB
/
Changelog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
Changelog for innotop:
2017-01-20: version 1.11.4
* add SUM function for ONLY_FULL_GROUP_BY
2017-01-20: version 1.11.3
* Undisplay handlersocket's threads in hide_inactive
* fix runtime error regarding redundant sprintf argument #122
* added sort on connection-name in display M, after sql/io running, seconds behind master and channel_name
* fixed bug that removed value for cxn and channel_name columns in display M
* added sort on replication delay, so that the replication-display will sort on slave_sql_running, timelag (in minutes) and channel_name.
* support for MariaDB 10.0 in InnoDB row (issue 93)
2013-07-12: version 1.9.1
Bugs fixed:
* Support of MySQL 5.6 was broken on some pages (issue 82, 83)
* Deadlock clearing transactions is now not included in binary log
(issue 84)
* New spec file with requirements and build requirements for
CentOS/RHEL and Fedora
2012-09-07: version 1.9.0
Changes:
* A new Health Dashboard (A) mode is the default mode.
* Added a new InnoDB Locked (K) mode.
* Added a new 'spark' config variable for sparklines.
* Added a new fuzzy_time formatting function.
* Added "query distill" summarizing.
* Handled more types of errors connecting to the server.
* Displayed some data more compactly.
Bugs fixed:
* Double-quotes were used to terminate strings in SQL (issue 57).
* T mode didn't show InnoDB transaction times (issue 67).
* Killing a query didn't suggest the longest-running one automatically.
* Connections weren't closed on exit (issue 64).
* Q mode didn't have connections in its header (issue 63).
* Connections and server groups were poorly handled (issue 68).
* The RPM spec file was buggy (issue 59).
* Event filters were defined wrong (issue 54).
2012-02-25: version 1.8.1
Bugs fixed:
* Various parsing errors with MySQL 5.5 (issue 23, 45, 47, 51, 52, 53).
* RPM spec file prevented building on CentOS 5.5 using mock (issue 44).
* Tests worked only from the test subdirectory (issue 43).
2010-11-06: version 1.8.0
Changes:
* Don't re-fetch SHOW VARIABLES every iteration; it's too slow on many hosts.
* Add a filter to remove EVENT threads in SHOW PROCESSLIST (issue 32).
* Add a timestamp to output in -n mode, when -t is specified (issue 37).
* Add a new U mode, for Percona/MariaDB USER_STATISTICS (issue 39).
* Add support for millisecond query time in Percona Server (issue 39).
* Display a summary of queries executed in Query List mode (issue 26).
Bugs fixed:
* Made config-file reading more robust (issue 41).
* Hostname parsing wasn't standards compliant (issue 30).
* MKDEBUG didn't work on some Perl versions (issue 22).
* Don't try to get InnoDB status if have_innodb != YES (issue 33).
* Status text from the InnoDB plugin wasn't parsed correctly (issue 36).
* Transaction ID from InnoDB plugin wasn't subtracted correctly (issue 38).
* Switching modes and pressing ? for help caused a crash (issue 40).
2009-09-06: version 1.7.2
Changes:
* add support for --socket
Bugs fixed:
* remove cxn from $meta->{group_by} if there's only one connection displayed
* fix for issue 19 - cxn column won't become visible when viewing two
connections after having viewed one connection
* supress errors resulting from the addition of a 'BACKGROUND THREAD'
section in the output of 'show innodb status'
* possible fix for issue 22 - Useless use of a constant in void context
* small change to set_to_tbl() around hiding the cxn column if there
aren't two or more connections
2009-03-09: version 1.7.1
Changes:
* Don't display the CXN column if only one connection is active in
the current view
* the 'state' column is now visible by default in Query List mode
Bugs fixed:
* fixed bug where trying to aggregate the time column would result
in a crash if the time column had an undef value in it, which is
the case when a thread is in the 'Connect' state
* updated innotop.spec file to reflect current version
2009-02-23: version 1.7.0
Changes:
* supports a central config (/etc/innotop/innotop.conf)
* changed the default home directory config to ~/.innotop/innotop.conf
(away from .ini)
* embedded InnoDBParser.pm into innotop so it can be run with no
installation
* no longer writes a new config file by default
* added --skipcentral (skip reading central config) and --write (write
a config if none were loaded at start-up)
* if no config file is loaded, connect to a MySQL database on
localhost using mysql_read_default_group=client
* embedded maatkit's DSNParser.pm and added support for --user,
--password, --host, --port
* changed default mode from T (InnoDB Transactions) to Q (Query List)
* in addition to connected threads, now displays running and cached
threads in statusbar
* don't load connections from a config file if any DSN information or
a username or password is specified on the command-line
Bugs fixed:
* fixed bug preventing utilization of command-line options that
override default config settings if no config file was loaded
* fixed a bug where migrating from an old version of the config will
delete ~/innotop.ini, if it exists. Now uses File::Temp::tempfile().
2007-11-09: version 1.6.0
* S mode crashed on non-numeric values.
* New user-defined columns crashed upon restart.
* Added --color option to control terminal coloring.
2007-09-18: version 1.5.2
* Added the ability to monitor InnoDB status from a file.
* Changed W mode to L mode; it monitors all locks, not just lock waits.
2007-09-16: version 1.5.1
* Added C (Command Summary) mode.
* Fixed a bug in the 'avg' aggregate function.
2007-09-10: version 1.5.0
Changes:
* Added plugin functionality.
* Added group-by functionality.
* Moved the configuration file to a directory.
* Enhanced filtering and sorting on pivoted tables.
* Many small bug fixes.
2007-07-16: version 1.4.3
Changes:
* Added standard --version command-line option
* Changed colors to cyan instead of blue; more visible on dark terminals.
* Added information to the filter-choosing dialog.
* Added column auto-completion when entering a filter expression.
* Changed Term::ReadKey from optional to mandatory.
* Clarified username in password prompting.
* Ten thousand words of documentation!
Bugs fixed:
* innotop crashed in W mode when InnoDB status data was truncated.
* innotop didn't display errors in tables if debug was enabled.
* The colored() subroutine wasn't being created in non-interactive mode.
* Don't prompt to save password except the first time.
2007-05-03: version 1.4.2
This version contains all changes to the trunk until revision 239; some
changes in revisions 240:250 are included.
MAJOR CHANGES:
* Quick-filters to easily filter any column in any display
* Compatibility with MySQL 3.23 through 6.0
* Improved error handling when a server is down, permissions denied, etc
* Use additional SHOW INNODB STATUS information in 5.1.x
* Make all modes use tables consistently, so they can all be edited,
filtered, colored and sorted consistently
* Combine V, G and S modes into S mode, with v, g, and s hot-keys
* Let DBD driver read MySQL option files; permit connections without
user/pass/etc
* Compile SQL-like expressions into Perl subroutines; eliminate need to
know Perl
* Do not save all config data to config file, only save user's customizations
* Rewritten and improved command-line option handling
* Added --count, --delay, and other command-line options to support
run-and-exit operation
* Improve built-in variable sets
* Improve help screen with three-part balanced-column layout
* Simplify table-editor and improve hotkey support
* Require Perl to have high-resolution time support (Time::HiRes)
* Help the user choose a query to analyze or kill
* Enable EXPLAIN, show-full-query in T mode just like Q mode
* Let data-extraction access current, previous and incremental data sets
all at once
MINOR CHANGES:
* Column stabilizing for Q mode
* New color rules for T, Q, W modes
* Apply slave I/O filter to Q mode
* Improve detection of server version and other meta-data
* Make connection timeout a config variable
* Improve cross-version-compatible SQL syntax
* Get some information from the DBD driver instead of asking MySQL for it
* Improved error messages
* Improve server group creation/editing
* Improve connection/thread killing
* Fix broken key bindings and restore previously mapped hot-keys for
choosing columns
* Some documentation updates (but not nearly enough)
* Allow the user to specify graphing char in S mode (formerly G mode)
* Allow easy switching between variable sets in S mode
* Bind 'n' key globally to choose the 'next' server connection
* Bind '%' key globally to filter displayed tables
* Allow aligning columns on the decimal place for easy readability
* Add hide_hdr config variable to hide column headers in tables
* Add a feature to smartly run PURGE MASTER LOGS in Replication mode
* Enable debug mode as a globally configurable variable
* Improve error messages when an expression or filter doesn't compile or has
a run-time error; die on error when debug is enabled
* Allow user-configurable delays after executing SQL (to let the server
settle down before taking another measurement)
* Add an expression to show how long until a transaction is finished
* Add skip_innodb as a global config variable
* Add '%' after percentages to help disambiguate (user-configurable)
* Add column to M mode to help see how fast slave is catching up to master
BUG FIXES:
* T and W modes had wrong value for wait_status column
* Error tracking on connections didn't reset when the connection recovered
* wait_timeout on connections couldn't be set before MySQL 4.0.3
* There was a crash on 3.23 when wiping deadlocks
* Lettercase changes in some result sets (SHOW MASTER/SLAVE STATUS) between
MySQL versions crashed innotop
* Inactive connections crashed innotop upon access to DBD driver
* set_precision did not respect user defaults for number of digits
* --inc command-line option could not be negated
* InnoDB status parsing was not always parsing all needed information
* S mode (formerly G mode) could crash trying to divide non-numeric data
* M table didn't show Slave_open_temp_tables variable; incorrect lettercase
* DBD drivers with broken AutoCommit would crash innotop
* Some key bindings had incorrect labels
* Some config-file loading routines could load data for things that didn't
exist
* Headers printed too often in S mode
* High-resolution time was not used even when the user had it
* Non-interactive mode printed blank lines sometimes
* Q-mode header and statusbar showed different QPS numbers
* Formulas for key-cache and query-cache hit ratios were wrong
* Mac OS "Darwin" machines were mis-identified as Microsoft Windows
* Some multiplications crashed when given undefined input
* The commify transformation did not check its input and could crash
* Specifying an invalid mode on the command line or config file could crash
innotop
2007-03-29: version 1.4.1
* More tweaks to display of connection errors.
* Fixed a problem with skip-innodb in MySQL 5.1.
* Fix a bug with dead connections in single-connection mode.
* Fix a regex to allow parsing more data from truncated deadlocks.
* Don't load active cxns from the config file if the cxn isn't defined.
2007-03-03: version 1.4.0
* Further tweak error handling and display of connection errors
* More centralization of querying
* Fix forking so it doesn't kill all database connections
* Allow user to run innotop without permissions for GLOBAL variables and status
2007-02-11: version 1.3.6
* Handle some connection failures so innotop doesn't crash because of one server.
* Enable incremental display in more modes.
* Tweaks to colorizing, color editor, and default color rules.
* Tweaks to default sorting rules.
* Use prepared statements for efficiency.
* Bug fixes and code cleanups.
* Data storage is keyed on clock ticks now.
2007-02-03: version 1.3.5
* Bug fixes.
* More tools for editing configuration from within innotop.
* Filters and transformations are constrained to valid values.
* Support for colorizing rows.
* Sorting by multiple columns.
* Compress headers when display is very wide.
* Stabilize and limit column widths.
* Check config file formats when upgrading so upgrades go smoothly.
* Make D mode handle many connections at once.
* Extract simple expressions from data sets in column src property.
This makes innotop more awk-ish.
2007-01-16: version 1.3
* Readline support.
* Can be used unattended, or in a pipe-and-filter mode
where it outputs tab-separated data to standard output.
* You can specify a config file on the command line.
Config files can be marked read-only.
* Monitor multiple servers simultaneously.
* Server groups to help manage many servers conveniently.
* Monitor master/slave status, and control slaves.
* Columns can have user-defined expressions as their data sources.
* Better configuration tools.
* InnoDB status information is merged into SHOW VARIABLES and
SHOW STATUS information, so you can access it all together.
* High-precision time support in more places.
* Lots of tweaks to make things display more readably and compactly.
* Column transformations and filters.
2007-01-16: version 1.0.1
* NOTE: innotop is now hosted at Sourceforge, in Subversion not CVS.
The new project homepage is http://sourceforge.net/projects/innotop/
* Tweak default T/Q mode sort columns to match what people expect.
* Fix broken InnoDBParser.pm documentation (and hence man page).
2007-01-06: version 1.0
* NOTE: innotop is now hosted at Sourceforge, in Subversion not CVS.
The new project homepage is http://sourceforge.net/projects/innotop/
* Prevent control characters from freaking terminal out.
* Set timeout to keep busy servers from closing connection.
* There is only one InnoDB insert buffer.
* Make licenses clear and consistent.
2006-11-14: innotop 0.1.160, InnoDBParser version 1.69
* Support for ANSI color on Microsoft Windows (more readable, compact
display; thanks Gisbert W. Selke).
* Better handling of $ENV{HOME} on Windows.
* Added a LICENSE file to the package as per Gentoo bug:
http://bugs.gentoo.org/show_bug.cgi?id=147600
2006-11-11: innotop 0.1.157, InnoDBParser version 1.69
* Add Microsoft Windows support.
2006-10-19: innotop 0.1.154, InnoDBParser version 1.69
* Add O (Open Tables) mode
* Add some more checks to handle incomplete InnoDB status information
2006-09-30: innotop 0.1.152, InnoDBParser version 1.69
* Figured out what was wrong with package $VERSION variable: it wasn't
after the package declaration!
2006-09-28: innotop 0.1.152, InnoDBParser version 1.67
* Make more efforts towards crash-resistance and tolerance of completely
messed-up inputs. If innotop itself is broken, it is now much harder to
tell, because it just keeps on running without complaining.
* Fix a small bug parsing out some information and displaying it.
2006-09-05: innotop 0.1.149, InnoDBParser version 1.64
* Try to find and eliminate any parsing code that assumes pattern matches
will succeed.
2006-09-05: innotop 0.1.149, InnoDBParser version 1.62
* Make innotop crash-resistant, so I can declare it STABLE finally.
* Instead of using SQL conditional comments, detect MySQL version.
2006-08-22: innotop 0.1.147, InnoDBParser version 1.60
* Fix some innotop bugs with undefined values, bad formatting etc.
2006-08-19: innotop 0.1.146, InnoDBParser version 1.60
* Make innotop handle some unexpected NULL values in Q mode.
* Add OS wait information to W mode, so it is now "everything that waits."
* Center section captions better.
* Make R mode more readable and compact.
* Make InnoDBParser parse lock waits even when they've been waiting 0 secs.
2006-08-12: innotop 0.1.139, InnoDBParser version 1.59
* Add more documentation
* Tweak V mode to show more info in less space.
* Fix a bug in G mode.
2006-08-10: innotop 0.1.132, InnoDBParser version 1.58
* Handle yet more types of FK error... it will never end!
* Handle some special cases when DEADLOCK info truncated
* Add a bit more FK info to F mode in innotop
* More tests added to the test suite
2006-08-07: innotop 0.1.131, InnoDBParser version 1.55
* Fix another issue with configuration
* Handle another type of FK error
2006-08-03: innotop 0.1.130, InnoDBParser version 1.54
* Fix an issue loading config file
* Add heap_no to 'D' (InnoDB Deadlock) mode to ease deadlock debugging.
2006-08-02: innotop 0.1.128, InnoDBParser version 1.54
* Parse lock wait information from the TRANSACTION section.
* Even more OS-specific parsing... pain in the butt...
* Add 'W' (InnoDB Lock Wait) mode.
* Fix some minor display issues with statusbar.
2006-08-02: innotop 0.1.125, InnoDBParser version 1.50
* Don't try to get references to Perl built-in functions like time()
* Handle more OS-specific variations of InnoDB status text
* Add some more information to various places in innotop
2006-08-01: innotop 0.1.123, InnoDBParser version 1.47
* Enhance S and G modes: clear screen and re-print headers
* Don't crash when deadlock data is truncated
* Make Analyze mode say how to get back to whatever you came from
* Display 'nothing to display' when there is nothing
* Add ability to read InnoDB status text from a file (mostly helps test)
* Add table of Wait Array Information in Row Op/Semaphore mode
* Add table of lock information in InnoDB deadlock mode
* Ensure new features in upgrades don't get masked by existing config files
* Tweak default column choices for T mode
* Enhance foreign key parsing
* Enhance physical record and data tuple parsing
* Enhance lock parsing (handle old-style and new-style formats)
2006-07-24: innotop 0.1.112, InnoDBParser version 1.36
* InnoDBParser enhancements for FK error messages.
* A fix to innotop to prevent it from crashing while trying to display a FK
error message.
* Some minor cosmetic changes to number formatting in innotop.
2006-07-22: innotop 0.1.106, InnoDBParser version 1.35
* InnoDBParser is much more complete and accurate.
* Tons of bug fixes.
* Add partitions to EXPLAIN mode.
* Enhance Q mode header, add T mode header.
* Share some configuration variables across modes.
* Add formatted time columns to Q, T modes.
* Add command-line argument parsing.
* Turn off echo when asking for password.
* Add option to specify port when connecting.
* Let display-optimized-query display multiple notes.
* Lots of small improvements, such as showing more info in statusbar.
2006-07-02: innotop 0.1.74, InnoDBParser version 1.24
* Initial release for public consumption.