{"action":"created","issue":{"url":"https://api.github.com/repos/mysql-net/MySqlConnector/issues/569","repository_url":"https://api.github.com/repos/mysql-net/MySqlConnector","labels_url":"https://api.github.com/repos/mysql-net/MySqlConnector/issues/569/labels{/name}","comments_url":"https://api.github.com/repos/mysql-net/MySqlConnector/issues/569/comments","events_url":"https://api.github.com/repos/mysql-net/MySqlConnector/issues/569/events","html_url":"https://github.com/mysql-net/MySqlConnector/issues/569","id":368751765,"node_id":"MDU6SXNzdWUzNjg3NTE3NjU=","number":569,"title":"Heavy usage of information schema periodically causing server performance issue","user":{"login":"badbod99","id":7858558,"node_id":"MDQ6VXNlcjc4NTg1NTg=","avatar_url":"https://avatars3.githubusercontent.com/u/7858558?v=4","gravatar_id":"","url":"https://api.github.com/users/badbod99","html_url":"https://github.com/badbod99","followers_url":"https://api.github.com/users/badbod99/followers","following_url":"https://api.github.com/users/badbod99/following{/other_user}","gists_url":"https://api.github.com/users/badbod99/gists{/gist_id}","starred_url":"https://api.github.com/users/badbod99/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/badbod99/subscriptions","organizations_url":"https://api.github.com/users/badbod99/orgs","repos_url":"https://api.github.com/users/badbod99/repos","events_url":"https://api.github.com/users/badbod99/events{/privacy}","received_events_url":"https://api.github.com/users/badbod99/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2018-10-10T16:35:32Z","updated_at":"2018-10-10T21:17:50Z","closed_at":null,"author_association":"NONE","body":"Every hour or so (sorry, despite watching all day not been able to identify exact pattern), we are seeing our MySQL Server Load Average hit 70+ (32CPU box).  From looking at innotop, I can see a massive queue of these sort of queries\r\n\r\n```SELECT ORDINAL_POSITION, PARAMETER_MODE, PARAMETER_NAME, DATA_TYPE, DTD_IDENTIFIER FROM information_schema.parameters WHERE SPECIFIC_SCHEMA = 'plus' AND SPECIFIC_NAME = 'mysp' ORDER BY ORDINAL_POSITION;```\r\n\r\nThese seem to be triggered by the stored procedure cache logic.  My original thought was that the Web Server was recycling the app pool, thus disposing the memory area used by the connection pool and thus the stored procedure cache.  So I set the Web Server to AlwaysOn and the IdleTimeout to zero.  The issue still occurs.\r\n\r\nIs there something which triggers a connection pool clean up or recycle on interval?  Monitoring reports that the app pool is not restarting within IIS, so seems it's something on interval within the software.\r\n\r\nThis is going to be very difficult to simulate in a simple package as we have 8000+ stored procedures and thousands of users on the system at any one point.  I wouldn't know where to start to replicate as this issue has only started occurring recently.\r\n"},"comment":{"url":"https://api.github.com/repos/mysql-net/MySqlConnector/issues/comments/428735363","html_url":"https://github.com/mysql-net/MySqlConnector/issues/569#issuecomment-428735363","issue_url":"https://api.github.com/repos/mysql-net/MySqlConnector/issues/569","id":428735363,"node_id":"MDEyOklzc3VlQ29tbWVudDQyODczNTM2Mw==","user":{"login":"badbod99","id":7858558,"node_id":"MDQ6VXNlcjc4NTg1NTg=","avatar_url":"https://avatars3.githubusercontent.com/u/7858558?v=4","gravatar_id":"","url":"https://api.github.com/users/badbod99","html_url":"https://github.com/badbod99","followers_url":"https://api.github.com/users/badbod99/followers","following_url":"https://api.github.com/users/badbod99/following{/other_user}","gists_url":"https://api.github.com/users/badbod99/gists{/gist_id}","starred_url":"https://api.github.com/users/badbod99/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/badbod99/subscriptions","organizations_url":"https://api.github.com/users/badbod99/orgs","repos_url":"https://api.github.com/users/badbod99/repos","events_url":"https://api.github.com/users/badbod99/events{/privacy}","received_events_url":"https://api.github.com/users/badbod99/received_events","type":"User","site_admin":false},"created_at":"2018-10-10T21:17:50Z","updated_at":"2018-10-10T21:17:50Z","author_association":"NONE","body":"We have a test system which we can run a new release on with logging. We won't see the load or backlog of queries on there, but if the cache isn't being populated correctly, should show up in the logging."}}
{"actor":{"display_login":"badbod99"}}