鍦ㄤ娇鐢ㄧ櫨搴︿簯鏁版嵁搴擄紙濡?MySQL 鎴栧叾浠栧叧绯诲瀷鏁版嵁搴擄級涓?PHP 杩涜杩炴帴鏃讹紝璁剧疆瓒呮椂鏃堕棿鏄竴涓噸瑕佺殑閰嶇疆姝ラ銆傚悎鐞嗙殑瓒呮椂璁剧疆鍙互纭繚搴旂敤绋嬪簭鍦ㄩ亣鍒扮綉缁滈棶棰樻垨鏁版嵁搴撳搷搴旂紦鎱㈡椂涓嶄細鏃犻檺鏈熷湴绛夊緟锛屼粠鑰屾彁楂樼郴缁熺殑绋冲畾鎬у拰鐢ㄦ埛浣撻獙銆傛湰鏂囧皢璇︾粏浠嬬粛濡備綍鍦?PHP 涓缃笌鐧惧害浜戞暟鎹簱杩炴帴鐨勮秴鏃舵椂闂淬€?/p>
1. 浣跨敤 mysqli 鎵╁睍璁剧疆瓒呮椂
濡傛灉浣犱娇鐢ㄧ殑鏄?mysqli 鎵╁睍鏉ヨ繛鎺ョ櫨搴︿簯鏁版嵁搴擄紝鍙互閫氳繃浠ヤ笅鍑犵鏂瑰紡璁剧疆瓒呮椂锛?/p>
1.1 璁剧疆杩炴帴瓒呮椂
杩炴帴瓒呮椂鏄寚 PHP 鍦ㄥ皾璇曞缓绔嬩笌鏁版嵁搴撶殑杩炴帴鏃剁瓑寰呯殑鏃堕棿銆傚彲浠ュ湪杩炴帴鏃堕€氳繃 mysqli::options() 鏂规硶璁剧疆杩炴帴瓒呮椂锛?/p>
$mysqli = new mysqli();
$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5); // 璁剧疆杩炴帴瓒呮椂涓?5 绉?
$mysqli->real_connect(\'host\', \'username\', \'password\', \'database\');
杩欓噷鐨?MYSQLI_OPT_CONNECT_TIMEOUT 閫夐」鐢ㄤ簬璁剧疆杩炴帴瓒呮椂鏃堕棿锛岄粯璁ゅ崟浣嶆槸绉掋€?/p>
1.2 璁剧疆鏌ヨ瓒呮椂
鏌ヨ瓒呮椂鏄寚 PHP 鍦ㄦ墽琛屾煡璇㈡椂绛夊緟鏁版嵁搴撹繑鍥炵粨鏋滅殑鏃堕棿銆傝櫧鐒?mysqli 鏈韩娌℃湁鐩存帴鎻愪緵璁剧疆鏌ヨ瓒呮椂鐨勯€夐」锛屼絾鍙互閫氳繃 SQL 鏌ヨ涓殑 SET SESSION MAX_EXECUTION_TIME 鏉ラ檺鍒舵煡璇㈢殑鏈€澶ф墽琛屾椂闂达細
$mysqli->query(\"SET SESSION MAX_EXECUTION_TIME=5000\"); // 璁剧疆鏌ヨ鏈€澶ф墽琛屾椂闂翠负 5000 姣
杩欏皢鍦ㄥ綋鍓嶄細璇濅腑闄愬埗鎵€鏈夋煡璇㈢殑鎵ц鏃堕棿锛岃秴杩囨寚瀹氭椂闂村悗鏌ヨ浼氳鑷姩缁堟銆?/p>
2. 浣跨敤 PDO 璁剧疆瓒呮椂
濡傛灉浣犱娇鐢ㄧ殑鏄?PDO锛圥HP Data Objects锛夋墿灞曟潵杩炴帴鐧惧害浜戞暟鎹簱锛屽彲浠ラ€氳繃涓嶅悓鐨勬柟寮忚缃秴鏃讹細
2.1 璁剧疆杩炴帴瓒呮椂
鍦ㄤ娇鐢?PDO 杩炴帴鏁版嵁搴撴椂锛屽彲浠ラ€氳繃鍦?DSN锛堟暟鎹簮鍚嶇О锛変腑娣诲姞 connect_timeout 鍙傛暟鏉ヨ缃繛鎺ヨ秴鏃讹細
$dsn = \"mysql:host=your_host;dbname=your_db;charset=utf8mb4\";
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
// 璁剧疆杩炴帴瓒呮椂涓?5 绉?
$dsn .= \";connect_timeout=5\";
try {
$pdo = new PDO($dsn, \'username\', \'password\', $options);
} catch (PDOException $e) {
echo \"Connection failed: \" . $e->getMessage();
}
杩欐牱鍙互纭繚鍦ㄨ繛鎺ユ暟鎹簱鏃讹紝PHP 涓嶄細鏃犻檺鏈熷湴绛夊緟锛岃€屾槸鏍规嵁璁剧疆鐨勮秴鏃舵椂闂磋繘琛屽鐞嗐€?/p>
2.2 璁剧疆鏌ヨ瓒呮椂
PDO 鏈韩骞朵笉鎻愪緵鐩存帴璁剧疆鏌ヨ瓒呮椂鐨勫姛鑳斤紝浣嗕綘鍙互閫氳繃鎵ц SQL 璇彞鏉ュ疄鐜扮被浼肩殑鏁堟灉锛?/p>
$pdo->exec(\"SET SESSION MAX_EXECUTION_TIME=5000\"); // 璁剧疆鏌ヨ鏈€澶ф墽琛屾椂闂翠负 5000 姣
杩欏皢纭繚鏌ヨ鍦ㄨ秴杩囨寚瀹氭椂闂村悗琚嚜鍔ㄧ粓姝€?/p>
3. 鍏朵粬娉ㄦ剰浜嬮」
3.1 缃戠粶寤惰繜鍜屾湇鍔″櫒璐熻浇
鍦ㄨ缃秴鏃舵椂闂存椂锛岃繕闇€瑕佽€冭檻缃戠粶寤惰繜鍜屾湇鍔″櫒璐熻浇銆傝繃鐭殑瓒呮椂鏃堕棿鍙兘瀵艰嚧姝ｅ父鎯呭喌涓嬩篃浼氬嚭鐜拌繛鎺ュけ璐ユ垨鏌ヨ涓柇鐨勬儏鍐碉紝鑰岃繃闀跨殑瓒呮椂鏃堕棿鍒欏彲鑳藉奖鍝嶇郴缁熺殑鍝嶅簲閫熷害銆傚缓璁牴鎹疄闄呮儏鍐佃繘琛岃皟鏁达紝閫氬父杩炴帴瓒呮椂鍙互璁剧疆涓?5 鍒?10 绉掞紝鏌ヨ瓒呮椂鍙互鏍规嵁鍏蜂綋涓氬姟闇€姹傝缃负鍑犵鍒板嚑鍗佺涓嶇瓑銆?/p>
3.2 閿欒澶勭悊
鏃犺浣跨敤鍝鏂规硶璁剧疆瓒呮椂锛岄兘闇€瑕佸悎鐞嗗鐞嗚秴鏃堕敊璇€傚彲浠ュ湪浠ｇ爜涓崟鑾峰紓甯告垨妫€鏌ヨ繑鍥炲€硷紝骞舵牴鎹叿浣撴儏鍐电粰鍑洪€傚綋鐨勬彁绀烘垨閲囧彇鐩稿簲鐨勬帾鏂斤紝渚嬪閲嶈瘯杩炴帴鎴栬褰曟棩蹇椼€?/p>
鍦?PHP 涓繛鎺ョ櫨搴︿簯鏁版嵁搴撴椂锛屽悎鐞嗚缃秴鏃舵椂闂存槸闈炲父閲嶈鐨勩€傞€氳繃浣跨敤 mysqli 鎴?PDO 鎵╁睍鎻愪緵鐨勭浉鍏抽€夐」锛屽彲浠ユ湁鏁堝湴鎺у埗杩炴帴鍜屾煡璇㈢殑瓒呮椂琛屼负锛屼粠鑰屾彁楂樺簲鐢ㄧ▼搴忕殑绋冲畾鎬у拰鎬ц兘銆傚紑鍙戣€呰繕搴旀牴鎹疄闄呯幆澧冨拰涓氬姟闇€姹傦紝鐏垫椿璋冩暣瓒呮椂鏃堕棿骞跺Ε鍠勫鐞嗚秴鏃堕敊璇€?/p>
