set timeout for a mysql query in node js

[Juilee Chitre]

Hello,

I am referring to this post on stackoverflow. 

http://stackoverflow.com/questions/14406488/node-js-mysql-query-timeout

I am using node for server-side scripting and my web application is connected to a MySQL database. The database has tables having around 60 million rows. I have the need to query the database and retrieve the response and display on my web-page. But, since the database takes around a few minutes to process a query, node js renders the page before the data is retrieved.

Is there any way to set up timeout for a mysql query in node js?

Thank you.

Regards,

Juilee

[Chris Wakare]

Hi Juilee,

You can override the default connection timeout http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html  This however should be a temporary fix/alternative. Do consider  sharding on a mysql cluster ( http://www.mysql.com/products/cluster/scalability.html)  

Thanks,

Chris