Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [event]

30 questions
14
votes
1 answer

Scheduling an event every day at a given time

I want my event to run everyday at 00:20. I am confused in scheduling of the time. Should I be using the first option or the second one? Option 1 CREATE EVENT my_event ON SCHEDULE EVERY 1 DAY STARTS '2014-04-30 00:20:00' ON COMPLETION…
Femme Fatale
  • 337
  • 2
  • 4
  • 9
10
votes
1 answer

Where EVENTS history are logged/recorded in MySql?

I just setup some stored procedures to run in the event scheduler using CREATE EVENT. I'm trying to find where (if somewhere) the history of it running is stored. I looked at the docs but couldn't find anything. Is there some table or log where I…
tucaz
  • 225
  • 1
  • 2
  • 6
6
votes
1 answer

How to turn Event Scheduler On permanently in MySQL?

How do I turn on the event scheduler in mysqld permanently? I'm using phpMyAdmin and I have scheduled an event to copy records from one table to another everyday at a specific time, but the records are not being copied everyday. I've tried setting…
user1930115
  • 163
  • 1
  • 1
  • 3
3
votes
1 answer

column auto updated after 24 hours in mysql

i have a table T1 with column : Name State time mon 1 2014-01-09 11:23:00 tue 0 2014-01-07 14:40:00 wed 2 2014-01-08 09:23:00 thu 0 2014-01-09 12:23:00 Now i…
simplifiedDB
  • 649
  • 6
  • 17
  • 35
3
votes
2 answers

Does not writing a checkpoint record damage anything?

I got an alert Event ID: 3619. Could not write a checkpoint record in database 'ID ####' because the log is out of space I know why it happened, I have addressed the issue, backed up the t-logs, shrunk the log that overgrew and other wise done my…
James Jenkins
  • 5,948
  • 6
  • 35
  • 77
2
votes
1 answer

Seting timezone per database in MySQL

I wanted to know if MySQL let the admin set a timezone per database ? I have three different databases for three different customers. Each of them being in their own timezone. I would like to load the exact same event for each customer and would…
Spredzy
  • 2,248
  • 1
  • 20
  • 25
1
vote
0 answers

MySQL event scheduler doesn't work

I have the following MySQL event sheduler to udpate some values in RECETAS table's ESTADO column. I want to run it everyday at 10:05:00. CREATE EVENT IF NOT EXISTS actualizar_prueba ON SCHEDULE EVERY 1 DAY STARTS '2014-09-23 10:05:00' ON…
william
  • 21
  • 2
1
vote
1 answer

How to update MySQL data within intranet from MySQL data in cloud?

I am currently using a MySQL DB located within the intranet. Only the people within the LAN can access the information. I'm trying to re-create the MySQL DB in a cloud provider. This can be accessed by other people from a different location. When…
Charlesliam
  • 115
  • 6
1
vote
1 answer

How to create date ranges of events coming from an API where open state represents the date range and close state the gaps between the ranges?

I would like to store date/time ranges in PostgreSQL of some arbitrary events that have a state of open or closed and a date/time of when the state changed. Events coming from an API will have the following data for a single event: Request 1: { …
feketegy
  • 121
  • 2
1
vote
0 answers

Do Hive Materialized Views respond to added partitions to source tables?

Hive Materialized Views support partitions, CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name [DISABLE REWRITE] [COMMENT materialized_view_comment] [PARTITIONED ON (col_name, ...)] [ [ROW FORMAT row_format] …
ignorance
  • 111
  • 3
1
vote
1 answer

event get not executed

I'm on 2 debian8 box's with mysql-5.7.19. I have a master slave replication running, replicating one db (db1.1) from master to slave (db2.1). Replicated db's on master and slave have same names. Master has another db (db1.2) that pulls some…
jgnoss
  • 73
  • 6
1
vote
0 answers

Postgres upsert perform multiple actions _OR_ versioning of events in an "append only" store

Background I am running on postgres 9.5 I have a table with events (in theory, it is, currently, an append only store). Certain event types can appear only once on a given date. (So currently, we have a partial unique index and an upsert to update…
Yaneeve
  • 177
  • 6
1
vote
2 answers

DDL-trigger for ALTER_AUTHORIZATION

I need to perform some audit, when change of a securable ownership, such as ALTER AUTHORIZATION ON SCHEMA::[SchemaName] TO [PrincipalName]; happens in database. Database scope DDL-trigger seems an appropriate mechanism for this purpose. In the…
i-one
  • 2,284
  • 1
  • 9
  • 21
1
vote
1 answer

MySQL 5.6 events are created disabled and they don't run

I am using the normal syntax to create an event, but they are created disabled and they never run: create event p1 on schedule at now() on completion preserve enable do call proc1(); I added enable although it is default to solve this problem, but…
Manal
  • 11
  • 1
1
vote
0 answers

MySQL Event scheduler not generating CSV

The scheduler seems to be running from INFORMATION_SCHEMA.EVENTS but there is no CSV output. The event scheduler has to automatically produce a csv to pass on the data to another system. It's like integrating 2 systems through the csv, maybe not…
mish
  • 11
  • 2
1
2