----- On 15 May, 2015, at 8:05 PM, Sergei Golubchik s...@mariadb.org 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.
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
