IP Search freezes server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dennis Olson
    Senior Member
    • Oct 2002
    • 2789

    #16
    How long is "a little longer"? If a few ms, that's okay. But for a million+ posts in the table, will the new-record insert-time be excessive?

    Comment

    • Dennis Olson
      Senior Member
      • Oct 2002
      • 2789

      #17
      Final result - 6 minutes via the SSH terminal at the command line. (Dual 866 MHz cpu's, 2 GB RAM)

      FYI

      Thanks for the assistance everyone!

      Comment

      • Lee A Burnett
        Member
        • Apr 2002
        • 63

        #18
        In a master/slave mySQL set-up, does the IP search go to the master or the slave?

        If it goes to the master, where can I change the code to redirect those searches to the slave server?

        Comment

        • blue_asterisk
          Member
          • Mar 2007
          • 43
          • 3.6.x

          #19
          30 minutes, dual 2.8 Ghz xeons, 4GB Ram - 2.5+ million posts

          Originally posted by Dennis Olson
          Final result - 6 minutes via the SSH terminal at the command line. (Dual 866 MHz cpu's, 2 GB RAM)

          FYI

          Thanks for the assistance everyone!

          Comment

          • boggseric
            Member
            • Sep 2009
            • 46
            • 3.8.x

            #20
            How much did it help your IP search times? We have 12 million posts and running an IP search kills the forum.

            Comment

            • rady
              Member
              • Apr 2006
              • 98
              • 3.6.x

              #21
              I have the same problem, but my forum is much smaller (almost 200.000 posts)
              Still, when i run an ip check the forum dies. Any updates on this?

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...