… an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it… routines that MySQL spends most of the time on, but I don’t want to go over the complicated logic of stored… would be hard to implement configurable variable for switching between routine and query logging, so maybe one day we’ll be…
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… I took the subquery and basically rewrote it as a stored function. mysql> delimiter // mysql> create function speaks_english(c char… query can’t be optimized to use indexes, and the stored function is opaque to the optimizer. This is why I…
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 6 Comments
… it shows how much overhead you have by using mysql stored routines interface. So anyway, I asked my colleague Sasha to help… improvement and for remove_dups – 12 times if comparing to stored function or 2 times comparing to just using available functions…(*) | +———-+ | 2720414 | +———-+ 1 row in set (11.19 sec) Whereas using stored function used to take minutes! I don’t mean to…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… a global level. But let’s keep going! Any stored code (triggers, stored routines, etc) uses memory to execute; so do temporary tables…
Comment: Eventual Consistency in MySQL
November 25, 2011 By 8 Comments
… the relationship is broken. or do all your writes in stored routines/triggers. with the former all you need to do when…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
… changes. (Aleksandr Kuzminsky) Bug #693818 – Warning and error messages for stored routines could incorrectly report row numbers due to a change in…
Comment: UDF -vs- MySQL Stored Function
September 12, 2010 By 6 Comments
… an overhead, that the UDF ran *much* slower than the stored routine, by magnitudes.
Comment: A micro-benchmark of stored routines in MySQL
August 17, 2009 By 7 Comments
The stored routine does a COUNT(), unlike the original query. I think you’…
Post: The feature I love in TokuDB
June 11, 2009 By 4 Comments
… standard MySQL and InnoDB more than all these triggers and stored routines! Probably will implement this in XtraDB.
Comment: Thanks Giving Challenge: How to detect replication context
November 26, 2008 By 12 Comments
… plugin that allows you to read SLAVE STATUS in a stored routine https://edge.launchpad.net/is-replication-status Cheers Giuseppe
