Changelog

Version 4.1.2 (Jan 26, 2022)

  • Updated SSL compatibility.

Version 4.1.1 (Dec 16, 2021)

  • Fixes potential error when splash screen is dismissed early.

Version 4.1.0 (Nov 25, 2021)

  • SSL support.
  • Removed detachable toolbar.
  • Escape closes window dialogs.
  • About dialog now works correctly on Windows.
  • Live transactions work on machines that do not store transaction history.
  • Increased caches sizes for improved performance on large amounts of data.

Version 4.0.9 (Oct 21, 2021)

  • Fixed issue where "explain" would retain connections.

Version 4.0.8 (Oct 14, 2021)

  • Updated SSH libraries for better compatibility.

Version 4.0.7 (May 15, 2021)

  • Add noSSL=true by default.

Version 4.0.6 (Oct 11, 2020)

  • Updated DB driver to fix issue with connect for some setups.

Version 4.0.5 (Aug 5, 2020)

  • New SSH library.

Version 4.0.4 (Jul 24, 2020)

  • Updated DB drivers.

Version 4.0.3 (May 8, 2020)

  • Fixed issue with enterprise version preventing multiple instances from running.

Version 4.0.2 (Dec 14, 2019)

  • Updated DB drivers to support the latest MySQL authentication methods.

Version 4.0.1 (Oct 4, 2019)

  • Linux installs now provide their own Java version

Version 4.0.0 (Sep 14, 2019)

  • Live Threads View with currently active threads.
  • View tables sizes (may lag up to 24h in MySQL 8.0+ depending on information_schema_stats_expiry)
  • Enterprise version: Live Transactions view to view currently running transactions. (MySQL 5.6+ only)
  • Enterprise version: Added "save to CSV"-functionality for all tabs.
  • Updated DB drivers
  • Spanish translation
  • Fixed bug #116 - Refuses to connect to servers started with --skip-grant-tables
  • Fixed bug #16 - Query ratings aren't propagated from Top Queries to Slow Queries
  • Fixed bug #117 - Fails to parse queries with backticks in the select clause.
  • Fixed bug #121 - Fails to launch on Java 10.
  • Fixed bug #119 - Fails to connect to some Windows Azure hosted instances due to outdated db driver.
  • Fixed bug #114 - Stopping a long/unstable recording leads to gui locking - stopping, idle, jumps back to recording and an hourglass is shown.
  • Removed support for MySQL 4.1 and below.

Version 3.0.10 (Mar 19, 2013)

  • Fixed bug #115 - NullPointerException when explaining queries without WHERE-clause on index-less tables.

Version 3.0.9 (Mar 3, 2013)

  • Sometimes you want to exclude certain queries from statistics. We therefore added a quick way to do this. To make Jet Profiler ignore certain queries, you need to edit the original query in the application code. Start the query with /*jp-ignore*/ (no spaces), for example "/*jp-ignore*/ SELECT ... FROM ..." This will make the query not show up in Top Queries and the other tabs. Note that the query will still affect general preset statistics, such as number of threads running and threads busy. Also make sure that your mysql client library preserves comments - some libraries including the mysql command line client removes comments by default.
  • Faster data retrieval.
  • Fixed bug #110 - On rare occasions, fails to display data due to overlapping times in recorded data.
  • Fixed bug #111 - NullPointerException when explaining some selects (rare).
  • Fixed bug #112 - Exiting while still recording could lead to NullPointerException error message.
  • Fixed bug #113 - Becomes unresponsive if (re)connection fails while checking for the current thread id (java.lang.Long cannot be cast to java.lang.String).

Version 3.0.8 (Feb 10, 2013)

  • Fixed bug #101 - Bad error message when entering an invalid port number and clicking test connection.
  • Fixed bug #102 - NullPointerException if clicking Record when no bookmark has been selected, or when the bookmark does not exist. The fallback is the default connection to localhost.
  • Fixed bug #108 - All windows get the same title (servername) as per last started one, even though they are all named differently.
  • Fixed bug #109 - Explain stops working for all windows but the last one, because they are using the last connection made (by the last app started), returning error "unknown database".

