Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I'm looking at the possibility of increasing the wait_timeout on a MySQL server in an effort to avoid a streaming JDBC SELECT in a Solr Data Import Handler from timing out after the default 28800 seconds.

Note: Setting autoReconnect=true on the connection isn't sufficient for my needs.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

What are the negatives of setting a high wait_timeout setting in MySQL?

Idle and persistent connections will obviously take longer to expire. This may mean that you bump up against some default and sane limits.

The first one will be max_connections. Then following that - because of the way which MySQL assigns memory and file descriptors to connections and threads - table_cache, open-files-limit and general RAM consumption will increase.

wait_timeout can act as a bit of a natural guard against these things. You can increase it, but bear in mind that the client-side is at fault and that it may have server-side impact.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.