OurSQL Episode 56: Eventual Discovery part 1

This week is all about events - events in MySQL, and calls for papers for 2012 conferences.

Percona Live MySQL Conference & Expo call for papers opens soon. http://www.percona.com/live/mysql-conference-2012/

A session matrix for all of the MySQL sessions at Oracle OpenWorld is at http://bit.ly/oow11mysql.

MySQL Community Reception (free, no need to be registered to Oracle OpenWorld) - Tuesday, October 4, 2011 7-9 pm at the San Francisco Marriott Marquis Foothill G. RSVP for the *free* MySQL Community Reception.

Call for papers for the 10th annual Southern California Linux Expo - SCALE - is at http://www.socallinuxexpo.org/cfp/cfp-information SCALE 10x will be held January 20-22, 2012 at the Hilton Los Angeles Airport Hotel. The call for papers is open until Nov 17th, 2011. They are looking for open source database talks, and we encourage folks to submit MySQL and other open source database related talks.

Note: If you submitted an iTunes review, please send us your snail mail address by e-mailing podcast at technocation.org. We thought that we would be notified when a review goes up, but we do not, so we are getting packages out to some folks who contacted us asking about when they'd receive their swag....also, we have a limited supply of swag, and it will be gone after Oracle OpenWorld (in about a month) so get your review in now so that you'll get swag!

MySQL Events:
Event scheduler thread on/off/disabled: http://dev.mysql.com/doc/refman/5.5/en/events-configuration.html

If the event scheduler is DISABLED, you cannot turn on the event scheduler:
mysql> SET GLOBAL event_scheduler='ON';
ERROR 1290 (HY000): The MySQL server is running with the --event_scheduler=DISABLED or --skip-grant-tables option so it cannot execute this statement

Sample event scheduler thread entry from SHOW PROCESSLIST\G
Id: 3
User: event_scheduler
Host: localhost
db: NULL
Command: Daemon
Time: 5575063
State: Waiting on empty queue
Info: NULL

Here are the different thread states for the event scheduler: http://dev.mysql.com/doc/refman/5.5/en/event-scheduler-thread-states.html

Sample Event
Simple test: insert the time into a table
USE test;

Sample Event
CREATE EVENT event_scheduler_test
DO INSERT INTO my_log (my_time) SELECT NOW();

Full CREATE EVENT syntax: http://dev.mysql.com/doc/refman/5.5/en/create-event.html

MySQL interval documentation is at http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-add

Ear Candy:
In MySQL 5.5, f you set log_warnings>1, access denied errors (for new connection attempts) are written to the error log. Before 5.5 you have to turn on the general log for that. See the MySQL documentation page at http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_log-warnings

Where you can see us
Sheeri will be at the Boston MySQL User group on Monday, September 12, 2011 at 7:00 PM where Jeff Yemin of MTV presents: "A MongoDB case study by Jeff Yemin of MTV Networks: MTV Networks Online Division leveraging MongoDB as the database platform for its next-generation CMS."

We will both be at Oracle Open World 2011 from Sunday October 2nd through Thursday, October 6th. We will be speaking and staffing the MySQL Community booth. If you are interested in helping staff the MySQL community booth, let us know!

MySQL Community Reception (free, no need to be registered to Oracle OpenWorld) - Tuesday, October 4, 2011 7-9 pm at the San Francisco Marriott Marquis Foothill G. RSVP for the *free* MySQL Community Reception.

Sheeri will be at the Boston MySQL User Group on Monday, October 10 at 7:00 PM where Ari Weil, Product Manager of Akiban Technologies will present: "Renormalize - Solving Performance Problems in MySQL Without Denormalization".

Sarah will be at the October Seattle MySQL User Group http://www.meetup.com/seattlemysql/ on Monday, October 3rd from 7 - 9 pm.

Boston MySQL User Group on Monday, November 14th at 7:00 PM where Mike Frank of Gazzang will present “MySQL Encryption”.