Version 3.0.7 (Feb 3, 2013)

  • Better error message when trying to run in a headless environment (without display).
  • Fixed bug #98 - Fails to start recording if database connection is dropped precisely then.
  • Fixed bug #106 - Recording fails when encountering invalid utf-8 characters in very long queries.
  • Fixed bug #107 - New jdbc driver produces undocumented errors during sudden disconnect, preventing automatic reconnect.

Version 3.0.6 (Jan 23, 2013)

  • Updated MySQL JDBC driver to fix issue with general statistics not getting read correctly (Conns, Temp Tables and some more).

Version 3.0.5 (Jan 19, 2013)

  • Fixed bug #105 - Explaining queries which use index merge failed with new db driver.

Version 3.0.4 (Jan 17, 2013)

  • Showing name of connection in title bar to make it easier to distinguish between multiple instances.
  • New, more efficient MySQL JDBC driver from SkySQL / MariaDB.
  • Top Schemas now available in the free version by default.
  • Faster startup time.
  • Fixed bug #103 - Sometimes wrong error message when trying to run multiple instances and the database file is locked.
  • Fixed bug #104 - Loading big projects might fail when running multiple instances.

Version 3.0.3 (Dec 7, 2012)

  • Improved Japanese translation.
  • Fixed layout issues with html reports in Internet Explorer.
  • Fixed bug #52 - Too small chart fonts on Windows Vista Hebrew locale
  • Fixed bug #95 - In case of missing privileges, the snippet with suggested additional grants lacked a quote sign and had to be corrected manually.
  • Fixed bug #96 - Improved error handling when disk is not writable.
  • Fixed bug #97 - Wrong error message when entering invalid ssh port number

Version 3.0.2 (Dec 5, 2012)

  • Improved handling of empty queries.

Version 3.0.1 (Dec 3, 2012)

  • Fixed bug #93 - Stopping quickly before recording has started properly causes hanging.
  • Fixed bug #94 - Connection bookmarks with empty names failed to record.

Version 3.0.0 (Nov 30, 2012)

  • SSH Tunneling - you can now connect to remote database servers using SSH tunneling, a convenient time-saver. Choose between password- or key-based ssh2 authentication.
  • Japanese translation
  • HTML Reports - to help you in saving and sharing the profiling results, you can save an html report containing the top queries and the presets.
  • Enterprise version: Added support for multiple instances. You can now run many instances of Jet Profiler simultaneously in order to record from many databases at once.
  • Enterprise version: Added support for command-line scheduling. You can automate recording by running Jet Profiler as a scheduled job (e.g. cron job). Example:
  • Recovery of previous unsaved work will now occur automatically on startup. A new command line option --skip-recovery has been added in case you wish to skip recovery on startup.
  • Explain dialog always shown even if the query was not explainable. You can now edit the query and retry the explain command.
  • Explain is now available from the main menu.
  • New h2 database version.
  • Improved memory management for large result sets.
  • The SHOW VIEW grant is also required in order for proper explains of views.
  • Improved error message when more grants are required and now showing a text area for easy copy and paste.
  • Increased memory allocation to 384 Mb to support larger data volumes.
  • Fixed bug #78 - Improved reconnect handling when connection is lost.
  • Fixed bug #79 - Error dialog fills whole screen during explain with long queries.
  • Fixed bug #80 - Application sometimes hangs or crashes after hiding splash screen on MacOSX.
  • Fixed bug #90 - Bad table font rendering on Linux in some languages.
  • Fixed bug #91 - Hangs during splash-screen when using Java 7, caused by deadlock in third-party library.
  • Fixed bug #92 - Couldnt handle more than 32768 sql states. For some database versions, there can be a very large number of states.

Version 2.0.5 (Dec 9, 2011)

  • French translation.
  • Added support for explaining CREATE TABLE ... AS SELECT ... queries by just explaining the SELECT part
  • Fixed bug #85 - Rare error during recording when system time is adjusted

Version 2.0.4 (Oct 27, 2011)

  • Added internal checkpointing to reduce amount of temporary files created.
  • Speed enhancements to query parser.
  • Fixed bug #33 - Out of Memory when dealing with LOTS of long queries.

Version 2.0.3 (Oct 16, 2011)

  • Fixed bug #88 - Hangs when closing project file with file old format containing large queries (lobs). This would cause subsequent recovery to fail repeatedly.

