Mysql ÀÚ·á½Ç
Vote Reply Modify Delete Forward Prev Next List

  ÀÛ¼ºÀÚ   : Á¶¼ºÈ¯ [ ladmin ] Ãßõ: 929, ¼öÁ¤: 1, Á¶È¸: 3228, ÁÙ¼ö: 40, ºÐ·ù: Etc.
MYSQL - innoDB ÀÇ Transaction(Æ®·£Àè¼Ç) ÀÇ °³³ä ¹× ¼³Á¤

Ãâó : http://www.cyworld.com/be2u/230370



DB¿¡ ƯÁ¤ µ¥ÀÌÅ͸¦ Insert ¹× update¸¦ ´ÙÁßÀûÀ¸·Î µ¿½Ã¿¡ Àû¿ëÇÒ ¶§°¡ ÀÖ´Ù.


¿¹¸¦µé¾î, atable¿¡ ƯÁ¤ µ¥ÀÌÅ͸¦ ÀÔ·ÂÇϸé, membertable¿¡ point¸¦ Áõ°¡ ½ÃŰ°Å³ª ÇÒ¶§ µîµîÀÌ´Ù.


À̶§ ¼ø¼­µµ°¡

"insert atable" => "update memberstable" À̶ó°í ÇÒ¶§,(¼ø¼­°¡ ¹Ù²î¾îµµ °Â³äÀº µ¿ÀÏÇÏ´Ù)


"insert"°¡ Á¤»óÀûÀ¸·Î ÀÌ·ç¾îÁ³Áö¸¸, "update"¿¡¼­ ¿À·ù°¡ ³¯¶§°¡ ÀÖ´Ù.


À̶§ membertable¿¡ ´ëÇÑ point °ªÀÌ Á¤»óÀûÀ¸·Î 󸮵ǾîÁöÁö¸øÇϰí, insert¸¸ µÇ¾îÁö´Â°Ô ÀϹÝÀûÀÌ´Ù.


ÇÏÁö¸¸ Mysql¿¡¼­ Áö¿øÇÏ´Â innoDBŸÀÔÀ» »ç¿ëÇÒ°æ¿ì Transaction(Æ®·£Á§¼Ç)ÀÇ ¼³Á¤À» »ç¿ëÇÏ¿©, ´ÙÁß table¿¡ µû¸¥ valueÀÇ µ¿±âÈ­ÀÇ Á¤»óÈ­¸¦ ÀÌ·ê¼ö°¡ ÀÖ´Ù.



TransactionÀÇ °æ¿ì, ½ÃÀÛÁ¡°ú ¿Ï·áÁ¡ÀÇ »çÀÌ¿¡ ÀÖ´Â Äõ¸®¿¡ ´ëÇÏ¿©, ºÎºÐÀûÀ¸·Î Á¤»óÀûÀΠ󸮰¡ ÀÌ·ç¾îÁöÁö ¾Ê¾ÒÀ»°æ¿ì, ÇØ´ç »ó´Ü¿¡ ´ëÇÑ Äõ¸®¸¦ ¸ðµÎ ¹«È¿Ã³¸®(Rollback) ÇÒ ¼ö ÀÖ´Ù.



innoDB¿¡ ´ëÇÑ °£´ÜÇÑ ¼³¸íº¸±â : http://blog.naver.com/seracom2?Redirect=Log&logNo=60009146610

innoDB ¼³Á¤ Çϱâ : http://tunelinux.pe.kr/bbs/read.php?table=study&no=47

Transaction¿¡ ´ëÇÑ Àû¿ë¹ý : http://blog.naver.com/j100071?Redirect=Log&logNo=120034961116




ÀÌÀü: marked as crashed and should be repaired ¿¡·¯ ³¯¶§
´ÙÀ½: mysql °ú mysql_innodb ÀÇ Â÷ÀÌ?
2012/11/22(07:07) from 59.30.129.153
CrazyWWWBoard 2000

Vote Reply Modify Delete Forward Prev Next List
(c) Nobreak Technologies, Inc.