…module and set of utilities designed to provide functionality similar to that of FlashCache. In particular, … benchmarks for the use case where the MySQL working set is significantly larger than the … blocks will be written to the backing store, whereas FlashCache has a setting called “fallow_delay…
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 8 Comments
… 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…_dups – 12 times if comparing to stored function or 2 times comparing to just using available functions. With that speed I could even… 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 4 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: 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: 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: 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: Stored Function to generate Sequences
April 2, 2008 By 17 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…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… API function mysql_real_escape_string() is aware of binary bytes, and will escape appropriately. SQL also has a builtin QUOTE() function so you can do this in SQL expressions instead of in application code. See http://dev.mysql.com/doc… query, then you should be able to store such strings safely. Another risk of storing code-like strings in the database is…
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…