Version 2.0.2 (Sep 28, 2011)

  • Fixed bug #77 - Negative spikes appear in statistics, e.g. bytes sent and innodb_data_read. This was caused by the underlying MySQL status var value being a uint which wraps during heavy load.
  • Fixed bug #82 - StackOverFlowError when parsing long leading comments in queries.
  • Fixed bug #84 - Query examples sometimes disappear after data flushing.

Version 2.0.1 (Sep 12, 2011)

  • Improved memory management.
  • Fixed bug #81 - Rare error when parsing complex SELECT queries.

Version 2.0.0 (Aug 29, 2011)

  • German and Swedish translation.
  • Multi-language support. Dates and numbers will be formatted according to the chosen language.
  • Top IPs statistics - these will show you what client ips are the heaviest. This is useful in multi-host environments, for instance if you have multiple web servers using one single database. The statistics are available both as a preset for the line chart and in a top list on the lower part of the screen.
  • Adjustable data retention. You can now tune how long Jet Profiler shall retain the recorded data before deleting it. A typical scenario would be to keep the last couple of hours or days so you can monitor a running server continuously without running out of disk space or memory.
  • Added links to see the normalized and example queries in a popup dialog in the query top lists. Query tool tip texts were removed for cleaner usability.
  • Removed displaying of milliseconds on the linechart x-axis for cleaner look.
  • New splash screen.
  • New h2 database version.
  • Fixed bug #69 - The chart showing profiling cost could show slightly incorrect figures when connection was not stable.
  • Fixed bug #70 - Line breaks in queries could prevent the explain from working.
  • Fixed bug #73 - Bad error message when trying to save to a write-protected file

Version 1.0.8 (Feb 22, 2010)

  • No longer requires Administrator rights for Windows Vista / Windows 7. The only time it is needed is during software updates. (This features is only available on new installations.)
  • On Mac and Linux, user data is now stored in the home folder. (This features is only available on new installations.)
  • Added 32-bit Mac support on Mac OS X 10.6 Snow Leopard.
  • Added reminder message when license is about to expire.
  • Reduced internal database log size from 70M to 4M which makes saved project files significantly smaller.
  • Fixed bug #67 - Software updates fails on Windows in some situations, related to slow network responses.
  • Fixed bug #68 - Top Tables tab wont always show all tables that are being used. This can happen if the tables have very low usage.
  • Fixed bug #72 - Memory leak in pie chart painting leading to OutOfMemoryErrors during prolonged running (days).

Version 1.0.7 (Nov 9, 2009)

  • Informing when recording is slow. When the db server that you are recording from won't respond in time, a message will be shown in the status bar. Typically, this might happen if the server is very loaded, or if you have extremely high ping times to the server. In this situation, Jet Profiler will skip samples until it catches up again, meaning you will miss some statistics. It is recommended that you increase the polling interval if this happens repeatedly.
  • Fixed a potential memory leak during high load. Jet Profiler temporarily stores recorded data in an internal queue before writing it to disk. If there are a lot of extremely long queries, the disk writing might fall temporarily behind, causing the queue to grow. This could in extreme cases lead to out of memory errors once the queue grew big enough. Jet Profiler will now detect this and discard data until it catches up. A warning message will be shown in the status bar. It is recommended that you increase the polling interval if this happens repeatedly.
  • Enabled profiling when using big hosting providers. On many hosting providers, such as hostgator, you will only get database accounts with limited privileges. Jet Profiler now supports this, although the profiling results will be limited. This will enable you to roughly compare your own queries against each other. However, if the machine is under heavy load by some other user, you will get biased results. See documentation for more information.
  • Better error message when using an outdated JDBC driver on Mac OS X.
  • Fixed bug #64 - NullPointerException on Mac OS X when using filter boxes
  • Fixed bug #65 - Rare NullPointerException for tooltips in some situations
  • Fixed bug #66 - NullPointerException during rendering of the black and red Threads bar (rare)

Version 1.0.6 (Oct 29, 2009)

  • Clicking a rating now brings up the explain dialog directly (used to only work for queries which had not yet been explained).
  • Fixed bug #36 - Explain did not work for (SELECT ...) UNION (SELECT ...).
  • Fixed bug #62 - Occasional tooltip problems when recording due to race condition. (ArrayOutOfBoundsException -1)
  • Fixed bug #63 - Occasional tooltip problems when recording due to Swing JRE bug http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6219960 (NullPointerException)

