PIX 525 speed problem with MySQL

[1writeson]

Hi all,

Our network services group just installed a new Cisco PIX 525 firewall

(software version 7.0.1) at one of our mirror sites. This system is

working well, except in one case that I can't resolve. All connections

and protocols are working well except for MySQL throught the VPN back

to our office. If we try to do activity like this:

select * from table;

over the VPN connection, the speed of that transaction becomes horribly

slow to the point of failure. Our standard system is a RedHat

Enterprise Linux machine running MySQL 3.23.58 which has run without a

problem prior to the installation of the PIX firewall. We've

installed MySQL on a Windows and Solaris machines as a test and they exhibited the

same problem. It seems to be related to the small packet size used by

MySQL for the above select statement transaction. Table export/file

imports in MySQL seem to work at a normal speed, it's only the small

packets generated by the select statement that seem to be a problem.

Does anyone have any ideas/suggestions I might recommend in order to

address this problem?

Thanks,

Doug Farrell

[mmellet]

You need to check the release notes for any caveats for this.

[1writeson]

Thanks for the reply, though not that helpful as my Network Services Group has the release notes and isn't very forthcoming with that kind of information. I'll look around the site and see if I can find anything about that, however, I haven't seen anything specific for version 7.0 of the software.

Thanks again,

Doug