[{"createTime":1735734952000,"id":1,"img":"hwy_ms_500_252.jpeg","link":"https://activity.huaweicloud.com/cps.html?fromacct=261f35b6-af54-4511-a2ca-910fa15905d1&utm_source=V1g3MDY4NTY=&utm_medium=cps&utm_campaign=201905","name":"华为云秒杀","status":9,"txt":"华为云38元秒杀","type":1,"updateTime":1735747411000,"userId":3},{"createTime":1736173885000,"id":2,"img":"txy_480_300.png","link":"https://cloud.tencent.com/act/cps/redirect?redirect=1077&cps_key=edb15096bfff75effaaa8c8bb66138bd&from=console","name":"腾讯云秒杀","status":9,"txt":"腾讯云限量秒杀","type":1,"updateTime":1736173885000,"userId":3},{"createTime":1736177492000,"id":3,"img":"aly_251_140.png","link":"https://www.aliyun.com/minisite/goods?userCode=pwp8kmv3","memo":"","name":"阿里云","status":9,"txt":"阿里云2折起","type":1,"updateTime":1736177492000,"userId":3},{"createTime":1735660800000,"id":4,"img":"vultr_560_300.png","link":"https://www.vultr.com/?ref=9603742-8H","name":"Vultr","status":9,"txt":"Vultr送$100","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":5,"img":"jdy_663_320.jpg","link":"https://3.cn/2ay1-e5t","name":"京东云","status":9,"txt":"京东云特惠专区","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":6,"img":"new_ads.png","link":"https://www.iodraw.com/ads","name":"发布广告","status":9,"txt":"发布广告","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":7,"img":"yun_910_50.png","link":"https://activity.huaweicloud.com/discount_area_v5/index.html?fromacct=261f35b6-af54-4511-a2ca-910fa15905d1&utm_source=aXhpYW95YW5nOA===&utm_medium=cps&utm_campaign=201905","name":"底部","status":9,"txt":"高性能云服务器2折起","type":2,"updateTime":1735660800000,"userId":3}]
<>Mysql-慢日志详解
<>mysql慢日志是什么？
慢查询日志由 long_query_time 执行时间超过几秒钟并且至少 min_examined_row_limit 需要检查行的 SQL 语句组成
。慢查询日志可用于查找需要很长时间执行的查询，因此可以进行优化。但是，检查长而缓慢的查询日志可能是一项耗时的任务；
mysql long_query_time: 默认值是 10 秒 ；
<>查看慢日志是否开启？
登录mysql终端查看慢日志是否开启：show variables like '%quer%'; 默认是关闭状态；
开始慢日志有两种返方式。（我们用第二种演示，修改后查看状态）
* 可以直接修改 my.cnf 文件，永久有效；
* 终端执行此命令： set global slow_query_log=1; MySQL重启后则会失效；
这边你也可以自定义慢日志文件地址：set global
slow_query_log_file=‘路径名’;来设置你的慢查询日志想要存放的地址，我一般都使用默认的地址；
开启慢日志，什么样的 SQL 语句会被记录到日志中全部取决于 long_query_time ，默认时间是 10 秒。
show variables like 'long_query_time';
我们也可以去修改这个时间 ，设置阀值：set global long_query_time = 5;
set global long_query_time = 5;
我们可以发现修改后没有改变，这是为什么？是因为使用命令行操作的需要：断开当前会话窗口重新连接mysql, 再查看就好了！
最后可以用终端方式查看慢查询记录，可以使用系统变量 show global status like '%slow_queries%';
然后去看慢日志文件具体数据，就OK了：vim /usr/local/var/mysql/SuperBoss-slow.log ( 我的慢日志文件路径 !)
