GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Netstat -an output question

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Netstat -an output question

    Hello I was wondering if someone could please explain shed some light as to why I see the stuff below when starting mysql.

    netstat -an |grep :3306

    what does all that stuff mean and why some many connection between local system?

    thanks for the help!! )

    tcp 0 0 ::ffff:127.0.0.1:56556 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56557 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56635 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56634 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56639 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56638 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56637 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56636 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56626 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56631 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56619 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56618 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56617 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56616 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56622 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56611 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56610 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56609 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56608 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56615 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56614 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56613 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56612 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56603 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56602 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56601 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56600 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56607 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56606 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56605 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56604 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56599 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56598 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56597 ::ffff:127.0.0.1:3306 ESTABLISHED
    tcp 0 0 ::ffff:127.0.0.1:56587 ::ffff:127.0.0.1:3306 ESTABLISHED

  • #2
    It looks like you have local connections through tcp/ip to mysql. Can you use the socket file (unix/linux) or named pipes/shared memory (windows)?

    The mysql reference guide shows how to specify different connect strings to use different protocols on the machine running mysql server -- basically, if you reference the ip, it'll use tcp/ip.

    Comment

    Working...
    X