Session
Using Stored Routines for MySQL Administration
Giuseppe Maxia, QA Developer, MySQL AB
Track: General
Date: Tuesday, April 24
Time: 10:45am
- 11:45am
Location: Ballroom C
MySql stored procedures offer potential security, performance, and maintainability improvements for a variety of application types. However, in this presentation we focus on the benefits of stored procedures for the MySQL admin. Topics will include:
- Basic overview of stored procedure language and execution environment
- Using dynamic SQL to automate the generation of administration commmands
- Using the event scheduler to automate execution
- Leveraging the new MySQL log "tables"
- Advantages and disadvantages of using stored procedure compared to alternatives such as Perl or PHP.