Victor Pendleton wrote:
Which logs are you referring to? For you testing purposes, if you have not
already, I would enable the general log and see what is happening on the
MySQL side.

Thanks for the response. Sorry, I'm talking about the general log, that is how I noticed that there were multiple queries getting processed. This is my my.cnf in case it has any obvious problems:


[client]
ssl-ca=/etc/ssl/CA.cer
ssl-cert=/etc/ssl/server.crt
ssl-key=/etc/ssl/server.key

[mysqld]
ssl-ca=/etc/ssl/CA.cer
ssl-cert=/etc/ssl/server.crt
ssl-key=/etc/ssl/server.key
log
log-slow-queries
long_query_time=1
skip-name-resolve

So far we have no long queries...so 1 is okay, and the problem existed before that anyway. skip-name-resolve is there to fix the CPU problem. Everything uses really simple queries. I use SSL usually but the servers don't (haven't tried yet).

Josh

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to