[root@ip-xx.xx.xx.xx ~]# mysql
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 9
|
Server version: 10.3.13-MariaDB MariaDB Server
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema;
|
+-----------------+
|
| @@version |
|
+-----------------+
|
| 10.3.13-MariaDB |
|
+-----------------+
|
1 row in set (0.000 sec)
|
|
+-----------------------------------+
|
| @@performance_schema_digests_size |
|
+-----------------------------------+
|
| -1 |
|
+-----------------------------------+
|
1 row in set (0.000 sec)
|
|
+----------------------+
|
| @@performance_schema |
|
+----------------------+
|
| 0 |
|
+----------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]>
|
|
After enabling performacne_schema on EC2 instance the value changed to 5000
|
|
[root@ip-xx.xx.xx.xx my.cnf.d]# mysql
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 8
|
Server version: 10.3.13-MariaDB MariaDB Server
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema;
|
+-----------------+
|
| @@version |
|
+-----------------+
|
| 10.3.13-MariaDB |
|
+-----------------+
|
1 row in set (0.000 sec)
|
|
+-----------------------------------+
|
| @@performance_schema_digests_size |
|
+-----------------------------------+
|
| 5000 |
|
+-----------------------------------+
|
1 row in set (0.000 sec)
|
|
+----------------------+
|
| @@performance_schema |
|
+----------------------+
|
| 1 |
|
+----------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]>
|
|
Tried chaning performance_schema_digests_size to 100 and was able to change.
|
[root@ip-xx.xx.xx.xx my.cnf.d]# mysql
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 8
|
Server version: 10.3.13-MariaDB MariaDB Server
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> select @@version; select @@performance_schema_digests_size;select @@performance_schema;
|
+-----------------+
|
| @@version |
|
+-----------------+
|
| 10.3.13-MariaDB |
|
+-----------------+
|
1 row in set (0.000 sec)
|
|
+-----------------------------------+
|
| @@performance_schema_digests_size |
|
+-----------------------------------+
|
| 100 |
|
+-----------------------------------+
|
1 row in set (0.000 sec)
|
|
+----------------------+
|
| @@performance_schema |
|
+----------------------+
|
| 1 |
|
+----------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]>
|