锟斤拷锟斤拷锟斤拷锟� PHP MySQL 锟斤拷锟接ｏ拷锟斤拷锟酵拷锟斤拷透锟斤拷鼐锟斤拷猓拷锟斤拷锟斤拷锟斤拷锟侥憋拷锟斤拷锟叫碉拷 PHP MySQL 锟斤拷展锟侥凤拷锟斤拷使锟斤拷 (mysqli, mysql, 锟斤拷 PDO_MYSQL) 锟斤拷锟叫碉拷应锟矫诧拷锟斤拷锟斤拷要 锟斤拷锟斤拷锟斤拷锟角达拷锟诫，锟斤拷锟斤拷使锟斤拷锟铰碉拷 API锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟侥变，锟斤拷锟斤拷锟斤拷要一些锟睫改的★拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷些锟斤拷展锟斤拷锟斤拷 MySQL 锟斤拷锟接的匡拷锟狡ｏ拷 mysqli, mysql, 锟斤拷 PDO_MYSQL锟斤拷 锟斤拷锟斤拷为 mysqli, mysql, 锟斤拷 PDO_MYSQL 锟结供一锟斤拷锟斤拷锟截碉拷锟斤拷锟接筹拷 锟斤拷锟� MySQL 锟斤拷锟斤拷同锟斤拷锟斤拷 master 锟斤拷 slave 通讯锟斤拷锟狡★拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫碉拷 锟斤拷锟斤拷 master 锟斤拷 slave 锟侥诧拷询锟斤拷锟斤拷 锟斤拷某一时锟斤拷一锟斤拷锟斤拷锟接碉拷 master 锟斤拷锟斤拷锟接ｏ拷锟斤拷锟斤拷锟皆猴拷锟斤拷为 slave 锟斤拷锟接ｏ拷锟斤拷锟斤拷 锟斤拷然锟斤拷锟斤拷 master 锟斤拷锟接★拷锟斤拷执锟叫凤拷锟斤拷锟斤拷锟斤拷锟叫ｏ拷锟斤拷锟狡猴拷锟芥换 PHP MySQL 锟斤拷锟斤拷锟斤拷锟斤拷锟接★拷
每锟斤拷 MySQL 锟斤拷锟接讹拷锟斤拷锟斤拷锟斤拷状态锟斤拷锟斤拷锟斤拷锟接筹拷锟叫碉拷每锟斤拷锟斤拷锟接匡拷锟斤拷锟叫诧拷同锟斤拷状态锟斤拷 锟斤拷锟斤拷锟斤拷锟揭伙拷锟叫达拷锟斤拷锟斤拷颖锟斤拷为锟斤拷锟斤拷一锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷状态锟斤拷锟杰憋拷锟侥变。应锟斤拷 锟斤拷要锟斤拷注锟斤拷锟斤拷锟斤拷狻�
锟斤拷锟斤拷锟叫筹拷锟斤拷锟斤拷状态锟斤拷锟斤拷锟捷ｏ拷锟斤拷锟斤拷锟杰诧拷锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟斤拷锟芥换锟斤拷锟斤拷锟斤拷锟街达拷锟角帮拷锟斤拷校锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷执锟斤拷锟斤拷前锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷印锟�
Note: 同锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷慰锟� MySQL 锟轿匡拷锟街诧拷锟叫癸拷锟斤拷 » replication features 锟斤拷锟斤拷锟斤拷锟斤拷荨锟揭恍╋拷锟斤拷聘锟斤拷锟斤拷 PHP 锟斤拷锟斤拷薷校锟斤拷锟斤拷锟斤拷锟� MySQL 锟斤拷锟斤拷锟斤拷同锟斤拷锟斤拷亍锟�
锟姐播锟斤拷息
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷学锟斤拷只锟斤拷锟斤拷全锟斤拷锟狡碉拷锟斤拷锟接ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷映锟斤拷锟斤拷锟斤拷锟斤拷拥锟阶刺拷锟斤拷锟斤拷锟斤拷锟斤拷锟� 一些锟斤拷全锟斤拷锟斤拷也锟斤拷锟斤拷么锟斤拷锟斤拷只锟叫猴拷锟劫的诧拷锟斤拷锟侥憋拷锟斤拷锟斤拷状态锟斤拷失锟杰ｏ拷锟斤拷锟斤拷锟斤拷锟侥凤拷锟洁当锟叫★拷
锟斤拷锟斤拷锟叫筹拷锟斤拷锟斤拷些锟酵伙拷锟剿的库，锟斤拷谋锟斤拷锟斤拷锟阶刺拷锟斤拷锟斤拷一峤拷锟斤拷悴ワ拷锟斤拷锟斤拷映锟斤拷锟斤拷锟斤拷锟� 锟津开碉拷锟斤拷锟接碉拷锟叫★拷
锟轿猴拷锟斤拷锟斤拷锟叫筹拷锟斤拷锟斤拷锟捷憋拷执锟叫ｏ拷锟斤拷锟斤拷锟斤拷锟窖拷锟斤拷写蚩锟� master 锟斤拷 slave 锟斤拷锟接ｏ拷 锟斤拷循锟斤拷锟节诧拷锟斤拷锟斤拷锟斤拷锟叫的凤拷锟斤拷锟斤拷锟斤拷停止锟斤拷锟斤拷锟斤拷锟窖拷锟斤拷锟接帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷失锟杰碉拷状态锟斤拷 锟解函锟斤拷锟侥达拷锟斤拷锟斤拷锟斤拷锟斤拷锟皆憋拷锟斤拷獾绞э拷埽锟斤拷锟斤拷锟酵拷锟斤拷没锟� API 锟斤拷锟斤拷锟姐播锟斤拷
| Library call | Notes | Version |
|---|---|---|
| change_user() | Called by the mysqli_change_user() user API call. Also triggered upon reuse of a persistent mysqli connection. | Since 1.0.0. |
| select_db | Called by the following user API calls: mysql_select_db(), mysql_list_tables(), mysql_db_query(), mysql_list_fields(), mysqli_select_db(). Note, that SQL USE is not monitored. | Since 1.0.0. |
| set_charset() | Called by the following user API calls: mysql_set_charset(). mysqli_set_charset(). Note, that SQL SET NAMES is not monitored. | Since 1.0.0. |
| set_server_option() | Called by the following user API calls: mysqli_multi_query(), mysqli_real_query(), mysqli_query(), mysql_query(). | Since 1.0.0. |
| set_client_option() | Called by the following user API calls: mysqli_options(), mysqli_ssl_set(), mysqli_connect(), mysql_connect(), mysql_pconnect(). | Since 1.0.0. |
| set_autocommit() | Called by the following user API calls: mysqli_autocommit(), PDO::setAttribute(PDO::ATTR_AUTOCOMMIT). | Since 1.0.0. PHP >= 5.4.0. |
| ssl_set() | Called by the following user API calls: mysqli_ssl_set(). | Since 1.1.0. |
锟姐播锟酵憋拷锟斤拷锟斤拷锟斤拷
锟斤拷锟接达拷锟皆后，诧拷锟斤拷薹锟斤拷锟斤拷锟斤拷锟竭硷拷录锟斤拷锟斤拷锟斤拷锟叫碉拷锟借定锟斤拷锟斤拷锟斤拷锟斤拷锟� lazy connections. 锟斤拷浅锟斤拷锟揭拷锟斤拷锟斤拷锟斤拷锟斤拷臃锟绞斤拷锟斤拷突锟斤拷锟斤拷诜锟斤拷锟斤拷一锟斤拷指锟斤拷锟绞憋拷锟斤拷锟斤拷硬疟锟斤拷锟斤拷锟斤拷锟� 锟斤拷锟侥拷系牟锟斤拷锟斤拷锟斤拷直锟斤拷锟斤拷锟斤拷臃锟绞斤拷锟�
锟斤拷锟斤拷锟斤拷锟叫╋拷锟斤拷锟矫ｏ拷锟斤拷锟节憋拷锟斤拷锟斤拷锟接斤拷锟斤拷锟皆猴拷执锟叫★拷锟斤拷锟斤拷锟斤拷锟斤拷确锟斤拷锟斤拷锟斤拷锟斤拷锟接筹拷锟斤拷 锟斤拷锟接碉拷状态锟斤拷锟节可憋拷锟皆★拷
| Library call | Notes | Version |
|---|---|---|
| change_user() | User, password and database recorded for future use. | Since 1.1.0. |
| select_db | Database recorded for future use. | Since 1.1.0. |
| set_charset() | Calls set_client_option(MYSQL_SET_CHARSET_NAME, charset) on lazy connection to ensure charset will be used upon opening the lazy connection. | Since 1.1.0. |
| set_autocommit() | Adds SET AUTOCOMMIT=0|1 to the list of init commands of a lazy connection using set_client_option(MYSQL_INIT_COMMAND, "SET AUTOCOMMIT=...%quot;). | Since 1.1.0. PHP >= 5.4.0. |
锟斤拷锟斤拷状态锟斤拷锟斤拷锟斤拷锟结被 API 锟斤拷锟矫改变。锟斤拷锟皆ｏ拷锟斤拷使锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫碉拷 API 锟斤拷锟矫ｏ拷 应锟斤拷也要锟斤拷锟解方锟斤拷锟阶拷浠拷锟斤拷锟襟，讹拷锟斤拷锟斤拷锟斤拷状态锟斤拷维锟斤拷锟斤拷锟斤拷应锟斤拷应锟斤拷锟斤拷傻锟斤拷锟斤拷椤�
锟街凤拷锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷
锟斤拷使锟斤拷默锟较的憋拷锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷应锟矫筹拷锟斤拷锟斤拷锟斤拷锟接斤拷锟斤拷锟斤拷前锟斤拷 SQL 锟斤拷锟斤拷械锟斤拷址锟斤拷锟斤拷锟阶拷耄� 锟角诧拷锟斤拷锟斤拷锟斤拷傻摹锟斤拷锟轿拷锟斤拷咏锟斤拷锟斤拷锟角帮拷锟斤拷锟斤拷锟街拷锟斤拷锟斤拷锟斤拷锟揭拷锟斤拷址锟斤拷锟斤拷锟斤拷锟矫达拷锟�
锟斤拷 1.4.0 锟皆猴拷姹撅拷校锟酵拷锟斤拷锟斤拷锟斤拷械锟� server_charset 锟斤拷锟矫匡拷锟皆斤拷锟斤拷锟斤拷锟斤拷锟解。
锟斤拷要注锟斤拷锟窖撅拷转锟斤拷为某锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟接的斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷植锟酵拷锟斤拷址锟斤拷锟斤拷锟� 锟斤拷锟斤拷锟斤拷频锟斤拷锟斤拷雍锟斤拷锟斤拷映锟斤拷械锟矫匡拷锟斤拷锟斤拷涌锟斤拷懿锟斤拷锟斤拷瞬锟酵拷锟侥拷锟斤拷址锟斤拷锟斤拷锟斤拷锟斤拷越锟斤拷锟斤拷锟斤拷锟� 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷统一锟斤拷默锟斤拷锟街凤拷锟斤拷锟借定锟斤拷锟斤拷锟斤拷锟侥硷拷锟叫碉拷 server_charset 锟斤拷锟皆很好的达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷使锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫恳伙拷锟斤拷麓蚩锟斤拷锟斤拷锟斤拷瓒拷系锟斤拷址锟斤拷锟斤拷锟