| Bug #85952 | Client Connections breaks for older MySQL dbs | ||
|---|---|---|---|
| Submitted: | 14 Apr 2017 18:43 | Modified: | 17 Apr 2017 14:09 |
| Reporter: | Joe Knize | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Workbench: Administration | Severity: | S2 (Serious) |
| Version: | 6.3.9 | OS: | Windows (Microsoft Windows 7 Enterprise Service Pack 1) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[14 Apr 2017 18:45]
Joe Knize
log file
Attachment: wb.1.log (application/octet-stream, text), 10.96 KiB.
[17 Apr 2017 14:09]
MySQL Verification Team
Hello Joe Knize, Thank you for the report. Please note that MySQL Workbench fully supports MySQL Server versions 5.5 and above. It may work with older server versions, but full functionality is not available then i.e some features take advantage of MySQL server features, and as such, they require more recent versions of MySQL Server. For example, the Performance Dashboard requires MySQL Server 5.6 or higher. Thanks, Umesh

Description: The "Client Connections" functionality is broken when connecting to my db, which is version 5.1.73. It works fine in 6.3.6, but not in 6.3.9. According to the logs, it's trying to use performance_schema.threads, but that doesn't exist in my version of the db. How to repeat: Using 6.3.9, connect to an older MySQL version (maybe anything < 5.6.6), click on Client Connections. Suggested fix: Only use the performance_schema if it's in the database; otherwise, go back to however 6.3.6 is doing it ("show full processlist"?).