醱燠午蕭仄引允﹝
反元戶化髑嘍仄引允﹝
MySQL及燮マ杅﹜云澎蝗日井卞云湊中仄引允﹝

今化﹜憤⑹戊立永玄互＞OFF＝匹坌峊伊矛伙互＞REPEATABLE READ＝及樺寧午中丹仇午匹允互﹜SQL妐毛撢墊允月午五及濤糧交□扒互啜勻化凶曰仄引六氏匹仄斤丹井〝
凶午尹壬﹜SUPER腺蜃及交□扒匹允午﹜憤⑹戊立永玄及澀爛互拑躲午卅曰引允﹝

◢動票及扔奶玄及＞init_connect＝及＞用□玄＝毛輔寰仁分今中﹝
http://dev.mysql.com/doc/refman/5.1/ja/server-system-variables.html

動曉匹允﹝

Date: Tue, 28 Aug 2012 10:13:57 +0900
From: hiro@freegw.net
Subject: [mysql 15829] Re: mysql戊穴件玉匹瘉蕙及犯□正毛輔寰仄凶中
To: ml@mysql.gr.jp

夫欠匹允﹝

云反方丹仍介中引允﹝

颱互�墊仄凶select反輔寰左件伉□及select匹﹜⑺元select毛⑺元方丹卅正奶立件弘﹋峚匹撢墊允月皿伕弘仿丞及蔽遘憛豸侒笆啎楔牏楔縣炤貒怳狡儦蝷豸銴穈菑吨諵𧘇中次蝨搕エ飽阬摩僸鷎潔瀄噯碞噯臭瀄噯僸鷎皿伕弘仿丞及綜曰杅毛漪呿讀卞窒井棉啜尹化中月及井手襞木引六氏互﹜java﹜ruby午手卞⑺元方丹卅蜇擂卞卅勻化仄引丹及匹﹜綜曰杅及杽鎖匹反卅中方丹卞手閤尹引允﹝

呁醒及氾□皮伙尺及insert毛域喟仄化戊立永玄﹜伕□伙田永弁匹五化中引允及匹﹜玄仿件扒弁扑亦件〇匹質咥毛仄化中月仇午反割カ碧心匹允互﹜戊立永玄手仄仁反伕□伙田永弁仄凶仇午毛mysql戊穴件玉互カ摹匹五月引匹卞醒卍℅醒10卍蠢蘸及贊木互�戲允月仇午反丐月及匹仄斤丹井〝

方欠仄仁云湊中仄引允﹝

2012コ8畸28ざ 1:37 Tomohiro 'Tomo-p' KATO <tomop@teamgedoh.net>:

﹛仇氏壬氏反﹝井午丹匹允﹝

On 12/08/28 0:31, 夫欠 wrote:
> 撢反＞手仄井仄化＝午閤中﹜拺2及由正□件午⑺元方丹卞commit毛魂仄化心凶及匹允互﹜
> 瘋伕弘奶件允月引匹瘉蕙及瑛絆反潸木引六氏匹仄凶﹝
> 公丹井午閤丹午﹜窒手仄卅仁化手拺ㄠ及C3匹瘉蕙及犯□正互潸木月凜手丐曰引仄凶﹝
> 公木匹籣杅卞抔木化仄引勻凶慼鎔匹允﹝

﹛﹛域殺撢董仄化心引仄凶﹝⑺〇芢匹窒蘸井支勻化心引仄凶互﹜select妐卞
﹛"LOCK IN SHARE MODE"支"FOR UPDATE" 毛勾仃化伕永弁毛凱丿仄凶樺寧卞反﹜
﹛commit六內午手凳蕙詨及〇芢毛潸丿仄化中引允互﹜伕永弁毛凱丿仄卅中簽
﹛賬卅select妐及樺寧卞反凳蕙蟆及〇芢仄井請化五引六氏匹仄凶﹝

撢董棕雁: VineSeed + MySQL-5.5.25

*撢董1: 簽賬卅select妐
-----------------------------------------------------------------
mysql> select * from test;
+----+------+
| id | val |
+----+------+
| 1 | 100 |
+----+------+
1 row in set (0.00 sec)

(◢) 仇仇匹帎羹坱井日凳蕙

mysql> select * from test;
+----+------+
| id | val |
+----+------+
| 1 | 100 | <--------------------- 庍祭卅仄
+----+------+
1 row in set (0.00 sec)

mysql> select * from test; <------------- ゴ及凶戶瘋蘸撢墊
+----+------+
| id | val |
+----+------+
| 1 | 100 | <--------------------- 庍祭卅仄
+----+------+
1 row in set (0.01 sec)

mysql> commit; <--------------------- commit仄化心月
Query OK, 0 rows affected (0.00 sec)

mysql> select * from test;
+----+------+
| id | val |
+----+------+
| 1 | 200 | <--------------------- 庍祭丐曰
+----+------+
1 row in set (0.00 sec)
-----------------------------------------------------------------

*撢董2: 伕永弁丐曰select妐毛銀勻化心月
-----------------------------------------------------------------
mysql> select * from test;
+----+------+
| id | val |
+----+------+
| 1 | 200 |
+----+------+
1 row in set (0.00 sec)

(◢) 仇仇匹帎羹坱井日凳蕙

mysql> select * from test;
+----+------+
| id | val |
+----+------+
| 1 | 200 | <--------------------- 庍祭卅仄
+----+------+
1 row in set (0.00 sec)

mysql> select * from test for update; <-- 伕永弁丐曰匹select仄化心月
+----+------+
| id | val |
+----+------+
| 1 | 300 | <--------------------- 庍祭丐曰
+----+------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)
-----------------------------------------------------------------

﹛﹛切斤勻午衙中匹允互﹜動票及扔奶玄卞玄仿件扒弁扑亦件坌峊伊矛伙仍午及
﹛MySQL及街⑹及濩抸互丐曰引仄凶及匹仍厖仁分今中﹝

http://www.y2sunlight.com/ground/?MySQL4.1%2F9.MySQL%A4%CE%BC%C2%B8%B3%2F4.%A5%C8%A5%E9%A5%F3%A5%B6%A5%AF%A5%B7%A5%E7%A5%F3

--
__________________________________________________
_/_/ Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net>
_/_/ Team Gedoh Network http://www.teamgedoh.net/
_/_/ Key fingerprint = A6D8 3981 3575 9F00 EFC3 9C2B F03A 5383 9287 74D9