.::: How to Enable Performance report performance-schema MySQL, MariaDB :::.

1. Open MySQL WorkBench Server -> Performance report
mysqld --verbose --help | grep performance-schema

2. enable performance_schema in /etc/my.cnf
[mysqld]
performance_schema
#performance_schema_events_waits_history_size=20
#performance_schema_events_waits_history_long_size=15000

# you can put MariaDB-only options here
[mariadb]
performance_schema


[root@mariadb01 ~]# systemctl restart mariadb
[root@mariadb01 ~]#

3. Get error

 

4. download & extract


https://github.com/FromDual/mariadb-sys

[root@mariadb01 data] wget https://codeload.github.com/FromDual/mariadb-sys/zip/refs/heads/master
[root@mariadb01 data]# unzip mariadb-sys-master-mysqlmaria.zip
[root@mariadb01 mariadb-sys-master]# mysql -u root -p < ./sys_10.sql
Enter password:
[root@mariadb01 mariadb-sys-master]#

5. Install performance-schema
[root@mariadb01 data]# cd mariadb-sys-master
[root@mariadb01 mariadb-sys-master]# ls
after_setup.sql   COPYING    generate_sql_file.sh  MERGE.md    NEWS.md     README.md   sys_56.sql  tables     triggers
before_setup.sql  functions  LICENSE               mysql-test  procedures  sys_10.sql  sys_57.sql  templates  views
[root@mariadb01 mariadb-sys-master]# mysql -u root -p < ./sys_10.sql
Enter password:
[root@mariadb01 mariadb-sys-master]#

6. Open MySQL WorkBench Server -> Performance report