← Back to team overview

maria-discuss team mailing list archive

Re: [MARIADB 5.5] Profiling truncated


Hi, Fabien!

On Feb 08, Fabien CLERC wrote:
> Hello, I'm trying to profile a very long query in production (MariaDB 5.5)
> using "set session profiling = 1" but when I run the command "show profile
> for query 1", there is only the only 100 last steps of the query.
> It's the same checking in "INFORMATION_SCHEMA.PROFILING"
> I understand the parameter "profiling_history_size" is the maximum number
> of queries and not the maximum steps stored fora query.
> => How can I change the number of steps available in the result of the
> profiling ?

It seems this limit is hard-coded and cannot be changed
without recompiling MariaDB.

Do you really have a query with more than a 100 of states?
Could you show what your profile looks like?

Chief Architect MariaDB
and security@xxxxxxxxxxx