set GLOBAL query_cache_size=1355776; drop table if exists t1; CREATE FUNCTION metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB"; flush status; create table t1 (a char); select metaphon('MySQL') from t1; metaphon('MySQL') show status like 'Qcache_hits'; Variable_name Value Qcache_hits 0 select metaphon('MySQL') from t1; metaphon('MySQL') show status like 'Qcache_hits'; Variable_name Value Qcache_hits 0 drop table if exists t1;