Forum Discussion
hooleylist
Oct 22, 2009Cirrostratus
Couldn't you also check the mysql server status tables or logs to see which client IP addresses are running and which queries they're executing? If you're using SNAT on LTM and having a hard time correlating the query back to the original client IP, you could temporarily log the original and SNAT IP and ports in an iRule.
when SERVER_CONNECTED {
log local0. "[IP::client_addr]:[TCP::client_port] translated to [IP::local_addr]:[TCP::local_port]"
}
Aaron