ocp监控中租户qps 2万+ 但TPS一直不超过3

OceanBase 技术问题
#22

image
image3459×1186 350 KB

#23

然后再麻烦发下 3月12日 21:00:00~ 21:00:05的 TPS监控截图

#24

image
image3469×1288 367 KB

#25

image
image2872×964 218 KB

性能监控选全部zone和全部observer，SQL诊断选全部observer

3月12日 21:00:00~ 21:00:05的截图看下呢

#26

是一样的，我们所有SQL都只在这一个zone 上执行的

image
image3459×1231 384 KB

image
image3485×1287 360 KB

#27

好的，我再看下

#28

麻烦执行下这个sql查下看看
select ACTION,count(*) from from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip=’’ group by action;

#29

看不透

#30 
MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        7 |
| COMMIT |        1 |
+--------+----------+
2 rows in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        9 |
+--------+----------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        4 |
+--------+----------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        3 |
+--------+----------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        4 |
+--------+----------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        7 |
+--------+----------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |       11 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        5 |
+--------+----------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        2 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        4 |
| COMMIT |        1 |
+--------+----------+
2 rows in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        7 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| COMMIT |        1 |
| START  |        7 |
+--------+----------+
2 rows in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        3 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        3 |
+--------+----------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        3 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        2 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        1 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        4 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        1 |
+--------+----------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        1 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        6 |
| COMMIT |        1 |
+--------+----------+
2 rows in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        7 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        6 |
| COMMIT |        1 |
+--------+----------+
2 rows in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        8 |
+--------+----------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        6 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        7 |
+--------+----------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| COMMIT |        1 |
| START  |        3 |
+--------+----------+
2 rows in set (0.01 sec)

MySQL [oceanbase]> select ACTION,count(*)  from GV$OB_TRANSACTION_PARTICIPANTS where svr_ip='10.10.17.204' group by action;
+--------+----------+
| ACTION | count(*) |
+--------+----------+
| START  |        4 |
+--------+----------+
1 row in set (0.01 sec)
#31

学到了！