disabling 'show status' in activerecord because of overhead of spawning process

rubyonrails-talk
1

hi, i have a app which has a spiky activity, there a large period of inactivity between request. With phusion-passenger after a period of inactivity the process is killed, and when the app is respawned the 'show status' queries take more time than the actual sql themself.

I know that ActiveRecord makes the 'show status' query once on spawning the server, but is there some way of disabling 'show status' in activerecord, because of overhead of spawning process.

Alternatively, can i cache only the 'show status' queries in memcache/ redis

thanks, deepak

2

hi, any suggestions, the show status queries are very redundant and makes the startup slow.

Can i memonize it?

cheers, deepak