{"action":"created","issue":{"url":"https://api.github.com/repos/felixge/node-mysql/issues/1023","labels_url":"https://api.github.com/repos/felixge/node-mysql/issues/1023/labels{/name}","comments_url":"https://api.github.com/repos/felixge/node-mysql/issues/1023/comments","events_url":"https://api.github.com/repos/felixge/node-mysql/issues/1023/events","html_url":"https://github.com/felixge/node-mysql/issues/1023","id":60203777,"number":1023,"title":"Sorry,but issue not resolved.Error: Connection lost: The server closed the connection","user":{"login":"chacent","id":8600635,"avatar_url":"https://avatars.githubusercontent.com/u/8600635?v=3","gravatar_id":"","url":"https://api.github.com/users/chacent","html_url":"https://github.com/chacent","followers_url":"https://api.github.com/users/chacent/followers","following_url":"https://api.github.com/users/chacent/following{/other_user}","gists_url":"https://api.github.com/users/chacent/gists{/gist_id}","starred_url":"https://api.github.com/users/chacent/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chacent/subscriptions","organizations_url":"https://api.github.com/users/chacent/orgs","repos_url":"https://api.github.com/users/chacent/repos","events_url":"https://api.github.com/users/chacent/events{/privacy}","received_events_url":"https://api.github.com/users/chacent/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/felixge/node-mysql/labels/question","name":"question","color":"d4c5f9"}],"state":"closed","locked":false,"assignee":{"login":"dougwilson","id":67512,"avatar_url":"https://avatars.githubusercontent.com/u/67512?v=3","gravatar_id":"","url":"https://api.github.com/users/dougwilson","html_url":"https://github.com/dougwilson","followers_url":"https://api.github.com/users/dougwilson/followers","following_url":"https://api.github.com/users/dougwilson/following{/other_user}","gists_url":"https://api.github.com/users/dougwilson/gists{/gist_id}","starred_url":"https://api.github.com/users/dougwilson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dougwilson/subscriptions","organizations_url":"https://api.github.com/users/dougwilson/orgs","repos_url":"https://api.github.com/users/dougwilson/repos","events_url":"https://api.github.com/users/dougwilson/events{/privacy}","received_events_url":"https://api.github.com/users/dougwilson/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2015-03-07T12:07:32Z","updated_at":"2015-03-08T04:27:52Z","closed_at":"2015-03-08T02:36:52Z","body":"https://github.com/felixge/node-mysql/issues/1022,\r\nI'm not sure that you will care this issue if i conntine in last thread,so i write a new report.\r\n\r\nyou have give me two solutions,both is not useful.\r\nthe first one,recordset is very large, if i buffer it in memory ,nodejs will crash.\r\nthe last one,i had setted wait_timeout and interactive_timeout, but it isn't what i wanted.in my case it isn't useful.\r\n\r\ni can descript it simply,\r\nconnection.connect()->\r\nquery(\"select * from table\")//where table is very large,and record is also very large->\r\nfetch(count)//where count is great than 0,for example 100->\r\nsleep(ms)//ms is a long time->\r\nfetch(count)// if last ms between 1-45000,verything is ok,but if ms great than about 50000,\r\nerror occured\r\n"},"comment":{"url":"https://api.github.com/repos/felixge/node-mysql/issues/comments/77732562","html_url":"https://github.com/felixge/node-mysql/issues/1023#issuecomment-77732562","issue_url":"https://api.github.com/repos/felixge/node-mysql/issues/1023","id":77732562,"user":{"login":"dougwilson","id":67512,"avatar_url":"https://avatars.githubusercontent.com/u/67512?v=3","gravatar_id":"","url":"https://api.github.com/users/dougwilson","html_url":"https://github.com/dougwilson","followers_url":"https://api.github.com/users/dougwilson/followers","following_url":"https://api.github.com/users/dougwilson/following{/other_user}","gists_url":"https://api.github.com/users/dougwilson/gists{/gist_id}","starred_url":"https://api.github.com/users/dougwilson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dougwilson/subscriptions","organizations_url":"https://api.github.com/users/dougwilson/orgs","repos_url":"https://api.github.com/users/dougwilson/repos","events_url":"https://api.github.com/users/dougwilson/events{/privacy}","received_events_url":"https://api.github.com/users/dougwilson/received_events","type":"User","site_admin":false},"created_at":"2015-03-08T04:27:52Z","updated_at":"2015-03-08T04:27:52Z","body":"Ok. I'm also sorry that I don't always understand what you are saying :( In the end, the issue you are having cannot be solved by this library. You have to either tweak your MySQL server settings to change the way in which you are performing your query.\r\n\r\nYou may also want to look into other node.js MySQL libraries like \"mysql2\" in case they behave in a way more compatible with your workflow."}}