Shulou(Shulou.com)06/01 Report--

1.slow_launch_time

Command-Line Format--slow_launch_time=#System VariableNameslow_launch_timeVariable ScopeGlobalDynamic VariableYesPermitted ValuesTypeintegerDefault2

If creating a thread takes longer than this many seconds, the server increments the Slow_launch_threadsstatus variable.

If it takes more time to create a thread than slow_launch_time, the server increments the state variable of Slow_launch_threads.

Slow_launch_threads

The number of threads that have taken more than slow_launch_time seconds to create.

The number of threads that have been created for more than slow_launch_time.

2.long_query_time

Command-Line Format--long_query_time=#System VariableNamelong_query_timeVariable ScopeGlobal, SessionDynamic VariableYesPermitted ValuesTypenumericDefault10Min Value0

If a query takes longer than this many seconds, the server increments the Slow_queries status variable. If the slow query log is enabled, the query is logged to the slow query log file. This value is measured in real time, not CPU time, so a query that is under the threshold on a lightly loaded system might be above the threshold on a heavily loaded one. The minimum and default values of long_query_time are 0 and 10, respectively. The value can be specified to a resolution of microseconds. For logging to a file, times are written including the microseconds part. For logging to tables, only integer times are written; the microseconds part is ignored.

If the query takes more time than long_query_time, the server increases the state variable of slow_queries. If the slow log is enabled, the query is logged to the slow log file. This value is measured in real time, not the CPU time, so a query under the threshold of a light load system may be higher than the threshold of a heavily loaded system. The minimum and default long_query_time are 0 and 10, respectively. This value can be accurate to microseconds. If recorded in a file, the time includes the microsecond part. If recorded to the table, only the integer part; the microsecond part is ignored.

Slow_queries

The number of queries that have taken more than long_query_time seconds. This counter increments regardless of whether the slow query log is enabled.

The number of queries whose query time exceeds long_query_time, and the increase in this number has nothing to do with whether the slow query log is started.

Conclusion: as can be seen from the above, slow_launch_time and long_query_time look alike, but their relationship is not so close.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.