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

This article mainly introduces "the process of configuring variables in mysql". In daily operation, I believe that many people have doubts about the process of configuring variables in mysql. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "the process of configuring variables in mysql". Next, please follow the editor to study!

Mysql configuration variable

Document

Refer to-/ * View slow query time * /-- set global slow_query_log=ON;-- set global long_query_time=3;-- show variables like "long_query_time";-- show variables like 'slow%';-- SELECT SLEEP (5);-- View the number of slow queries-- show global status like'% slow%';set GLOBAL max_connections=100; show variables like "max_connections"

At this point, the study of "the process of configuring variables in mysql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.