Home  >  Article  >  Database  >  mysql-Why is the sleep of one database released locally and on the server in my project, but not the sleep of the other database?

mysql-Why is the sleep of one database released locally and on the server in my project, but not the sleep of the other database?

WBOY
WBOYOriginal
2016-08-20 08:47:581435browse

mysqlsleep process

When my project is running locally, when the sql statement query ends, the sleep of this query will be released, and the sleep time will not exceed 60, but it is different on the server. The sql statement will return to marriage after running. After that, the process does not seem to be released, and the sleep state time continues to grow, even reaching thousands. The current project code, database version, software, tomcat server, and release methods are exactly the same. The local system is Windows 8, and the server system is Window Server 2003, please give me some advice. Is there any configuration that I haven't configured properly, or which configuration attribute will affect it? Because the local computer was configured by others before, and the server was configured by me. The project framework is spring+mybaits, and the database is mysql5. 5. There are two database show processlist commands attached to the server tomcat7. The sleep and time in them are completely different. One is normal and the other is growingmysql-Why is the sleep of one database released locally and on the server in my project, but not the sleep of the other database?mysql-Why is the sleep of one database released locally and on the server in my project, but not the sleep of the other database?

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn