Develop students ' welfare--mysql monitoring Tools SQLProfiler, SQL Server-like Profiler tool

Recently, no intention to discover the MySQL client monitoring tool "Nero profile SQL", just at the beginning do not know how to use, after half an hour groping, now will use the steps to write down.

Background: When developing, if the data storage tier uses EF, or other ORM frameworks, the database is MySQL and you want to know the SQL statements that are finally executed, then this tool will do you a favor.

1, to the official website to download the installation of Windows version http://www.profilesql.com/download/

2. Installation complete, connect MySQL database

　　　　

3, modify the connection string inside the program

　　　　

My understanding is that the Nero profile SQL tool takes over some portion of the MySQL database and allocates the program's access address and port, which is 127.0.0.1 and Port 4040.

4. Perform database operations

　　　　

5. Open the Monitoring tool

　　　　

6. This tool is not very powerful.

　　

　　

Develop students ' welfare--mysql monitoring Tools SQLProfiler, SQL Server-like Profiler tool