// archives

stored procedure

This tag is associated with 2 posts

Row Deletion MySQL Stored Procedure

Scenario: You’ve got a huge history table that’s getting too big to deal with. It’s grown out of your control and the application has an SLA of 100% uptime. What now? My solution: The answer is to archive rows off the system, then delete rows by primary key. DROP PROCEDURE IF EXISTS proc_delete_id_range_safe; DELIMITER $$ [...]

MySQL memory usage stored procedure

Want to know a close approximation of how much RAM MySQL is consuming right now? There’s a simple formula posted at MySQL.com. Want to add a function to your MySQL database that will allow you to access this value without having to remember the formula? Answer: Create a Stored Procedure I’m assuming your using a [...]