Table 'performance_schema.global_status' doesn't exist

[moeinrahimi]

after importing my2 dashboard on grafana i get this err message on page load and nothing works.
I imported my2.sql with no issue. and also created a new datasource for my2 database with my2 user.

my mysql info: mysql Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

[mm86133]

Same issue here.

[meob]

Same issue here.
Which MySQL version are You using?
Can You send me the result of version() function and of SHOW VARIABLES command?

[AMASTRO00]

in variable dashboard (MyVar2) replace with :

select concat('MySQL version: ',version(), ' Created at: ', date_format(min(create_time),'%Y-%m-%d %T') ,
' Started at: ', date_format(date_sub(now(), INTERVAL variable_value second),'%Y-%m-%d %T')) info
from information_schema.tables,information_schema.global_status
where variable_name='UPTIME'
group by variable_value

Global_status table is contained information_schema and not in performance_schema.

The same problem is in the my2.sql.
Try to use an editor and replace all performance_schema.global_status with information_schema.global_status. Good luck

[meob]

Global_status table is contained information_schema and not in performance_schema.
The same problem is in the my2.sql.
Try to use an editor and replace all performance_schema.global_status with information_schema.global_status. Good luck

MySQL 5.7 and 8.0 use performance_schema while older MySQL versions and MariaDB use information_schema. my2.sql code tries to use the right schema for the running version but it is not bullet proof. For Grafana dashboards I have 2 different versions... maybe I'll do the same for the my2 collector. Which fork and version are You using?

[meob]

Grafana dashboards for MySQL and MariaDB are different

[QuijoteShin]

I'm adding extra information to deal with the missing table.

First check where the table actually is. It may be at information_schema or performance_schema.
run this query to know where:
select TABLE_SCHEMA , TABLE_NAME from information_schema.TABLES t where TABLE_NAME ='global_status'

Also you may enable performance schema at my.conf or mysqld.conf
[mysqld]
performance_schema=ON