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 secur...@mariadb.org _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp