I have a problem regarding to the Mongo client connections. I want to understand why is mongo opening new connections for the same client, the same query. I’m currently using PHP 5.6 with Mongo 3.6.17 and the mongo php driver is GitHub - mongodb/mongo-php-driver-legacy: Legacy MongoDB PHP driver.

This is the Connect function:

function Connect ($dbName, $dbURI){
       if (!empty($this->connection)) {
          return; 
        } else {
         $options = [
            'connect' => true,
            'connectTimeoutMS' => 10000,
        ];

        $mongo = new MongoClient(
            $dbURI,
            $options
        );
        
        $this -> connection = $mongo -> $dbName;

Note: Every time reloads the page that uses the MongoClient is opening a new connection, which is not what I want. I’d like to keep the same connection or when the user leaves the page Mongo can close that. Otherwise, I’ll end up with twice the number of connections from a single client. The following image demonstrates that 3161 connections opened, but having around 1000 users in the application doesn’t make sense for me.

Screenshot 2021-04-27 at 12.26.231181×301 95.5 KB

@Andreas_Braun there’s nothing to upgrade because we already are in the latest version for PHP (5.6) driver which is (ext 1.7 + lib 1.6) as per: https://docs.mongodb.com/drivers/php. Unfortunately I still have the same issue

current-plat3578×1319 403 KB

As you can see in that image that every time I do a find with the exact same params in the constructor, meaning the query is the same but mongo allow a new connection instead of reusing. (Doesn’t persist in my case) and for that I still see a lot of connections.

I’m using this (new MongoDB\Client)->test->zips; instead of MongoClient.

Thanks @Andreas_Braun

I’m using apache 2 and the code above is running every time the user hits a page that requires a Mongo connection. i.e. GET https://app.xyz/customers.php. Then that page is using (new MongoDB\Client)->customers; and if I refresh the page Mongo will open another connection without closing the previous one.