dqd54099
2018-09-15 20:14 阅读 110
已采纳

多个SELECT查询中的PDO / mysqli内存泄漏

I have a memory leak when executing many (20,000) simple SELECT operations using PDO or mysqli.

// test2.php
$i = 0;
while (true) {

    $pdo->query("SELECT 1 as m");
    file_put_contents(__FILE__ . '.log', 'Memory: ' . memory_get_usage_in_mb() . PHP_EOL, FILE_APPEND);
    // In test2.php.log
    // ([line]: [message]):
    // 1:     Memory: 0.39
    // 5000:  Memory: 0.44
    // 10000: Memory: 0.51
    // 20000: Memory: 0.63

    if ($i === 20000) {
        break;
    }
    $i++;
}

Plese see full test code at https://gist.github.com/NewEXE/ca4f5ddbeb7ff863b8c775c238698c57

I also tried PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => false with $pdo::closeCursor call after each query and this code on mysqli case:

$result = $mysqli->query("SELECT 1 as m", MYSQLI_USE_RESULT); // and MYSQLI_STORE_RESULT too...

// with and without this lines:
$result->free_result();
$result = null;
unset($result);
  • Server: nginx/1.13.6
  • PHP: 7.2.7-1+ubuntu16.04.1+deb.sury.org+1
  • MySQL: 5.7.21-0ubuntu0.16.04.1
  • pdo_mysql: Client API version - mysqlnd 5.0.12-dev - 20150407
  • mysqli: Client API library version - mysqlnd 5.0.12-dev - 20150407

Sorry for my english and thank you in advance!

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

2条回答 默认 最新

  • 已采纳
    douhuan9289 douhuan9289 2018-09-18 19:27

    I disabled xDebug and the problem is solved!

    Tnanks to this answer: https://stackoverflow.com/a/43359644/8927920

    点赞 评论 复制链接分享
  • dongzu0742 dongzu0742 2018-09-15 21:03

    immediately After

    $pdo = new \PDO($dsn, $dbParams['username'], $dbParams['password']);
    

    add this

    $pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
    

    test on both files

    点赞 评论 复制链接分享

相关推荐