哪位熟悉mysql的长连接?设置了CLIENT_MULTI_STATEMENTS参数后这个长连接经常断

[天降大任于斯]

设置了CLIENT_MULTI_STATEMENTS是为了调存储过程取出多行结果
可是我们发现用了这个CLIENT_MULTI_STATEMENTS后长连接会经常断,有人能解释下么?

[shineyear]

我也遇到了同样的问题！！！大家帮忙啊～～

[feasfeasf]

我也遇到相同的問題
原因是當你執行 multi-statments後
必須使用 mysql_next_result() 將所有的 result set 取完
否則直接執行下一個sql, server 會傳回 lost connection 錯誤訊息。

以下是mysql doc裡的範例：
/* connect to server with the CLIENT_MULTI_STATEMENTS option */
if (mysql_real_connect (mysql, host_name, user_name, password,
db_name, port_num, socket_name, CLIENT_MULTI_STATEMENTS) == NULL)
{
printf("mysql_real_connect() failed\n");
mysql_close(mysql);
exit(1);
}

/* execute multiple statements */
status = mysql_query(mysql,
"DROP TABLE IF EXISTS test_table;\
CREATE TABLE test_table(id INT);\
INSERT INTO test_table VALUES(10);\
UPDATE test_table SET id=20 WHERE id=10;\
SELECT * FROM test_table;\
DROP TABLE test_table");
if (status)
{
printf("Could not execute statement(s)");
mysql_close(mysql);
exit(0);
}

/* process each statement result */
do {
/* did current statement return data? */
result = mysql_store_result(mysql);
if (result)
{
/* yes; process rows and free the result set */
process_result_set(mysql, result);
mysql_free_result(result);
}
else /* no result set or error */
{
if (mysql_field_count(mysql) == 0)
{
printf("%lld rows affected\n",
mysql_affected_rows(mysql));
}
else /* some error occurred */
{
printf("Could not retrieve result set\n");
break;
}
}
/* more results? -1 = no, >0 = error, 0 = yes (keep looping) */
if ((status = mysql_next_result(mysql)) > 0)
printf("Could not execute statement\n");
} while (status == 0);

mysql_close(mysql);