智能杂货铺

配置运行远程连接 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; 配置使用账户密码登录 use mysql;update user set authentication_string=password('password'),plugin='mysql_native_password' where user='root';MariaDB [(none)]> set password for 'root'@'localhost'

create table user1 select * from sgk where mod(id,32) = 1; create table user2 select * from sgk where mod(id,32) = 2; create table user3 select * from sgk where mod(id,32) = 3; create table user4 select * from sgk where mod(id,32) = 4; create table user5 select * from sgk where mod(id,32) =

attr | vm_centos | rpi3_centos | win10_1809_17763.437 - | :-: | :-: | :-: /proc/sys/net/core/rmem_max | 212992 | 163840 /proc/sys/net/core/rmem_default | 212992 | 163840 /proc/sys/net/core/wmem_max

## Redis缓存穿透解决方案 --- 利用互斥锁，缓存失效的时候先去获取锁，获取到锁以后再进行数据库读取，没得到锁就继续休眠。 异步更新策略，直接返回成功或者失败，交给异步队列去处理获取数据灌进Redis 通过布隆过滤器判断key的合法性，不合法直接返回。