php-Sphinx即使没有更长时间的活动,我如何保持连接的有效性？

我在使用 PHP和禁用AUTOCOMIT在RealTime Index中进行批量插入,
例如

// sphinx connection
$sphinxql = MysqLi_connect($sphinxql_host.':'.$sphinxql_port,'',''); 

//do some other time consuming work

//sphinx start transaction
MysqLi_begin_transaction($sphinxql);

//do 50k updates or inserts

// Commit transaction
MysqLi_commit($sphinxql);

并保持脚本运行一夜之间,我早上看到

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate
212334 bytes) in

所以当我仔细检查nohup.out文件的时候,我注意到这些行,

PHP Warning: MysqLi_query(): MysqL server has gone away in /home/script.PHP on line 502
Warning: MysqLi_query(): MysqL server has gone away in /home/script.PHP on line 502

这些行之前的内存使用情况是正常的,但这些行开始增加后的内存使用量,并且它触发了PHP mem_limit并给出了PHP致命错误并且死了.

in script.PHP,line 502 is

MysqLi_query($sphinxql,$update_query_sphinx);

所以我的猜测是,狮身人面像服务器关闭/死亡几个小时/分钟后不活动.

我已经尝试在sphinx.conf中设置

client_timeout = 3600

重新启动searchd

systemctl restart searchd

我仍然面临同样的问题.

那么如果没有长时间的活动存在,我怎么不能让狮身人面像服务器死在我身上呢？

更多信息添加 –

我一次从50k块的MysqL中获取数据,并在while循环中获取每行并在sphinx RT索引中进行更新.喜欢这个

//6mil rows update in MysqL,so it takes around 18-20 minutes to complete this then comes this following part.

$subset_count = 50000 ;

$total_count_query = "SELECT COUNT(*) as total_count FROM content WHERE enabled = '1'" ;
$total_count = MysqLi_query ($conn,$total_count_query);
$total_count = MysqLi_fetch_assoc($total_count);
$total_count = $total_count['total_count'];

$current_count = 0;

while ($current_count <= $total_count){

$get_MysqL_data_query = "SELECT record_num,views,comments,Votes FROM content WHERE enabled = 1  ORDER BY record_num ASC LIMIT $current_count,$subset_count ";

//sphinx start transaction
MysqLi_begin_transaction($sphinxql);

if ($result = MysqLi_query($conn,$get_MysqL_data_query)) {

    /* fetch associative array */
    while ($row = MysqLi_fetch_assoc($result)) {

    //sphinx escape whole array
    $escaped_sphinx = MysqLi_real_escape_array($sphinxql,$row);

    //update data in sphinx index
    $update_query_sphinx = "UPDATE $sphinx_index  
    SET 
        views       = ".$escaped_sphinx['views'].",comments    = ".$escaped_sphinx['comments'].",Votes   = ".$escaped_sphinx['Votes']." 
    WHERE 
        id          = ".$escaped_sphinx['record_num']." ";  

    MysqLi_query ($sphinxql,$update_query_sphinx);

    }

    /* free result set */
    MysqLi_free_result($result);
}
// Commit transaction
MysqLi_commit($sphinxql);

$current_count = $current_count + $subset_count ;
}