Version 1.0.5 (Oct 22, 2009)

  • Optimized internal caching for better write performance during large recordings. Also limited caching to avoid some memory problems.
  • Optimized internal retrieval speed for top lists.
  • Leading comments are now removed from queries during normalization.
  • Explain window position and size is remembered.
  • Explain raw output is now displayed in a table.
  • Support for arbitrarily large join size values.
  • Better handling of perpetual and trial licenses.
  • New version of internal database engine and graph engine.
  • Fixed bug #53 - Chart selection is very slow on some Windows configurations. This was caused by a JVM bug with some graphics hardware accelerators.
  • Fixed bug #58 - Failed to record from databases in rare occasions when no thread id could be obtained via SELECT CONNECTION_ID().
  • Fixed bug #48 - Couldn't handle more than 32767 tables.
  • Fixed bug #50 - State NULL falsely recorded as empty string.
  • Fixed bug #51 - Failed to record on MySQL-5.1.34 slave when server times differ. (Time column in SHOW PROCESSLIST can contain very large values due to unsigned 32-bit int in some MySQL versions)
  • Fixed bug #47 and #56 - Explain cant handle leading comments in query.
  • Fixed bug #49 - Hangs for five minutes when download fails (too high connection timeout). Only checks for updates once, even on errors.
  • Fixed bug #59 - Support for longer user names
  • Fixed bug #60 - Failed to save/load projects containing more than 255 queries with a normalized length of more than 1024 characters. The error message when loading was 'File not found: ...1.lobs.db/NNN.t65.lob.db'. This was caused by h2 database bug.
  • Fixed bug #61 - Rare NullPointerException when having connection problems on MacOSX.
  • Fixed bug #55 - Explain join size calculations are incorrect for DERIVED tables.
  • Fixed bug #54 - Query normalization not fully working with negative number parameterisation.

Version 1.0.4 (Mar 9, 2009)

  • Fixed bug #12 - Crashes when pointed at a slave - org.h2.jdbc.JdbcSQLException: Value too long for column NAME: 'Has read all relay log; waiting for the slave I/O thread to update it' again.

Version 1.0.3 (Mar 6, 2009)

  • Reduced max query length from 5MB to 1MB in order to avoid OutOfMemory problems due to too long queries.
  • Small adjustments of Explain Dialog appearance.
  • Fixed bug #41 - Save As was broken on Mac.
  • Fixed bug #42 - Save As prompts for overwrite existing files twice on Mac.
  • Fixed bug #43 - Explain dialog returns error message StringIndexOutOfBoundsException on some DELETE queries.
  • Fixed bug #44 - On rare occassions stops recording from slave servers running LOAD DATA INFILE commands. Caused by limit of 127 processlist states.
  • Fixed bug #45 - It was not possible to specify empty username when connecting as anonymous user.

Version 1.0.2 (Mar 3, 2009)

  • QUERY FILTERING - The top queries, slow queries and locked queries tabs can now be filtered. Enter your filter text and filter for queries containing SELECT, certain users etc. You can also use Java regular expressions.
  • MAC LOOK AND FEEL - A number of features have been improved for better Mac experience. The preset buttons have a new look and feel since the default push button style would take up too much space. The menu has moved to the top of the screen in true Mac style, and the About and Quit commands are now in the application menu. The application name now says "Jet Profiler for MySQL". Save and load file dialogs are better. The close window icon can now show a document modified indicator.
  • 6 NEW PRESETS:
  • QCache preset - A preset showing the query cache hit rate. Useful to tune your query cache usage.
  • Scans preset - A preset showing the percentage of full table scans. Useful to see ratio of indexed vs bad queries.
  • MyISAM cache preset - A preset showing the hit rate of the MyISAM key cache. Useful to reduce MyISAM disk reads.
  • Innodb cache preset - A preset showing the hit rate of the Innodb buffer pool cache, used for indices and data. Useful to reduce Innodb disk io.
  • Temp tables preset - A preset showing the percentage of temporary tables going to disk. Useful to tune GROUP BY and ORDER BY queries.
  • Cons preset - A preset showing established connections per user. Useful to tune connection pools in your applications.
  • Improved Connection Settings Dialog - The Connection Settings Dialog is now popped on startup for convenience. A record button has been added which is preselected.
  • Mac dmg installer - A real dmg installer is available. For versions 1.0.1 and older, a reinstall is needed.
  • New glossy icon - The icon has been redesigned, hope you like it.
  • Improved slave preset - The Slave preset now shows load figures in percentages from 0 to 100 for easier interpretation.
  • Improved detection of locked queries by using more internal MySQL states - Locked, Waiting for table(s), System lock, Table lock and User lock.
  • Changed locks preset - The locks preset now shows Threads locked vs Threads_running since this is a more interesting measure than the previous one. The old values Innodb_row_lock_current_waits and Table_locks_waited can still be accessed using the Line Chart Settings button in the toolbar.
  • Using eventbus.jar internally for decoupling of code.
  • Fixed bug #34 - MySQLDataException on servers with extremely high thread ids, cannot connect ok.
  • Fixed bug #35 - Connection problems during software updates takes 1 minute due to too long timeout value.
  • Fixed bug #37 - Software update fails on Mac and Linux when program path contains whitespace.
  • Fixed bug #38 - Changelog Dialog would not resize correctly.
  • Fixed bug #39 - Preset Slaves would not show slaves reading properly.

