Home >Database >Mysql Tutorial >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?
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 growing