Slow Query Execution events identify slow queries that are related to database performance that can directly influence Web server performance.
Slow queries, if not pinpointed, can bring the server down by:
Causing excess web server processes (Apache).
Hang up queries in the database causing slower responses in the database.
These events do not require any additional configurations to the database. Production environments can use this information to pinpoint performance bottlenecks in the database.
Generates an event whenever database related function execution rises above the given threshold. This event is directly associated to the "Slow Function Execution" event and is activated and defined in correlation with this event type.
Database functions that should be reported are defined in the "Slow Function Execution" function list (in additional rules).
To view supported databases, see the database related function prefixes listed in linux/unix/mac/i5OS <install_dir>/lib/db_functions.txt or in Windows <install_dir>\lib\db_functions.txt.