Debian Codegraph @

debian/additions/innotop/changelog.innotop

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