maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #06035
Re: RFC - query cache insert
i executed some tests with
set profiling=1, execute query, set profiling=0;
with the explain extended, and explain
without extended it take ~0.0014s (in my query test, a union query with
two queries with two tables and a single join)
with extended it take ~0.0019s (increase 0.0005s, 35% of overhead for
explain)
maybe 0.5ms isn't a bad thing on some queries
i will check more about the query rewrite of explain extended, but i think
it's not a big problem on some workloads
References
-
RFC - query cache insert
From: Roberto Spadim, 2013-08-05
-
Re: RFC - query cache insert
From: Oleksandr Byelkin, 2013-08-06
-
Re: RFC - query cache insert
From: Roberto Spadim, 2013-08-06
-
Re: RFC - query cache insert
From: Oleksandr Byelkin, 2013-08-07
-
Re: RFC - query cache insert
From: Roberto Spadim, 2013-08-07
-
Re: RFC - query cache insert
From: Oleksandr Byelkin, 2013-08-08
-
Re: RFC - query cache insert
From: Roberto Spadim, 2013-08-08
-
Re: RFC - query cache insert
From: Oleksandr Byelkin, 2013-08-08
-
Re: RFC - query cache insert
From: Roberto Spadim, 2013-08-08
-
Re: RFC - query cache insert
From: Oleksandr Byelkin, 2013-08-08