Forums

MySQL net_read_timeout increase

Is there a way to increase the read timeout on the database? I have been getting "Read operation timed out" error recently since my data has grown substantially and sometimes the read operation takes a lot of time.

Also, I have moved some of the heavy processing to a task queue. I wanted to ask if the always on task is run in a separate process which is independent of the worker threads, correct? It won't impact my website's performance?

I tried changing the ~/my.cnf file with the values net_read_timeout = 300

But this doesn't seem to have an effect as show variables like '%timeout%' still shows 30 for net_read_timeout.

The always-on task is running separately from your web apps, but it's sharing your MySQL user's connections limit.

To avoid net_read_timeout problems try limiting the max number of results, or breaking up your query into several smaller ones.