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? Regards, Sergei Chief Architect MariaDB and security@mariadb.org