query_cache_type and Aborted Clients

Revathi Rangachari <[email protected]>
Newsgroups gmane.comp.db.mysql.devel
Message-ID <[email protected]>
Hi 

Can anyone please let me know: 
(1) if query_cache_type is disabled, will it result in the number of 'Aborted Clients' getting increased.  

The possible explanation I have is that because the slow queries are taking a long time to execute, and the fact that the query_cache_type is also disabled, will it result in the clients getting disconnected from the server due to wait_timeout set both at the mysql level and application level?  

In my mysql setup the wait_timeout is 30 secs and the query_cache_type is disabled. I have an ever increasing number of Aborted Clients 


+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| Aborted_clients  | 661117 |
| Aborted_connects | 156    |
+------------------+--------+

The wait_timeout at application level is 5 secs.

Thanks in advance for any explanation on my query
Revathi R




-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.