Version 1.0.1 (Feb 9, 2009)

  • Query Rating icons changed so more than one flag can be displayed.
  • Free version now shows the top 1 query without masking it out, making the free version more useful. Queries 2-5 are still masked out.
  • Fixed bug #30 - Line Chart Settings dialog Smooth slider look and feel on Windows
  • Fixed bug #31 - Explain Dialog doesn't resize correctly.
  • Fixed bug #32 - Chart items sometimes do not display correctly when switching between projects.

Version 1.0.0 (Feb 3, 2009)

  • CONNECTION BOOKMARKS - Added connection bookmarks so you can save connection information for later. Especially useful when you have a lot of servers.
  • NEW SOFTWARE PATCHER - Due to bugs in the software update mechanism, some updates did not work on Windows. The installer and software update mechanism has been rewritten to work in the same way on all operating systems and to work for all files. For Windows users, this version requires a reinstall of the program since the update is broken.
  • IMPROVED MAC LAUNCHER - For Mac OS X, automatic java detection takes place and selects the right java version. It is no longer necessary to edit the java preferences. In addition, there are better error messages in case the OS / architecture is not supported (MacOSX 10.5 or newer on Intel 64 bit is required).
  • FIRST PUBLIC RELEASE - Registration keys are no longer mandatory, as the application now has a free version mode. In the free version all features are not available.
  • Improved logging - The log files now contain more information about versions and software updates. This makes it easier to troubleshoot any problems.
  • Toolbar looks better on Vista.
  • Automatic prompting to clean data when connection is changed.
  • Registration no longer mandatory. When not registering, the software runs in free version.
  • New license agreement.
  • Fixed bug #27 - Software updates not working on Windows when updating exe files.
  • Fixed bug #28 - Manual registration dialog prompts user again and again in some cases.
  • Fixed bug #29 - White background in some toolbar buttons on Vista

Version 0.9.13 (Jan 27, 2009)

  • TOTAL TIME INFORMATION - An estimated total time column has been added to Top Queries, Top Users, Slow Queries and Top Locked Queries. This is an estimation of how many seconds the query has run in total.
  • LINE CHART SETTINGS - A separate dialog makes it easy to pick and order what items to display in the line chart. This is accessed using the line chart settings button in the toolbar. This replaces the drop down combo boxes below the preset buttons.
  • ONLINE DOCUMENTATION - A long online documentation has been added to the website. It is accessible from the Help menu.
  • New icons - New, beautiful icons in the toolbar. Two icons have also been added to access connection and recording settings. The rating icons (for EXPLAIN) are also new.
  • Improved performance by 30% - The SHOW STATUS command is the heaviest polling command issued by Jet Profiler (due to MUTEX:es inside MySQL). Since it provides incremental counters, the polling can be reduced without losing much information. Therefore, this command is now only issued every 4th - 5th poll. This reduces the profiling overhead on MySQL by approx 30%.
  • Improved Windows Vista compatibility - The application requires running as an administrator on Microsoft Windows Vista. This is now done automatically.
  • Line chart smoothing - Smoothing is added to the line chart per default (adjustable in the Line chart settings dialog). Smoothing helps identify trends in the data, especially when the underlying data is very uneven (such as States information).
  • Using https for server communication for increased security.
  • Status message changed to the more appropriate Status: recording (was Status: running).
  • All dialogs now use the Jet Profiler icon.
  • Fixed bug #24 - Handler_read_prev always shows 0. Logging was missing on some status variables such as Handler_read_prev.
  • Fixed bug #25 - The thread preset button didn't get properly selected when opening a new project.
  • Fixed bug #26 - OutOfMemory when dealing with really long queries. If a query is more than 5 megs, it will now get truncated. The text /* TRUNCATED */ will appear after the third word in the query.

