Results 1 to 12 of 12
  1. #1
    Join Date
    Feb 2005
    Location
    Montreal, PQ
    Posts
    355

    Question Weird MySQL traffic...

    Hi guys. I'm seeing weird traffic going on with MySQL...

    Take a look at this: http://img528.imageshack.us/img528/612/mysql0gg.gif


    There isin't many transactions, nor connections, but mysql network traffic is HUGE.

    Any ideas?

  2. #2
    Join Date
    Nov 2004
    Posts
    345
    Why don't you use "SHOW PROCESSLIST" to see if any queries are going on?

  3. #3
    Join Date
    Feb 2005
    Location
    Montreal, PQ
    Posts
    355
    Yeah, it shows the amount of connections listed, and they're all sleeping.

    My database isin't even that big. Only about 30mb.

    Any other ideas?

  4. #4
    Join Date
    Jan 2005
    Location
    Lincs, UK
    Posts
    152
    take a look at the output of tcpdump to see where the traffic is going/coming from.

    Alex
    Member, MySQL Guilds
    Author, "MySQL Clusterng" (Sams)

  5. #5
    Join Date
    Feb 2005
    Location
    Montreal, PQ
    Posts
    355
    This is a Windows box... Traffic is definately coming from MySQL. When I stop the service, traffic literally stops. As soon as I start it, traffic jumps up to 1 MB/s +...

  6. #6
    Join Date
    Aug 2003
    Location
    Montréal
    Posts
    953
    Is your mysql port accessible from outside of your server? Block the mysql port with iptables only to accept local connexions if possible and if you do not use if externaly.
    :: Martin Leclair
    :: Linkedin Profile

  7. #7
    Yes, it does look like someone is trying to connect to your mySQL server. We've had some attacks via mySQL as well, so it's very likely that's the case.
    YourCheapHost.com - Low cost multi domain hosting solutions. [Legal adult content friendly]
    Reliable web site hosting is our motto. We have Alertra stats to back that up.
    Proven provider of high quality shared and reseller accounts since 2002.

  8. #8
    Join Date
    Apr 2005
    Location
    Jacksonville, FL
    Posts
    977
    Quote Originally Posted by atchoooo
    Is your mysql port accessible from outside of your server? Block the mysql port with iptables only to accept local connexions if possible and if you do not use if externaly.
    He said Windows. Or did you mean to suggest that he should be running the port of iptables for win32 that can be found on sourceforge? If so, do you have any comments on it?

  9. #9
    Join Date
    Jan 2005
    Location
    Lincs, UK
    Posts
    152
    Try http://www.winpcap.org/windump/ to see where the traffic is coming from or going to. Alex
    Member, MySQL Guilds
    Author, "MySQL Clusterng" (Sams)

  10. #10
    Join Date
    Aug 2003
    Location
    Montréal
    Posts
    953
    Sorry I did not read windows .. then block it with a Windows Firewall like Black Ice Defender or something else similar.
    :: Martin Leclair
    :: Linkedin Profile

  11. #11
    Join Date
    Jan 2004
    Location
    York, UK
    Posts
    371
    Quote Originally Posted by atchoooo
    Sorry I did not read windows .. then block it with a Windows Firewall like Black Ice Defender or something else similar.
    Or, unless you need to connect to MySQL from other servers, just configure it to only listen for local connections?

  12. #12
    I have the exact same problem on my Windows Box! How do I restrict acces with the IPtables?

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •