MySQL server connection question.

[Jeffrey M. Johnson]

I hope a simple question,

 

Can a MySQL Client (5.0.14) connect to a MySQL Server (5.1.22) (or more
specifically I have a static build of PHP using the libmsqlclient.la from
MySQL version 5.0.14 as a client attempting to connect to a MySQL server
running version 5.1.22rc.)?

 

My thanks in advance

 

Jeff Johnson 

 

slow-query log

[Jeffrey M. Johnson]

I noticed something interesting with our slow-query log and am looking for
an answer.

 

Our slow-query log is set for to record anything over 7 seconds.

 

In monitoring the server I ran the show full processlist  I occasionally
see entries like 

 

| ID | USER | HOST | DATABASE | Query   | 120| sleep | QUERY |

 

Where the 120 is the time; which is well over are threshold of 7 seconds.
However the query is not written to our slow-query.log file and to the best
of my knowledge is not counted as a slow query.

 

Why does this occur?  

 

My guess it only counts active query time and not sleep time.

 

Jeff

Average Time per query.

[Jeffrey M. Johnson]

How do you determine the average time per query in MySQL?

Jeff Johnson


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