meob / my2collector Goto Github PK
View Code? Open in Web Editor NEWMy2Collector (my2) is a simple, self contained MySQL statistics collector
License: MIT License
My2Collector (my2) is a simple, self contained MySQL statistics collector
License: MIT License
hi. I´ve mysql 5.5, and i´ve this error when run my2.sql, after CREATE PROCEDURE collect_daily_stats().
problem with events into procedures in mysql version < 5.7 ?
I'm using MySQL 5.7.24 in a percola cluster of 3 master-master.
When I run the script my2.sql I do have a lot of error 1055 like this one :
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Do you have any idea why?
The error is:
#1064 - A Szintaktikai hiba a ';
CREATE PROCEDURE collect_stats()
BEGIN
DECLARE a datetime;
DECLARE v va...'-hez kozeli a 1 sorban
I had run this through phpmyadmin's SQL interface.
The server is: 10.5.5-MariaDB
Hi,
im kind of new to this but im trying to import the my2.sql file and gets error in the import. Tryed with the flat text and with the sql file.
DECLARE a datetime;
DECLARE v varchar(10);
is the part is stops regard the import.
Error from phpmyadmin, and i have tryed heidisql.
CREATE PROCEDURE collect_stats ()
BEGIN
DECLARE and datetime;
DECLARE v varch 'in row 1
//Stefan
Hi, Would you share a SQL script for MariaDB version 5.5 cause that version did not has tables performance_schema.global_status, performance_schema.events_statements_summary_global_by_event_name, and performance_schema.replication_connection_status.
Thank you
Tables GLOBAL_STATUS and GLOBAL_VARIABLES no support in this version 8.0
Looks awesome so far!
Only issue for me is that you can't really see the "current" state of the database. So for example if you have lots of new connections you might only see these after 10 minutes in the dashboard.
You think there are any issues with changing the execution time to something lower (like a minute or even every 10 seconds)?
Of course it would consume more storage, but besides that?
When I just run the import of my2.sql I get GLOBAL_STATUS does not exist on line 37; when I manually remove both else statements completely, all works fine.
Hi,
Thanks for building this wonderful dashboard content.
While executing below script, I am seeing below error. Can you check this again?
ERROR 1061 (42000) at line 26: Duplicate key name 'idx01'
Thanks,
Raghavendra Guttur
It looks like my2 is no longer getting infromation anymore after a restart off the machine.
RHEL updates had caused a reboot of the machine and since then there is no new my2 data
A new specific script for MySQL 8.0 has been added.
Previously some lines have to be commented out to have it working.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.