Version 0.9.12 (Jan 14, 2009)

  • NEW CHART LOOK AND FEEL - The charts have got a new look and feel with nicer colors and gradient filling. The top list tables contain color symbols corresponding to the pie chart colors.
  • BETTER EVALUATION VERSION - Evaluation version no longer has 10 minute limitation. Instead, the top 3 queries are masked. Previously hidden professional features are now shown, but with teaser text to get professional version.
  • SCALABILITY - Faster and leaner when having lots of data.
  • The preset buttons are now toggle buttons, so they stay down when you select a preset.
  • Removed storing of line chart values of 0.0, since this is implicit. This can reduce the total project size by 75%, as well as increasing gui performance.
  • To avoid infinite repainting loops during high load, a back-off delay has been added. The higher the load, the less frequent repainting.
  • New About dialog.
  • New license agreement.
  • Added third_party_licenses.txt documentation to clarify under which licenses that the contained third party libraries are distributed.
  • The more appropriate terms registration and registration key are now used instead of the outdated activation and activation key.
  • Feedback in statusbar during save and load operations, since these can be lenghty on big projects.
  • New h2 database version.
  • Fixed bug #9 - Out of memory after long running. The line chart data is now downsampled to make drawing faster (max 500 values are picked). This prevents OutOfMemory errors when having LOTS of data.
  • Fixed bug #18 - Connection Settings dialog looks bad on Mac, buttons were not completely visible.
  • Fixed bug #23 - Console error message on linux after downloading updates.

Version 0.9.11 (Dec 17, 2008)

  • Fixed bug #22 - Software update too frequent. It couldn't make a proper diff between current version and updates, because the file list contained duplicates.
  • Fixed bug #21 - Software update shows errors when cppatch is changed, due to chicken and egg problem (linux)

Version 0.9.10 (Dec 17, 2008)

  • OFFLINE ACTIVATION - The software can now be manually activated, which removes the need for an internet connection. This is useful if you want to install the software in restricted environments, such as secure LANs. Please note that automatic software updates will not work in such environments.
  • INCREASED MEMORY ALLOCATION - Increased memory allocation to avoid unnecessary out of memory errors. Memory usage is now included in crash information.
  • Automatic license revalidation when expiring.
  • Updated patcher to support updates of executables on linux/mac
  • Better error messages when connection fails. Better distinction between failed to connect and failed to log in.
  • Fixed bug #17 - Got rid of log warnings for HttpMethodBase
  • Fixed bug #19 - Explain not working on MySQL 3.23 and 4.0 (Error: Column id not found).
  • Fixed bug #20 - Connection never times out against stalled server, program hangs.

Version 0.9.9 (Dec 9, 2008)

  • QUERY EXAMPLES - Added query examples for all queries, which are visible in the tooltip when you hoover over a query item (in the Top Queries, Slow Queries and Locked Queries tabs). This gives more accurate results from explain. Previously, queries were only stored in normalized form (e.g. SELECT x FROM y WHERE a=?). Now, the slowest examples of every query is stored. Also, ALL slow queries are stored in example form.
  • QUERY RATINGS - Added query rating based on EXPLAIN. The rating will tell you if the query used full table scans, full index scans, temporary tables, filesorting and the total join size. This is illustrated with a set of rating icons visible next to the query.
  • IMPROVED EXPLAIN - Explain now works for DELETEs, UPDATEs, DOs and INSERT..SELECT queries in addition to normal SELECT statements. This is done by first converting the UPDATE/DELETE/etc to a SELECT and then explaining it. It can handle most queries, except when it comes to subqueries. Plain INSERTs aren't supported either, since there is no SELECT equivalent.
  • Added link to forums in help menu.
  • Long operations, such as load and save, now show a waiting mouse cursor to improve user feedback.
  • Default recording settings are now kept between projects.
  • Tooltips for queries are now colored yellow to make them stand out more.
  • Fixed bug where unexpected errors would sometimes go unnoticed. Now, a dialog will always show when an unexpected error occurs. The bug was introduced in v0.9.7.
  • Fixed bug where delete selection would leave garbage line chart until refreshed.
  • Fixed bug concerning null values in internal db layer.
  • fixed bug #13 - Fails to exit after downloading updates.
  • fixed bug #14 - Clear items button fails to clear chart info text, which is misleading.
  • Fixed big #15 - Recording Settings preset dropdown not updating properly.

