Windows server2012 r2环境MySQL 8.0.16的data目录迁移方法，遇到服务无法启动的解决办法The Mysql80 service on Local computer started and then stopped.Some services stop automatically if they are not in use by other services or programs.
Windows下MySQL 服务管理器（中英文版）
MySQL Service Manager for Windows (Cn&En Version)
运行后自动获取管理员权限，自动判定MySQL服务运行状态，自动根据状态请求启动服务/停止服务操作。
请将代码中的MySQL80匹配你的MySQL服务名称。
Please match the MySQL80 in the code to the name of your MySQL service.
MySQL Service Manager for Windows (English Version)
Get administrator privileges after running, determine the running status of MySQL services, and start/stop services based on the status automatically.
Please match the MySQL80 in the code to the nam
下面这两个方面能够解决MySQL80%的问题
SQL级别
1、明确select列表的列
select * from t;
优化：明确你想要查询的列
select id,name from t;
2、空间换时间：建立索引，走索引，避免全表扫描
select id ,name from t where name is null -- 空值不能利用索引，所以还是全表扫描
select id ,name from t where id in(1,2,3) -- 全表扫描
select id,nam
