…stop with an error. Example: mysql> CREATE FUNCTION this_year() RETURNS INT DETERMINISTIC RETURN YEAR(CURDATE()); mysql> insert into t VALUES(this_year…())’ STORED PROCEDURES The behaviour of stored procedures and functions are completely different. If our stored procedure write data to our tables …
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
Post: Memory allocation in Stored Function
August 26, 2007 By 8 Comments
…table with 10mil+ rows, and, as the manipulation was non-trivial, I decided this task is good to try Stored Function. Function…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
… data set against two MySQL column-store storage engines. I… avg(char_column) from table” where the column contains …functions as ICE, and therefore it could not run some of the queries. ICE supports almost all of the MySQL aggregation functions…_fact” when run on InfiniDB returned a number that was…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…MySQL stored procedure API, called the SQL_API which is used to define the view. These stored…function call. This function reads the meta-data stored in the Flexviews data dictionary. It returns the SQL which represents the data stored…
Post: Stored Function to generate Sequences
April 2, 2008 By 17 Comments
…. This 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… generated on central server and when stored on number of servers or to number of individual tables. Finally your own sequences allow…
Post: A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
… subquery and basically rewrote it as a stored function. mysql> delimiter // mysql> create function speaks_english(c char(3)) returns integer deterministic > begin > declare res int… we explain it, we get output similar to the first table shown above, but the further two rows are not shown…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…shows. In MySQL 5.5 you can find in sql/datadict.cc a function named dd_frm_type(). In MySQL 5.1, for…of the FRM file. This is due to VIEWs being stored as the plain text of the SQL query inside … table type (I think, I haven’t gone back into the deep history of the FRM file format to confirm) return…
Post: Bug#12704861
November 20, 2011 By 1 Comment
…problem that is fixed in MySQL 5.1.60. I’… updated in an InnoDB table. (Bug #12704861)” This wasn’…storing the BLOBs, or freed (nonfree=FALSE) before committing the mini-transaction. btr_freed_leaves_validate(): A debug function…(): Refactored from btr_page_alloc(). Return the number of the allocated…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… relevance sorting to the MySQL queries would make them even…are in volatile memory, not stored on disk, you are…Search indexes will be returned by Sphinx Search queries. Mike … search would necessarily do table-scans. Jessy B. also asked… requirements for the FT functionality. So one solution may…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you … which is used to store query execution time and lock time does not store fractions of the second….other handly feature would be the function which returns as as SET list of tables which query is using. This …
