By default, query profiling is turned on. The profiling feature can be turned off by setting the [server] profiling parameter (see profiling on page 46) to false.

The maximum number of profiles to be kept in memory can be configured using the [server] max_profiles_per_database and max_profiles_per_session configuration parameters.