mysql
文章平均质量分 51
lattar one
这个作者很懒,什么都没留下…
展开
-
Quartz Cluster出现异常Couldn‘t rollback jdbc connection. Communications link failure during rollback().
记录使用Quartz Cluster出现异常已经解决方案问题描述....省略部分错误The last packet successfully received from the server was 3,689,831 milliseconds ago. The last packet sent successfully to the server was 3,689,833 milliseconds ago. is longer than the server configured value o原创 2021-09-08 16:29:26 · 712 阅读 · 0 评论 -
canal客户端使用多线程消费消息
由于canal消费时是单线程阻塞的,大大降低了程序对于线程的利用率canal客户端实现官方demo //保存被消费的消息记录和状态 private static List<CanalTaskStatus> listTaskStatus = Collections.synchronizedList(new ArrayList<>()); //正在被消费的batchId private static Set<Long> batchIds = Col原创 2021-07-12 15:06:40 · 1265 阅读 · 0 评论 -
mysql索引命中规则
mysql索引命中规则当我们有一条SQL:select * from student where name=‘张三’ and age=15 and phone=‘13873062211’;创建一个简单的单列索引:alter table student add index name_index (name);将name列建索引,这样就把范围限制在name='张三’的结果集上,之后扫描结果集...原创 2020-09-03 10:43:13 · 110 阅读 · 0 评论 -
mysql性能查询常用命令
原文:点我1,查看每个客户端IP过来的连接消耗了多少资源。mysql> select * from host_summary; 2,查看某个数据文件上发生了多少IO请求。mysql> select * from io_global_by_file_by_bytes; 3,查看每个用户消耗了多少资源。mysql> select * from user_summary...转载 2019-05-28 14:22:51 · 187 阅读 · 0 评论