← Back to team overview

maria-discuss team mailing list archive

Re: query cache dump_at_shutdown/load_at_startup useful + no character set/collation?

 


----- On 15 May, 2015, at 8:05 PM, Sergei Golubchik serg@xxxxxxxxxxx wrote:
 
>> Are query cache results actually predictable if they have the same
>> statement running in a different session character set/collation?
> 
> Yes, of course.
> See in sql_cache.{h,cc} the structure Query_cache_query_flags and what's
> in there.
> 
> But query_cache_info plugin doesn't show flags.

Ah, thanks for the tip.

>> Anyone see a work around to get the restore file usable on all
>> queries?
> 
> Perhaps, extending query_cache_info plugin to show flags?

Yep, almost got there ( https://github.com/MariaDB/server/pull/67 ) until I realised this has been done already in MDEV-4682 / https://github.com/MariaDB/server/pull/6

Been in review for over 6 months.

> Your script will  need to restore a lot more than just a collation.
> Some flags cannot be set from the sql script whatsoever - but you can
> skip these entries in your "select concat" query.

yep. easily.


-- 
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.


References