分类：数据库

mysql-大数量写入

解决办法 1.批量写入 [crayon-641e22b678dcc34461309 […]

2019-12-02 18:41:03 | 阅读:7,130 | 评论

mysql explain

数据库优化最常用的命令就是用explain查看一下写的sql是否用到了索引: 如： (root@localho […]

2019-10-10 19:48:24 | 阅读:5,706 | 评论

redis排序

hash+sort

redis148.akctest1.com:0>hmset good_info_1 price 20 weight 3
"OK"
redis148.akctest1.com:0>hmset good_info_2 price 40 weight 5
"OK"
redis148.akctest1.com:0>hmset good_info_3 price 30 weight 1
"OK"
redis148.akctest1.com:0>sort gid by good_info_*->price

redis148.akctest1.com:0>lpush gid 1
"1"
redis148.akctest1.com:0>lpush gid 2
"2"
redis148.akctest1.com:0>lpush gid 3
"3"
redis148.akctest1.com:0>sort gid by good_info_*->price
 1)  "1"
 2)  "3"
 3)  "2"
redis148.akctest1.com:0>sort gid by good_info_*->weight
 1)  "3"
 2)  "1"
 3)  "2"
redis148.akctest1.com:0>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

redis148.akctest1.com:0>hmset good_info_1 price 20 weight 3

"OK"

redis148.akctest1.com:0>hmset good_info_2 price 40 weight 5

"OK"

redis148.akctest1.com:0>hmset good_info_3 price 30 weight 1

"OK"

redis148.akctest1.com:0>sort gid by good_info_*->price

redis148.akctest1.com:0>lpush gid 1

"1"

redis148.akctest1.com:0>lpush gid 2

"2"

redis148.akctest1.com:0>lpush gid 3

"3"

redis148.akctest1.com:0>sort gid by good_info_*->price

1) "1"

2) "3"

3) "2"

redis148.akctest1.com:0>sort gid by good_info_*->weight

1) "3"

2) "1"

3) "2"

redis148.akctest1.com:0>

sortSet [cra […]

2019-09-16 19:53:21 | 阅读:4,555 | 评论

Mysql Too many connections

#show variables like 'max_connections' 查询最大连接
#show status like 'Threads%';查看当前线程状态
#set global max_connections=1400; 设置最大连接
#show  processlist; 查询现有连接
#SHOW TABLE STATUS FROM 库名LIKE '表名' 查看某张表的状态
#show status; -- 显示一些系统特定资源的信息，例如，正在运行的线程数量。

1

2

3

4

5

6

#show variables like 'max_connections' 查询最大连接

#show status like 'Threads%';查看当前线程状态

#set global max_connections=1400; 设置最大连接

#show processlist; 查询现有连接

#SHOW TABLE STATUS FROM 库名LIKE '表名' 查看某张表的状态

#show status; -- 显示一些系统特定资源的信息，例如，正在运行的线程数量。