… it to sphinx – MySQL did not have a function to do the thing so I thought I’ll write MySQL Stored Function and we’ll… using mysql stored routines interface. So anyway, I asked my colleague Sasha to help me out by rewriting these as UDF functions. Here… using stored function used to take minutes! I don’t mean to say stored functions are bad and you should now rewrite all your functions…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… is the behavior of the MySQL when it needs to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We… t VALUES(this_year())’ STORED PROCEDURES The behaviour of stored procedures and functions are completely different. If our stored procedure write data to our…
Post: Memory allocation in Stored Function
August 26, 2007 By 8 Comments
… non-trivial, I decided this task is good to try Stored Function. Function written – go ahead. Since 5 min I got totally frozen… MySQL ate 5GB of memory in 85 sec. That makes things clearer. As I understand MySQL allocates memory in each call of Stored Function, but de-allocates it only at the end of statement. This makes usage of Stored Function…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… do some testing on a large data set against two MySQL column-store storage engines. I’d like to note that this… first first part of my analysis focused on testing specific MySQL functionally with Infobright’s storage engine. A lot of my tests… aggregate functions as ICE, and therefore it could not run some of the queries. ICE supports almost all of the MySQL aggregation functions…
Post: Withdrawal of Memory allocation in Stored Function
September 7, 2007 By 1 Comment
Returning to my post about memory consumption with Stored Function at this moment I want to annul that post. Trying … probably there was something wrong with the whole box, not MySQL. I apologize if it was confusing. Although I am almost…
Post: Sharing an auto_increment value across multiple MySQL tables (revisited)
October 26, 2010 By 7 Comments
… I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a few people wrote in to… not too dissimilar from the Flickr solution, but uses a MySQL stored function. Full Disclosure.
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…, Flexviews includes a MySQL stored procedure API, called the SQL_API which is used to define the view. These stored procedures maintain the…() function call. This function reads the meta-data stored in the Flexviews data dictionary. It returns the SQL which represents the data stored in…
Post: A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
… how fast stored routines are in MySQL? I just ran a quick micro-benchmark to compare the speed of a stored function against a… took the subquery and basically rewrote it as a stored function. mysql> delimiter // mysql> create function speaks_english(c char(3)) returns integer deterministic > begin…
Post: Stored Function to generate Sequences
April 2, 2008 By 15 Comments
… help them to convert their sequence generation process to the stored procedure and even though I have already seen it somewhere… way of using this function allows you to “inject” the value to be returned next time this function is called. Sometimes people wonder why you would like to use sequences instead of MySQL auto_increment columns…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… temporary table. The other thing – since MySQL 4.1 sorting can be done with storing row data in the sort file, not… 100 rows/sec. No info about functions cost Since MySQL 5.0 you may use user functions in your query which may also… outcome. The cost of functions is also not used in optimization which may produce suboptimal plans if stored functions are used in queries…
