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
Mailing list: https://launchpad.net/~maria-discuss
Post to : firstname.lastname@example.org
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp