-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Martijn van den Burg wrote: > Hi, > > While I was on holiday our production MySQL 4.1.10 (Solaris 8) had to be > restarted due to a filesystem upgrade (NetApp). After the restart, when > I came back from my holiday, I noticed that INSERT performance has > dropped dramatically and that the machine generates a lot more UDP > traffic seemingly just 'talking to itself'. UDP traffic is more or less > steadily high, no peaks/valleys. > > The box is hardened and cannot be accessed from outside the company, so > no other users than root, mysql can access it. It runs some monitoring > tools (Big Brother, TNG) but is further a dedicated MySQL system. > No system parameters have been changed in my absence. > > The OS boys think it is MySQL-related because they can't find anything > on their side. > > Any idea why MySQL would generate a lot of continuous UDP traffic? > > > Regards, > > Martijn > >
Martijn, MySQL itself doesn't generate UDP traffic (the protocol runs over TCP/IP). However, MySQL relies on DNS unless you've specified - --skip-name-resolve when you started the server. DNS travels over UDP. You also mention you're using a NetAPP. NFS (unless you tell it to run over TCP/IP) also uses UDP. If you didn't upgrade MySQL, and only the filer and the filesystem, I would start looking at _that_. If you can rule out the NetAPP filesystem generating more UDP traffic, then look for DNS issues. Did your "OS boys" look at the destination for these packets (port # and host), as that would tell you a _lot_ about why they're being sent. -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDBdn7tvXNTca6JD8RAjmeAKCI12gFzECjmQu4rvj6sk4+ru5YcQCgkHED OsYm7tkRz/rfH8Gs3j7PO7M= =XC4T -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