Version 0.9.8 (Nov 24, 2008)

  • SLAVE PROFILING - Added support for profiling replication slave nodes. A preset shows if the I/O thread is busy or idle, and if the slave sql thread is busy or idle.
  • MASTER PROFILING - Added support for profiling replication master nodes. A preset shows how many slaves are connected, and if they are currently reading from binlogs.
  • Slightly improved explain dialog with reworked layout and explanation of the type attribute.
  • Showing activation key window on startup to make sure users don't forget to activate the software.
  • Fixed bug #12 - Crashes when pointed at a slave - org.h2.jdbc.JdbcSQLException: Value too long for column NAME
  • Fixed bug #8 - ArrayIndexOutOfBoundsException when trying to copy from TopQueries without selecting something first.
  • Fixed bug #11 - License and changelog text areas should start displaying at top instead of bottom.

Version 0.9.7 (Nov 18, 2008)

  • THREAD LOAD BARS - Colored bars added to top list tables, making it easier to compare the different items. The bar indicates the avg thread load per query / table / user.
  • EXPERIMENTAL EXPLAIN - Experimental explain feature added to query lists, available using right-click popup menu. This explains the query execution plan, indicating if the query is considered efficient or not. The query join steps are shown in a graphical diagram.
  • SAVE/LOAD - Save/load support added. You can now save your recordings for later use and comparison.
  • OVERLOAD DETECTION - Added a check to prevent overloading stalled servers. If polling lags behind due to slow servers, it will skip polling in order to catch up.
  • New version of internal database engine, h2.
  • Line chart optimized for faster painting.
  • Small changes in the tool tip shown on queries; truncated if query is too long, and only appears when over the query column.
  • Internal threading completely rewritten using Foxtrot framework to avoid swing threading problems.
  • Fixed bug #6 - Slow_queries_running gets stuck at 1 sometimes.
  • Fixed bug #7 - Zooming in infinitely on the line chart caused graphic noise.

Version 0.9.6 (Oct 29, 2008)

  • HELP TEXTS - Added help texts for the line chart and for the tabs. This helps explain the different metrics and data shown.
  • RECORDING SETTINGS - You can now adjust the recording settings such as the poll interval. This allows for more flexible polling, for instance, if the MySQL database has very low load.
  • SOFTWARE UPDATE INFO - Added more info button during updates. You can now see the changes included in the download.
  • SLOW QUERIES RUNNING METRICS - Added Slow_queries_running information to the Threads presets, so you easily can get a grasp of the slow query situation.
  • Recording time is now shown in the status bar.
  • Moved Top Queries to be the first tab, since this is the first thing to look for.
  • Corrected Threads_running not to include Jet Profiler itself. An idle db will now show 0 Threads_running instead of 1, which is what we want. JP should not "distort" results.
  • Removed unnecessary jar file updates, so update sizes will be smaller. Some jars would get updated all the time due to mtime being updated during build.
  • Redirecting stdout and stderr to log file to get less verbose output from command line.
  • Profiling cost is more detailed so you can see the different commands and their costs.
  • Fixed ctrl-c when copying tables containing simplified queries
  • Fixed bug #4 - Couldn't profile MySQL 3.23.57
  • Fixed bug #5 - Internal db sequences werent restarted when project was deleted.

Version 0.9.5 (Oct 24, 2008)

  • Fixed bug #2 - Stats item drop downs didn't update correctly
  • Fixed bug #3 - Can now check grants on MySQL 4.0.26

Version 0.9.4 (Oct 23, 2008)

  • Fixed bug #1 - Couldn't profile MySQL 4.1.16

Version 0.9.3 (Oct 23, 2008)

  • First beta release.