Comments (6)
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?
from my2collector.
Same issue here.
from my2collector.
Same issue here.
Which MySQL version are You using?
Can You send me the result of version() function and of SHOW VARIABLES command?
from my2collector.
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
from my2collector.
Grafana dashboards for MySQL and MariaDB are different
from my2collector.
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
from my2collector.
Related Issues (18)
- Can't work with Mysql 8.0 HOT 1
- Need script for mariadb ver 5.5 HOT 3
- automatic creation does not work for me - 8.0 HOT 2
- ERROR 1061 (42000) at line 26: Duplicate key name 'idx01' HOT 5
- How to get real-time data on graphs. HOT 3
- Events and Procedures are not found after upgrade application HOT 2
- How to set enabled events without phpmyadmin HOT 2
- Some dashboard not shown after upgrade Grafana ver 8 HOT 2
- error updating options query error 400 bad request
- No value on custom statistic HOT 3
- MySQL 8.0 full support
- my2 stops collecting after server restart.... HOT 1
- my2 import of my2.sql HOT 7
- A lot of [Err] 1055 HOT 2
- error #1576 - Recursion of EVENT DDL statements is forbidden when body is present HOT 1
- [Question] Increase logging frequency HOT 4
- Can't run the my2.sql HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from my2collector.