Details

    • # Replies:
      12
    • Last comment by Customer:
      true

      Description

      The PHP driver appears to send all commands to the master server, regardless of whether the command could be run on a slave. Here is a summary of slow queries on a slave vs. the master:

      Slow Queries by Incidence Count (slave)

      401 query master.stream ntoreturn:n nscanned:n scanAndOrder:n reslen:n reslen:n
      282 query master.users ntoreturn:n nscanned:n nreturned:n reslen:n reslen:n
      119 query master.keeks ntoreturn:n nscanned:n nreturned:n reslen:n reslen:n
      56 query master.users ntoreturn:n nscanned:n reslen:n reslen:n
      44 query master.stream ntoreturn:n nscanned:n scanAndOrder:n nreturned:n reslen:n reslen:n

      Slow Queries by Incidence Count (master)

      4582 command master.$cmd command:n { count:n "x", query:n

      { active:n 1, $or:n [ "q","q" ] }

      } ntoreturn:n reslen:n reslen:n
      937 remove master.auth_users query:n

      { u_id:n "x" }

      }
      31 command master.$cmd command:n { count:n "x", query:n

      { stat:n 1 }

      } ntoreturn:n reslen:n reslen:n

      As you can see, the commands are sent to the master exclusively. This was noted by Kyle Banker as a possible issue with the PHP driver itself in his report on our slow query issues:

      https://jira.mongodb.org/browse/CS-1741

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                2 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since reply:
                  4 years, 31 weeks, 4 days ago
                  Date of 1st Reply: