The following walkthrough describes how to control user sessions. You will learn how to view session information, stop query execution and disconnect sessions.
In order to complete this walkthrough, you will need to use access MySQL server 5.0.13 or higher.
Execute the following query.
SELECT * FROM demobase.emp e1, demobase.emp e2, demobase.emp e3, demobase.emp e4, demobase.emp e5
To do this, perform the following steps:
To call the Session Manager, on the Fusion menu, point to MySQL, and then click Session Manager.
If you have the global PROCESS privilege, you will see all user sessions for the current connection. Otherwise, you will see only your own sessions.
Click the Host column caption to order all data by host. Find your connections (from your host). Then click on the connection which has Query in the Command column. In the bottom part of the Session Manager you can see the text of the executing queries. Find your connection executing the query above.
Right-click the session with our query and choose Kill Query on the shortcut menu.