maria-discuss team mailing list archive
Mailing list archive
Re: [MARIADB 5.5] Profiling truncated
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