{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/21800","repository_url":"https://api.github.com/repos/owncloud/core","labels_url":"https://api.github.com/repos/owncloud/core/issues/21800/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/21800/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/21800/events","html_url":"https://github.com/owncloud/core/issues/21800","id":127656262,"number":21800,"title":"high mysql connections every night","user":{"login":"colttt","id":10084871,"avatar_url":"https://avatars.githubusercontent.com/u/10084871?v=3","gravatar_id":"","url":"https://api.github.com/users/colttt","html_url":"https://github.com/colttt","followers_url":"https://api.github.com/users/colttt/followers","following_url":"https://api.github.com/users/colttt/following{/other_user}","gists_url":"https://api.github.com/users/colttt/gists{/gist_id}","starred_url":"https://api.github.com/users/colttt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/colttt/subscriptions","organizations_url":"https://api.github.com/users/colttt/orgs","repos_url":"https://api.github.com/users/colttt/repos","events_url":"https://api.github.com/users/colttt/events{/privacy}","received_events_url":"https://api.github.com/users/colttt/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/needs%20info","name":"needs info","color":"0b02e1"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2016-01-20T10:49:56Z","updated_at":"2016-02-10T07:22:39Z","closed_at":null,"body":"Hello normally we've ~6 connection on our owncloud-mysql-server, but every night it goes up to more than 150.. \r\nCan you tell me why this happen, is this same reason like https://github.com/owncloud/core/issues/21224 ?\r\n\r\n![mysql_peak](https://cloud.githubusercontent.com/assets/10084871/12446599/34efe6b0-bf6b-11e5-82ce-da2aac69674e.png)\r\n\r\n```\r\n176635\towcl-user\tlocalhost\twolke7\tQuery\t224\tWriting to net\tSELECT /*!40001 SQL_NO_CACHE */ * FROM `oc_filecache`\r\n176636\towcl-user\tlocalhost\twolke7\tQuery\t349\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157151'\r\n[...]\r\n176690\towcl-user\tlocalhost\twolke7\tQuery\t301\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157199'\r\n176692\towcl-user\tlocalhost\twolke7\tQuery\t299\tWaiting for table level lock\tUPDATE `oc_preferences` SET `configvalue` = '1453157201' WHERE `userid` = 'xxx63b52-c3ae-1033-86d6-8763c51afxxx' AND `appid` = 'user_ldap' AND `configkey` = 'lastFeatureRefresh'\r\n176693\towcl-user\tlocalhost\twolke7\tQuery\t299\tWaiting for table level lock\tUPDATE `oc_preferences` SET `configvalue` = '1453157201' WHERE `userid` = 'xxx63b52-c3ae-1033-86d6-8763c51afxxx' AND `appid` = 'user_ldap' AND `configkey` = 'lastFeatureRefresh'\r\n176694\towcl-user\tlocalhost\twolke7\tQuery\t298\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157202'\r\n176695\towcl-user\tlocalhost\twolke7\tQuery\t295\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157205'\r\n[...]\r\n176771\towcl-user\tlocalhost\twolke7\tQuery\t210\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157290'\r\n176772\towcl-user\tlocalhost\twolke7\tQuery\t209\tWaiting for table level lock\tUPDATE `oc_preferences` SET `configvalue` = '1453157291' WHERE `userid` = 'xxx63b52-c3ae-1033-86d6-8763c51afxxx' AND `appid` = 'user_ldap' AND `configkey` = 'lastFeatureRefresh'\r\n176773\towcl-user\tlocalhost\twolke7\tQuery\t209\tWaiting for table level lock\tUPDATE `oc_preferences` SET `configvalue` = '1453157291' WHERE `userid` = 'xxx63b52-c3ae-1033-86d6-8763c51afxxx' AND `appid` = 'user_ldap' AND `configkey` = 'lastFeatureRefresh'\r\n176774\towcl-user\tlocalhost\twolke7\tQuery\t209\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157291'\r\n[...]\r\n176815\towcl-user\tlocalhost\twolke7\tQuery\t145\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157355'\r\n176816\towcl-user\tlocalhost\twolke7\tQuery\t143\tWaiting for table level lock\tUPDATE `oc_preferences` SET `configvalue` = '1453157357' WHERE `userid` = 'xxx67c54-7e2a-1030-89f7-a1198bbfexxx' AND `appid` = 'user_ldap' AND `configkey` = 'lastFeatureRefresh'\r\n176817\towcl-user\tlocalhost\twolke7\tQuery\t141\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157359'\r\n176819\towcl-user\tlocalhost\twolke7\tQuery\t138\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157362'[...]\r\n176856\towcl-user\tlocalhost\twolke7\tQuery\t69\tWaiting for table level lock\tDELETE FROM `oc_file_locks` WHERE `lock` = 0 AND `ttl` < '1453157431'\r\n176877\troot\tlocalhost\tNULL\tQuery\t0\tNULL\tSHOW full processlist\r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/182235767","html_url":"https://github.com/owncloud/core/issues/21800#issuecomment-182235767","issue_url":"https://api.github.com/repos/owncloud/core/issues/21800","id":182235767,"user":{"login":"colttt","id":10084871,"avatar_url":"https://avatars.githubusercontent.com/u/10084871?v=3","gravatar_id":"","url":"https://api.github.com/users/colttt","html_url":"https://github.com/colttt","followers_url":"https://api.github.com/users/colttt/followers","following_url":"https://api.github.com/users/colttt/following{/other_user}","gists_url":"https://api.github.com/users/colttt/gists{/gist_id}","starred_url":"https://api.github.com/users/colttt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/colttt/subscriptions","organizations_url":"https://api.github.com/users/colttt/orgs","repos_url":"https://api.github.com/users/colttt/repos","events_url":"https://api.github.com/users/colttt/events{/privacy}","received_events_url":"https://api.github.com/users/colttt/received_events","type":"User","site_admin":false},"created_at":"2016-02-10T07:22:39Z","updated_at":"2016-02-10T07:22:39Z","body":"Hello, in attach the output from \"SHOW full processlist\"\r\n[show_full_processlist.log.zip](https://github.com/owncloud/core/files/124314/show_full_processlist.log.zip)\r\n\r\n"}}