mysql profile 工具Neor Profile

一、下载Download - Neor Profile SQL

http://www.profilesql.com/files/download/sqlprofiler-4.1.1.exe

Neor Profile 这款免费的mysql 分析工具，这个工具类似于一个代理

本地启动一个mysql 代理服务，类似于MyCat

二、安装完成配置

 

 

 三、代码连接代理

using System;
using System.Collections.Generic;
using System.Linq;
using Dapper;
using mysql.demo.Entitys;
using MySql.Data.MySqlClient;

namespace mysql.demo
{
    internal class Program
    {
        static int ownerId = 2;
        static void Main(string[] args)
        {
            using (var connection = new MySqlConnection("Server=localhost;User ID=root;Password=123456;Database=demo;Allow User Variables=true"))
            //using (var connection = new MySqlConnection("Server=192.168.31.132;User ID=root;Password=123456;Database=demo;Allow User Variables=true"))
            {
                connection.Open();

                //新增
                connection.Execute("INSERT  posts(Title, Content,OwnerId) VALUES (@Title, @Content,@OwnerId)", new List<Post> { new Post { Title = Guid.NewGuid().ToString(), Content = DateTime.Now.ToFileTime().ToString(), OwnerId = ownerId } });
                connection.Execute("INSERT  users(Name) VALUES (@Name)", new User { Name = Guid.NewGuid().ToString() });

                var sql2 = " select * from posts; select * from users";
                using (var multi = connection.QueryMultiple(sql2, new { }))
                {
                    var orders = multi.Read<Post>().ToList();
                    var returns = multi.Read<User>().ToList();
                }

                var users = connection.Query<User>("select * from users;");

                var sql =
                    @"select * from posts p
                    left join users u on u.Id = p.OwnerId
                    Order by p.Id";
                var data = connection.Query<Post, User, Post>(sql, (post, user) => { post.Owner = user; return post; });
                var post = data.First();

            }
        }
    }
}

监控到的Sql: