摘要:
@Slf4j @Service public class KeyCloakService { private RestTemplate restTemplate; private KeycloakAdminClient keycloakAdminClient; /** * kc新增用户 * * @p 阅读全文
摘要:
cd /var/lib/mysql rm 数据库xxx-Rfv 阅读全文
摘要:
public class NacosServiceListener { private static String serviceName = "wms"; private static List<Instance> listenService() throws NacosException { S 阅读全文
摘要:
SHOW ENGINE INNODB STATUS ' BUFFER POOL AND MEMORY Total large memory allocated 137428992 buffer pool总大小 Dictionary memory allocated 8832933 数据词典data+ 阅读全文
摘要:
delete from sys_role_permission where id not in ( select t.max_id from (select max(id) as max_id from sys_role_permission group by role_id, permission 阅读全文
摘要:
Translation翻译插件 更新TTK失败,请检查网络连接 >Plugin v2.9.5-171u192 >IntelliJ IDEA 2019.1 >Build #IU-191.6183.87, built on March 27, 2019 >JRE: 1.8.0_202-release-1 阅读全文
摘要:
/** * websocket消息订阅处理 */ @Slf4j @Component @ServerEndpoint(value = "/socket/subscribe") @ToString public class SocketSubscribeEndPoint { /** * websock 阅读全文
摘要:
#首先区分是锁超时还是死锁-- 当前运行的所有事务 SELECT * FROM information_schema.INNODB_TRX; -- 当前出现的锁 SELECT * FROM information_schema.INNODB_LOCKs; -- 锁等待的对应关系 SELECT * F 阅读全文
摘要:
/** * 取尽存储的值,获取最新值 * * @param key * @return */ @Override public String popData(String key) { List<String> list = new ArrayList<>(); String popDataKey 阅读全文
摘要:
需求: 根据复合查询条件对数据分组,并对分组数据按不同的时间排序 思路: 搞一个sort临时字段用于分组,最后用case when按时间分别排序 SELECT * from ( SELECT *, case when (line_id is not null ) and state = 3 THEN 阅读全文