Description:
Hello,
I'm trying to create an event, but mysql don't !
I use the user root, who has all priviledges...
I use MySQL 5.1.41, and here is the command that I use :
SET GLOBAL event_scheduler = ON;
use information_schema;
CREATE EVENT PERFORMANCE_GESTION_EVENEMENTS
ON SCHEDULE AT '2012-08-10 00:00:00' + INTERVAL 1 DAY
DO INSERT INTO lioni_bdd.evenement_performance (rapport, equipe, nombre_evenements_spool) SELECT type, support, COUNT(*) FROM lioni_bdd.evenement WHERE type_resolution=0 GROUP BY type, support;
-- SQL error : #1044 - Access denied for user 'root'@'localhost' to database 'information_schema'
On another report (N° 45959), you said to try that :
use test;
my request; --here, I've got request OK
But, if I return after on performance_schema, I don't see the same database
( cond_instances
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
mutex_instances
performance_timers
rwlock_instances
setup_consumers
setup_instruments
setup_timers
threads ) after using test => with this command, I have this error message :
SHOW FULL FIELDS FROM `events_waits_summary_global_by_event_name` ;
#1286 - Unknown table engine 'PERFORMANCE_SCHEMA'
, compared to
(
CHARACTER_SETS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
COLUMNS
COLUMN_PRIVILEGES
ENGINES
EVENTS
FILES
GLOBAL_STATUS
GLOBAL_VARIABLES
KEY_COLUMN_USAGE
PARTITIONS
PLUGINS
PROCESSLIST
PROFILING
REFERENTIAL_CONSTRAINTS
ROUTINES
SCHEMATA
SCHEMA_PRIVILEGES
SESSION_STATUS
SESSION_VARIABLES
STATISTICS
TABLES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TRIGGERS
USER_PRIVILEGES
VIEWS
)
I must use a request like that to see this architecture : SELECT EVENT_NAME, STATUS
FROM INFORMATION_SCHEMA.EVENTS
Did you have any idea to add this event on my table ?
How to repeat:
MYSQL 5.1.41
SET GLOBAL event_scheduler = ON;
use information_schema;
CREATE EVENT PERFORMANCE_GESTION_EVENEMENTS
ON SCHEDULE AT '2012-08-10 00:00:00' + INTERVAL 1 DAY
DO my request;
Description: Hello, I'm trying to create an event, but mysql don't ! I use the user root, who has all priviledges... I use MySQL 5.1.41, and here is the command that I use : SET GLOBAL event_scheduler = ON; use information_schema; CREATE EVENT PERFORMANCE_GESTION_EVENEMENTS ON SCHEDULE AT '2012-08-10 00:00:00' + INTERVAL 1 DAY DO INSERT INTO lioni_bdd.evenement_performance (rapport, equipe, nombre_evenements_spool) SELECT type, support, COUNT(*) FROM lioni_bdd.evenement WHERE type_resolution=0 GROUP BY type, support; -- SQL error : #1044 - Access denied for user 'root'@'localhost' to database 'information_schema' On another report (N° 45959), you said to try that : use test; my request; --here, I've got request OK But, if I return after on performance_schema, I don't see the same database ( cond_instances events_waits_current events_waits_history events_waits_history_long events_waits_summary_by_instance events_waits_summary_by_thread_by_event_name events_waits_summary_global_by_event_name file_instances file_summary_by_event_name file_summary_by_instance mutex_instances performance_timers rwlock_instances setup_consumers setup_instruments setup_timers threads ) after using test => with this command, I have this error message : SHOW FULL FIELDS FROM `events_waits_summary_global_by_event_name` ; #1286 - Unknown table engine 'PERFORMANCE_SCHEMA' , compared to ( CHARACTER_SETS COLLATIONS COLLATION_CHARACTER_SET_APPLICABILITY COLUMNS COLUMN_PRIVILEGES ENGINES EVENTS FILES GLOBAL_STATUS GLOBAL_VARIABLES KEY_COLUMN_USAGE PARTITIONS PLUGINS PROCESSLIST PROFILING REFERENTIAL_CONSTRAINTS ROUTINES SCHEMATA SCHEMA_PRIVILEGES SESSION_STATUS SESSION_VARIABLES STATISTICS TABLES TABLE_CONSTRAINTS TABLE_PRIVILEGES TRIGGERS USER_PRIVILEGES VIEWS ) I must use a request like that to see this architecture : SELECT EVENT_NAME, STATUS FROM INFORMATION_SCHEMA.EVENTS Did you have any idea to add this event on my table ? How to repeat: MYSQL 5.1.41 SET GLOBAL event_scheduler = ON; use information_schema; CREATE EVENT PERFORMANCE_GESTION_EVENEMENTS ON SCHEDULE AT '2012-08-10 00:00:00' + INTERVAL 1 DAY DO my request;