{"action":"created","issue":{"url":"https://api.github.com/repos/catfan/Medoo/issues/329","labels_url":"https://api.github.com/repos/catfan/Medoo/issues/329/labels{/name}","comments_url":"https://api.github.com/repos/catfan/Medoo/issues/329/comments","events_url":"https://api.github.com/repos/catfan/Medoo/issues/329/events","html_url":"https://github.com/catfan/Medoo/issues/329","id":120566706,"number":329,"title":"Request : add LOW_PRIORITY statement","user":{"login":"vincent-guesnard","id":315173,"avatar_url":"https://avatars.githubusercontent.com/u/315173?v=3","gravatar_id":"","url":"https://api.github.com/users/vincent-guesnard","html_url":"https://github.com/vincent-guesnard","followers_url":"https://api.github.com/users/vincent-guesnard/followers","following_url":"https://api.github.com/users/vincent-guesnard/following{/other_user}","gists_url":"https://api.github.com/users/vincent-guesnard/gists{/gist_id}","starred_url":"https://api.github.com/users/vincent-guesnard/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vincent-guesnard/subscriptions","organizations_url":"https://api.github.com/users/vincent-guesnard/orgs","repos_url":"https://api.github.com/users/vincent-guesnard/repos","events_url":"https://api.github.com/users/vincent-guesnard/events{/privacy}","received_events_url":"https://api.github.com/users/vincent-guesnard/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-05T15:44:29Z","updated_at":"2015-12-07T11:15:28Z","closed_at":null,"body":"Hello,\r\n\r\nIt would be perfect if you could add this kind of statement to manage the priority of ours insert/update queries.\r\n\r\nAn idea : $db->insert('exemple', $insert, 'low');\r\n\r\nThanks\r\n\r\nRegards,\r\n\r\nVincent"},"comment":{"url":"https://api.github.com/repos/catfan/Medoo/issues/comments/162488065","html_url":"https://github.com/catfan/Medoo/issues/329#issuecomment-162488065","issue_url":"https://api.github.com/repos/catfan/Medoo/issues/329","id":162488065,"user":{"login":"vincent-guesnard","id":315173,"avatar_url":"https://avatars.githubusercontent.com/u/315173?v=3","gravatar_id":"","url":"https://api.github.com/users/vincent-guesnard","html_url":"https://github.com/vincent-guesnard","followers_url":"https://api.github.com/users/vincent-guesnard/followers","following_url":"https://api.github.com/users/vincent-guesnard/following{/other_user}","gists_url":"https://api.github.com/users/vincent-guesnard/gists{/gist_id}","starred_url":"https://api.github.com/users/vincent-guesnard/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vincent-guesnard/subscriptions","organizations_url":"https://api.github.com/users/vincent-guesnard/orgs","repos_url":"https://api.github.com/users/vincent-guesnard/repos","events_url":"https://api.github.com/users/vincent-guesnard/events{/privacy}","received_events_url":"https://api.github.com/users/vincent-guesnard/received_events","type":"User","site_admin":false},"created_at":"2015-12-07T11:15:28Z","updated_at":"2015-12-07T11:15:28Z","body":"Admitting that your server is dealing with a high traffic, like 500 requests per second.\r\n\r\nThe internal mechanism of MySQL is to lock tables (MyISAM) or raws (InnoDB) when an insert/update request is fire, so no SELECT can be fired meanwhile.\r\n\r\nOn heavy loaded tables, that could make thousands of requests in a waiting state (and sometimes can cause MySQL crashes).\r\n\r\nTo avoid this fact, MySQL allow you to specify a priority on your request, then MySQL will choose the \"best\" (or \"less worst\") moment to fire your insert/update.\r\n\r\n(if you add this statement, here is another usefull one : SQL_NO_CACHE)\r\n"}}