Neor Profile SQL is the solution for developers wanting to profile the MySQL queries. This software allows the tracking of all queries to MySQL server from your application or website.
2023-09-11 14:14:13 时间
The profiler features
Neor Profile SQL is the solution for developers wanting to profile the MySQL queries. This software allows the tracking of all queries to MySQL server from your application or website.
Helpful use of the SQL profiler
- It shows how your application uses the database
- It optimizes the SQL queries
- It reduces the number of queries to the database
Main features
- The total statistics of strings being received and sent by the database
- Counting all the queries
- Displaying the time spent per query
- The slow queries detection
- Displaying the detailed code of all the SQL queries
- Showing the desired session in separated tab
- Saving the sessions for further comparison of the results
Screenshots v3.0
Main window with statistics
Catch query flow
Tracked sessions
Session details
SQL editor
Explain query
Profile query
Connections to a database
Compare sessions
Session query replaysComparison of the features with other profilers
| User-defined task | Neor Profile SQL | MySQL command PROFILING | Jet Profiler |
|---|---|---|---|
| Show absolutely all the queries | |||
| Count the total number of queries to the database | |||
| Show the detailed code of each SQL query | |||
| Sort the queries by the processing rate | |||
| Sort the queries by the number of strings being received | |||
| Sort the queries by the amount of data being received and sent | |||
| Allocate the session to separated list of queries | |||
| Save the session with queries for further comparison | |||
| Show the load graph of all the database | |||
| Show the load graphs of each session | |||
| SQL editor | |||
| Find SQL query replays | |||
| Explain SQL query | |||
| Detailed profiling query | |||
| Export session to CSV/XML file | |||
| Filter queries in Session New! | |||
| Catch error sessions and queries New! | |||
| Advance DB monitoring New! |
相关文章
- RHEL系统安装MySQL主备环境
- mysql5.6采集数据插入出现MySQL server has gone away解决办法
- Error connecting to database [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)]
- Mysql授权允许远程访问解决Navicat for MySQL连接mysql提示客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端
- 使用navicat premium将数据库从Oracle迁移到SQL Server，或从Oracle迁移到MySQL
- 【MySQL】一次修改mysql 默认路径的经历
- 【Mysql】初识MySQL
- navcat导入mysql.sql出现：2006, 'MySQL server has gone away'
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var mysql 启动不了
- centos用yum安装mysql-server
- PHP连接MySQL数据库的三种方式(mysql、mysqli、pdo)
- [root@master mysql]# mysql -uroot -pjsb ERROR 2002 (HY000): Can't connect to local MySQL server thro
- oracle 、mysql、 sql server使用记录
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
- MySql中json类型的使用___mybatis存取mysql中的json
- [转]2006 MySQL server has gone away错误，最大值溢出解决办法 mysql max_allowed_packet 查询和修改
- atitit。mssql sql server 转换mysql 及 分页sql ast的搭建
- atitit。mssql sql server 转换mysql 及 分页sql ast的搭建
- piap.excel 微软 时间戳转换mssql sql server文件时间戳转换unix 导入mysql
- error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
- 【异常】MySQL Workbench 报错 Error changing account root@localhost : The MySQL server is running with
- Linux复习资料——MySQL-client-5.6.50-1.el7.x86_64与MySQL-server-5.6.50-1.el7.x86_64包安装MySQL全过程
- ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost‘ (10061)
- mysql_server下载安装
- mysql 的 if 和 SQL server 的 iif
- C# 连接SQL Server数据库的几种方式--server+data source等方式
- tomcat链接mysql时超时报错java.io.EOFException: Can not read response from server. Expected to read 4 bytes,
- [SQL] SQL Server远程链接MySql数据库(LinkedServer)