{"action":"created","comment":{"url":"https://api.github.com/repos/pingcap/docs/pulls/comments/195337964","pull_request_review_id":128684703,"id":195337964,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDE5NTMzNzk2NA==","diff_hunk":"@@ -218,8 +223,15 @@ If you need to set the global variable, run:\n - Scope: SERVER\n - Default value: 0\n - This variable is used to set whether to enable Streaming.\n- \n-## Optimizer hint\n+\n+## tidb_retry_limit\n+\n+- Scope: SESSION | GLOBAL\n+- Default value: 10\n+- When a transaction encounters errors that support retries, such as transaction conflicts and TiKV busy, this transaction can be re-executed. This variable is used to set the maximum number of the retries.","path":"sql/tidb-specific.md","position":34,"original_position":34,"commit_id":"61976b736ae682e0416a3ee9c934dcf96c4aa8c4","original_commit_id":"61976b736ae682e0416a3ee9c934dcf96c4aa8c4","user":{"login":"shenli","id":1192573,"node_id":"MDQ6VXNlcjExOTI1NzM=","avatar_url":"https://avatars0.githubusercontent.com/u/1192573?v=4","gravatar_id":"","url":"https://api.github.com/users/shenli","html_url":"https://github.com/shenli","followers_url":"https://api.github.com/users/shenli/followers","following_url":"https://api.github.com/users/shenli/following{/other_user}","gists_url":"https://api.github.com/users/shenli/gists{/gist_id}","starred_url":"https://api.github.com/users/shenli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shenli/subscriptions","organizations_url":"https://api.github.com/users/shenli/orgs","repos_url":"https://api.github.com/users/shenli/repos","events_url":"https://api.github.com/users/shenli/events{/privacy}","received_events_url":"https://api.github.com/users/shenli/received_events","type":"User","site_admin":false},"body":"s/errors that support retries/retriable errors/","created_at":"2018-06-14T08:23:27Z","updated_at":"2018-06-14T08:23:52Z","html_url":"https://github.com/pingcap/docs/pull/501#discussion_r195337964","pull_request_url":"https://api.github.com/repos/pingcap/docs/pulls/501","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/pingcap/docs/pulls/comments/195337964"},"html":{"href":"https://github.com/pingcap/docs/pull/501#discussion_r195337964"},"pull_request":{"href":"https://api.github.com/repos/pingcap/docs/pulls/501"}}},"pull_request":{"url":"https://api.github.com/repos/pingcap/docs/pulls/501","id":194768660,"node_id":"MDExOlB1bGxSZXF1ZXN0MTk0NzY4NjYw","html_url":"https://github.com/pingcap/docs/pull/501","diff_url":"https://github.com/pingcap/docs/pull/501.diff","patch_url":"https://github.com/pingcap/docs/pull/501.patch","issue_url":"https://api.github.com/repos/pingcap/docs/issues/501","number":501,"state":"open","locked":false,"title":"sql: add tidb_retry_limit","user":{"login":"lilin90","id":30922556,"node_id":"MDQ6VXNlcjMwOTIyNTU2","avatar_url":"https://avatars1.githubusercontent.com/u/30922556?v=4","gravatar_id":"","url":"https://api.github.com/users/lilin90","html_url":"https://github.com/lilin90","followers_url":"https://api.github.com/users/lilin90/followers","following_url":"https://api.github.com/users/lilin90/following{/other_user}","gists_url":"https://api.github.com/users/lilin90/gists{/gist_id}","starred_url":"https://api.github.com/users/lilin90/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lilin90/subscriptions","organizations_url":"https://api.github.com/users/lilin90/orgs","repos_url":"https://api.github.com/users/lilin90/repos","events_url":"https://api.github.com/users/lilin90/events{/privacy}","received_events_url":"https://api.github.com/users/lilin90/received_events","type":"User","site_admin":false},"body":"@zimulala @CaitinChen PTAL\r\nVia: https://github.com/pingcap/docs-cn/pull/764","created_at":"2018-06-14T03:18:43Z","updated_at":"2018-06-14T08:23:52Z","closed_at":null,"merged_at":null,"merge_commit_sha":"7a4256a70ee4a901675626f7ae6e67dad464332b","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/pingcap/docs/pulls/501/commits","review_comments_url":"https://api.github.com/repos/pingcap/docs/pulls/501/comments","review_comment_url":"https://api.github.com/repos/pingcap/docs/pulls/comments{/number}","comments_url":"https://api.github.com/repos/pingcap/docs/issues/501/comments","statuses_url":"https://api.github.com/repos/pingcap/docs/statuses/61976b736ae682e0416a3ee9c934dcf96c4aa8c4","head":{"label":"lilin90:retry-time","ref":"retry-time","sha":"61976b736ae682e0416a3ee9c934dcf96c4aa8c4","user":{"login":"lilin90","id":30922556,"node_id":"MDQ6VXNlcjMwOTIyNTU2","avatar_url":"https://avatars1.githubusercontent.com/u/30922556?v=4","gravatar_id":"","url":"https://api.github.com/users/lilin90","html_url":"https://github.com/lilin90","followers_url":"https://api.github.com/users/lilin90/followers","following_url":"https://api.github.com/users/lilin90/following{/other_user}","gists_url":"https://api.github.com/users/lilin90/gists{/gist_id}","starred_url":"https://api.github.com/users/lilin90/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lilin90/subscriptions","organizations_url":"https://api.github.com/users/lilin90/orgs","repos_url":"https://api.github.com/users/lilin90/repos","events_url":"https://api.github.com/users/lilin90/events{/privacy}","received_events_url":"https://api.github.com/users/lilin90/received_events","type":"User","site_admin":false},"repo":{"id":116111014,"node_id":"MDEwOlJlcG9zaXRvcnkxMTYxMTEwMTQ=","name":"docs","full_name":"lilin90/docs","owner":{"login":"lilin90","id":30922556,"node_id":"MDQ6VXNlcjMwOTIyNTU2","avatar_url":"https://avatars1.githubusercontent.com/u/30922556?v=4","gravatar_id":"","url":"https://api.github.com/users/lilin90","html_url":"https://github.com/lilin90","followers_url":"https://api.github.com/users/lilin90/followers","following_url":"https://api.github.com/users/lilin90/following{/other_user}","gists_url":"https://api.github.com/users/lilin90/gists{/gist_id}","starred_url":"https://api.github.com/users/lilin90/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lilin90/subscriptions","organizations_url":"https://api.github.com/users/lilin90/orgs","repos_url":"https://api.github.com/users/lilin90/repos","events_url":"https://api.github.com/users/lilin90/events{/privacy}","received_events_url":"https://api.github.com/users/lilin90/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/lilin90/docs","description":"TiDB/TiKV/PD documents.","fork":true,"url":"https://api.github.com/repos/lilin90/docs","forks_url":"https://api.github.com/repos/lilin90/docs/forks","keys_url":"https://api.github.com/repos/lilin90/docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/lilin90/docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/lilin90/docs/teams","hooks_url":"https://api.github.com/repos/lilin90/docs/hooks","issue_events_url":"https://api.github.com/repos/lilin90/docs/issues/events{/number}","events_url":"https://api.github.com/repos/lilin90/docs/events","assignees_url":"https://api.github.com/repos/lilin90/docs/assignees{/user}","branches_url":"https://api.github.com/repos/lilin90/docs/branches{/branch}","tags_url":"https://api.github.com/repos/lilin90/docs/tags","blobs_url":"https://api.github.com/repos/lilin90/docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/lilin90/docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/lilin90/docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/lilin90/docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/lilin90/docs/statuses/{sha}","languages_url":"https://api.github.com/repos/lilin90/docs/languages","stargazers_url":"https://api.github.com/repos/lilin90/docs/stargazers","contributors_url":"https://api.github.com/repos/lilin90/docs/contributors","subscribers_url":"https://api.github.com/repos/lilin90/docs/subscribers","subscription_url":"https://api.github.com/repos/lilin90/docs/subscription","commits_url":"https://api.github.com/repos/lilin90/docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/lilin90/docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/lilin90/docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/lilin90/docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/lilin90/docs/contents/{+path}","compare_url":"https://api.github.com/repos/lilin90/docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/lilin90/docs/merges","archive_url":"https://api.github.com/repos/lilin90/docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/lilin90/docs/downloads","issues_url":"https://api.github.com/repos/lilin90/docs/issues{/number}","pulls_url":"https://api.github.com/repos/lilin90/docs/pulls{/number}","milestones_url":"https://api.github.com/repos/lilin90/docs/milestones{/number}","notifications_url":"https://api.github.com/repos/lilin90/docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/lilin90/docs/labels{/name}","releases_url":"https://api.github.com/repos/lilin90/docs/releases{/id}","deployments_url":"https://api.github.com/repos/lilin90/docs/deployments","created_at":"2018-01-03T08:18:49Z","updated_at":"2018-06-14T08:23:24Z","pushed_at":"2018-06-14T08:23:23Z","git_url":"git://github.com/lilin90/docs.git","ssh_url":"git@github.com:lilin90/docs.git","clone_url":"https://github.com/lilin90/docs.git","svn_url":"https://github.com/lilin90/docs","homepage":"https://pingcap.github.io/docs","size":6829,"stargazers_count":0,"watchers_count":0,"language":"HTML","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"pingcap:master","ref":"master","sha":"40ebc4f7dcaa1bd0f775b5a17ca92f4f1530004d","user":{"login":"pingcap","id":11855343,"node_id":"MDEyOk9yZ2FuaXphdGlvbjExODU1MzQz","avatar_url":"https://avatars3.githubusercontent.com/u/11855343?v=4","gravatar_id":"","url":"https://api.github.com/users/pingcap","html_url":"https://github.com/pingcap","followers_url":"https://api.github.com/users/pingcap/followers","following_url":"https://api.github.com/users/pingcap/following{/other_user}","gists_url":"https://api.github.com/users/pingcap/gists{/gist_id}","starred_url":"https://api.github.com/users/pingcap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pingcap/subscriptions","organizations_url":"https://api.github.com/users/pingcap/orgs","repos_url":"https://api.github.com/users/pingcap/repos","events_url":"https://api.github.com/users/pingcap/events{/privacy}","received_events_url":"https://api.github.com/users/pingcap/received_events","type":"Organization","site_admin":false},"repo":{"id":63995402,"node_id":"MDEwOlJlcG9zaXRvcnk2Mzk5NTQwMg==","name":"docs","full_name":"pingcap/docs","owner":{"login":"pingcap","id":11855343,"node_id":"MDEyOk9yZ2FuaXphdGlvbjExODU1MzQz","avatar_url":"https://avatars3.githubusercontent.com/u/11855343?v=4","gravatar_id":"","url":"https://api.github.com/users/pingcap","html_url":"https://github.com/pingcap","followers_url":"https://api.github.com/users/pingcap/followers","following_url":"https://api.github.com/users/pingcap/following{/other_user}","gists_url":"https://api.github.com/users/pingcap/gists{/gist_id}","starred_url":"https://api.github.com/users/pingcap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pingcap/subscriptions","organizations_url":"https://api.github.com/users/pingcap/orgs","repos_url":"https://api.github.com/users/pingcap/repos","events_url":"https://api.github.com/users/pingcap/events{/privacy}","received_events_url":"https://api.github.com/users/pingcap/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/pingcap/docs","description":"TiDB/TiKV/PD documents.","fork":false,"url":"https://api.github.com/repos/pingcap/docs","forks_url":"https://api.github.com/repos/pingcap/docs/forks","keys_url":"https://api.github.com/repos/pingcap/docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pingcap/docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pingcap/docs/teams","hooks_url":"https://api.github.com/repos/pingcap/docs/hooks","issue_events_url":"https://api.github.com/repos/pingcap/docs/issues/events{/number}","events_url":"https://api.github.com/repos/pingcap/docs/events","assignees_url":"https://api.github.com/repos/pingcap/docs/assignees{/user}","branches_url":"https://api.github.com/repos/pingcap/docs/branches{/branch}","tags_url":"https://api.github.com/repos/pingcap/docs/tags","blobs_url":"https://api.github.com/repos/pingcap/docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pingcap/docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pingcap/docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/pingcap/docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pingcap/docs/statuses/{sha}","languages_url":"https://api.github.com/repos/pingcap/docs/languages","stargazers_url":"https://api.github.com/repos/pingcap/docs/stargazers","contributors_url":"https://api.github.com/repos/pingcap/docs/contributors","subscribers_url":"https://api.github.com/repos/pingcap/docs/subscribers","subscription_url":"https://api.github.com/repos/pingcap/docs/subscription","commits_url":"https://api.github.com/repos/pingcap/docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/pingcap/docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/pingcap/docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/pingcap/docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/pingcap/docs/contents/{+path}","compare_url":"https://api.github.com/repos/pingcap/docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pingcap/docs/merges","archive_url":"https://api.github.com/repos/pingcap/docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pingcap/docs/downloads","issues_url":"https://api.github.com/repos/pingcap/docs/issues{/number}","pulls_url":"https://api.github.com/repos/pingcap/docs/pulls{/number}","milestones_url":"https://api.github.com/repos/pingcap/docs/milestones{/number}","notifications_url":"https://api.github.com/repos/pingcap/docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pingcap/docs/labels{/name}","releases_url":"https://api.github.com/repos/pingcap/docs/releases{/id}","deployments_url":"https://api.github.com/repos/pingcap/docs/deployments","created_at":"2016-07-23T02:39:04Z","updated_at":"2018-06-14T07:59:14Z","pushed_at":"2018-06-14T08:19:03Z","git_url":"git://github.com/pingcap/docs.git","ssh_url":"git@github.com:pingcap/docs.git","clone_url":"https://github.com/pingcap/docs.git","svn_url":"https://github.com/pingcap/docs","homepage":"https://pingcap.github.io/docs","size":3786,"stargazers_count":159,"watchers_count":159,"language":"HTML","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":101,"mirror_url":null,"archived":false,"open_issues_count":20,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":101,"open_issues":20,"watchers":159,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/pingcap/docs/pulls/501"},"html":{"href":"https://github.com/pingcap/docs/pull/501"},"issue":{"href":"https://api.github.com/repos/pingcap/docs/issues/501"},"comments":{"href":"https://api.github.com/repos/pingcap/docs/issues/501/comments"},"review_comments":{"href":"https://api.github.com/repos/pingcap/docs/pulls/501/comments"},"review_comment":{"href":"https://api.github.com/repos/pingcap/docs/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/pingcap/docs/pulls/501/commits"},"statuses":{"href":"https://api.github.com/repos/pingcap/docs/statuses/61976b736ae682e0416a3ee9c934dcf96c4aa8c4"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"shenli"}}