php大数据量查询时内存持续增长问题

最新推荐文章于 2022-11-17 14:40:53 发布

njubluebird2

最新推荐文章于 2022-11-17 14:40:53 发布

阅读量613

点赞数

分类专栏：服务端开发文章标签： p php 内存 buffer

本文链接：https://blog.csdn.net/njubluebird2/article/details/51509854

版权

服务端开发专栏收录该内容

4 篇文章 0 订阅

订阅专栏

php进行数据库查询时会默认使用Buffer。当查询数据量较大时,需要使用Unbuffered Queries。具体见加粗参数。

/Create the connection  
$con = mysqli_connect("127.0.01","root","123456",'test', 3306) or die("Some error occurred during connection " . mysqli_error($con));  
 
// Write query
$strSQL = "SELECT id,report_id FROM pressure_test limit 100000";
 
// Execute the query.
//$query = mysqli_query($con, $strSQL);
$query = mysqli_query($con, $strSQL, MYSQLI_USE_RESULT); //需要添加MYSQLI_USE_RESULT

echo (floor( memory_get_usage() / 1024) ).' kb'. "\n";

// loop over the rows, outputting them
/* while ($row = $query->fetch_assoc()) 
{
echo (floor( memory_get_usage() / 1024) ).' kb'. "\n";
//fputcsv($output, $row);
} */

$row ='';
$i= 10000;
while($row = mysqli_fetch_assoc($query))
{
    if($i == 0){
echo (floor( memory_get_usage() / 1024) ).' kb  in while'. "\n";
$i = 10000; 
}
unset($row);
$i--;
}
echo (floor( memory_get_usage() / 1024) ).' kb  after while'. "\n"; 
// Close the connection
mysqli_close($con);