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

Rails
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