http://www.mysqlkorea.co.kr
Çѱ۸Ŵº¾ó 5.0 , Çѱ۸Ŵº¾ó 5.1 , MySQL 5.1 HA , »ç¿ëÀڸŴº¾ó
°øÁö»çÇ×  
´º½º  
Áú¹®°ú ´äº¯
DBA
Developer
Cluster
ÅäÅ©¹Ú½º  
À̺¥Æ®  
¼­Æ÷Æ® ƼÄÏ  
ÃֽűÛ
foreign key ¼³Á¤¡¦
ÀÎÅØ½º Ãß°¡ µî¿¡¡¦
mysql master - s¡¦
´Ù´ë´Ù °ü°è¿¡¼­ ¡¦
mysql myÆÄÀϰú ¡¦
 
Áú¹®°ú ´äº¯ (Developer) > Ä¿¹Â´ÏƼ Á¸ > Áú¹®°ú ´äº¯ (Developer)
mysql Á¢¼Ó ¹®ÀÇ(connection handle °¡Á®¿À±â µîµî)
±Û¾´ÀÌ : »õÈû   ³¯Â¥ : 14-10-06 22:44   Á¶È¸¼ö : 5110
¾È³çÇϼ¼¿ä~~~
¹®ÀÇ Á» µå¸³´Ï´Ù.
Á¦°¡ C·Î PHP EXTENSIONÀ» °³¹ßÇÏ¿© PHPÀÇ ³»ºÎ ÇÔ¼ö¸¦ ¸¸µé¾ú½À´Ï´Ù.
±× PHPÇÁ·Î±×·¥Àº ÆíÀÇ»ó À̸§À» ext.php¶ó°í ÇϰڽÀ´Ï´Ù.
±×¸®°í ext.php¿¡¼­´Â Á¦°¡ EXTENSIONÀ¸·Î °³¹ßÇÑ ext_mysql(); ÇÔ¼ö¸¦ »ç¿ëÇÕ´Ï´Ù.
À̶§ ext.php¿¡¼­ mysql_connect(¼­¹öIP, À¯Àú, ÆÐ½º¿öµå);·Î ¸ÕÀú Á¢¼ÓÀ» ÇÕ´Ï´Ù.
±×¸®°í ³ª¼­ ext_mysql();ÇÔ¼ö¸¦ È£ÃâÇÕ´Ï´Ù.
----------------------------------------
<?
//program name : ext.php

$link = mysql_connect(¼­¹öip, À¯Àú, ºñ¹ø);
~~
~~
ext_mysql();  // c·Î ±¸ÇöÇÑ php extension ÇÔ¼ö

?>
-------------------------------------------
ext_mysql()ÇÔ¼ö´Â C·Î ±¸Çö Çߴµ¥, ±× ÇÔ¼ö¾È¿¡¼­ mysql Á¢¼ÓÁ¤º¸ È®ÀÎÀÌ ÇÊ¿äÇÏ¿©
select user();¸¦ query¸¦ Çϰųª mysql_list_processes(link);¸¦ ÇÕ´Ï´Ù.
±×·±µ¥ ÀÌ°É ÇÏ·Á¸é MYSQL C API´Â mysql_real_connect(link, ...);·Î ÀçÁ¢¼ÓÀ» ÇØ¾ßÇÕ´Ï´Ù.
±×¸®´Ï±î ext.php¿¡¼­ mysql_thread_id()·Î ¾òÀº thread id¿Í
ext_mysql()¿¡¼­ thread id°¡ ´Þ¶óÁý´Ï´Ù. ÀçÁ¢¼ÓÀ» ÇßÀ¸´Ï ¾î¼¸é ´ç¿¬ÇϰÚÁö¿ä...
ÇÏÁö¸¸ PHP¿¡¼­ $link=mysql_connect(arg..)´Â Çѹø Á¢¼ÓÇÏ¸é ¹Ø¿¡¼­
¶Ç $link= mysql_connect(arg..)ÇØµµ
µ¿ÀÏ arg¸é Á¢¼ÓÀ» »õ·Î ÇÏÁö ¾Ê°í $link(MYSQL connect handle)¸¸ Àç¹Ý³³ÇÕ´Ï´Ù.
thread idµµ ´ç¿¬ °°°ÚÁÒ...
Á¦°¡ ¾Ë°í ½ÍÀº °ÍÀº ù°, ext_mysql()¿¡¼­ MYSQL C API¸¦ »ç¿ëÇÒ ¶§µµ PHPÀÇ $link=mysql_connect(arg ..);ó·³ »õ·Î ÀçÁ¢¼Ó ÇÏÁö ¾Ê°íµµ query¸¦ ÇÒ ¼ö ÀÖ´Â ¹æ¹ýÀÌ ÀÖ´ÂÁö?
µÑ°, MYSQL C API(ext_mysql())»ç¿ë¿¡¼­ PHP(ext.php)¿¡¼­ connectÇÑ $link¸¦ °¡Á®¿À´Â ¹æ¹ýÀÌ
ÀÖ´ÂÁö?¸¦ ¾Ë°í ½Í½À´Ï´Ù. MYSQL C APIÇÔ¼ö´Â °ÅÀÇ ¸ðµç ÇÔ¼öµéÀÌ $link¸¦ ÇÔ¼ö ÀÎÀÚ·Î »ç¿ëÇϱâ
¶§¹®¿¡ »õ·Î ÀçÁ¢¼ÓÀ» ÇÏÁö ¾ÊÀ» ¼ö°¡ ¾ø³×¿ä¤Ð¤Ð.(¿¹: mysql_query($link,$qy))
°í¼ö´ÔµéÀÇ µµ¿òÀ» ¹Ù¶ø´Ï´Ù.
ÀÌÀü±Û ´Ù¸¥ DB ÀÇ °°Àº Å×ÀÌºí ºñ±³... 
´ÙÀ½±Û ½º·¹µå ³»¿¡¼­ LOAD DATA LOCAL INFILE »ç¿ë½Ã ¹®Á¦ 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.