Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have create few events in my db. One is to daily create partition. Another is to summarize data on every second from another table. I notice everything is not running. What would have cause the scheduler to stop. The db is fine working on other stuff with out issue.

Below is my mysqladmin debug results.

Status information:

Current dir: /var/lib/mysql/
Running threads: 2  Stack size: 262144
Current locks:
lock: 0x7f71f0014570:

lock: 0x7f71f001f400:

lock: 0x7f71f800c530:

lock: 0x7f71f800da40:

lock: 0x7f71f8016dc0:

lock: 0x7f71f8014310:

lock: 0x7f71f80116f0:

lock: 0x7f71f802f6c0:

lock: 0x7f71f802f060:

lock: 0x7f71f8021000:

lock: 0x7f71f8026c60:

lock: 0x7f71f80251a0:

lock: 0x7f71f80226a0:

lock: 0x338adb8:

lock: 0x3380088:

lock: 0x33754e8:

lock: 0x336c5a8:

lock: 0x3361de8:

lock: 0x3352908:

lock: 0x334ca48:

lock: 0x3344da8:


Key caches:
default
Buffer_size:       8384512
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:             2
not flushed:             0
w_requests:              0
writes:                  0
r_requests:           2560
reads:                   2


handler status:
read_key:         3670
read_next:       56069
read_rnd            82
read_first:          5
write:             952
delete               0
update:           1649

Table status:
Opened tables:         29
Open tables:           22
Open files:            17
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 2
Next alarm time: 0

Begin safemalloc memory dump:

End safemalloc memory dump.
share|improve this question
    
See the scheduler status: dev.mysql.com/doc/refman/5.1/en/events-status-info.html –  Phil Mar 14 '13 at 14:10
    
I tried this show scheduler status; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'scheduler status' at line 1 –  biz14 Mar 14 '13 at 14:19
    
Carry on reading then! "Beginning with MySQL 5.1.12, event scheduler status information can be obtained by running mysqladmin debug".... –  Phil Mar 14 '13 at 14:29
    
@Phil I had to restart the mysql else we will be loosing lots of data but I have updated my question with mysqladmin debug results anything you can suggest from here? –  biz14 Mar 14 '13 at 14:42
    
Please show the result of SHOW VARIABLES LIKE 'event_scheduler'; –  RolandoMySQLDBA Mar 14 '13 at 15:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.