Almost all of our db is written in Stored Procedures and some stored functions too (they are using prepare statement as well). I… the problem is when you say that Stored functions still cannot be cached does that include stored procedures too? If yes, then the…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…. For example stored procedures are handled (because binary logging is done on statements as executed inside stored procedures), however Stored Functions are not – so if you have updates done by stored functions the tables are not…
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… with a customer who has an application based entirely on stored routines on MySQL side. Even though I haven’t worked… way I expected.. For a showcase I have created a function “whatstheweatherlike”. Let’s call it and see what shows up… don’t want to go over the complicated logic of stored procedure just to figure out what queries are being executed…
Comment: UDF -vs- MySQL Stored Function
September 6, 2010 By 8 Comments
[...] A significant advantage of UDF’s over stored functions is besides the opportunity to define global server functions, that especially string functions are from a performance point of view far superior – how it was already proven from the guys of Percona. [...]
Comment: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
…/blog/implementing-sequences-using-a-stored-function-and-triggers and comments (from 2005), does this transparently as a stored proc with triggers, so… in a crash – but that could be sorted by a stored proc on server startup that grabs the max sequence value…
Comment: Stored Function to generate Sequences
May 8, 2008 By 17 Comments
[...] Stored Function to generate Sequences | MySQL Performance Blog – You could combine this with an INSERT trigger and get even more auto_increment like functionality. Tags: database mysql sequence [...]
Comment: Memory allocation in Stored Function
August 27, 2007 By 8 Comments
… memory allocation for local objects within stored functions and triggers to avoid memory leak for repeated function or trigger invocation. That was a…
Post: Sharing an auto_increment value across multiple MySQL tables (revisited)
October 26, 2010 By 7 Comments
… too dissimilar from the Flickr solution, but uses a MySQL stored function. Full Disclosure.
Comment: A workaround for the performance problems of TEMPTABLE views
May 20, 2010 By 7 Comments
Shlomi, Wow, nice post Shlomi. I didn’t think about the fact that stored functions or UDF could be called in the query and provide session state information.
Comment: A micro-benchmark of stored routines in MySQL
August 18, 2009 By 7 Comments
…, so I was really focused on the cost of a stored function as a WHERE filter (as opposed to some other options…
