>>> Wei Yan <weiyan1(at)gmail(dot)com> wrote:
> Our queries are extremely slow only after db server reboot
> Any suggestion on how to tackle the problem?
Others have addressed how you can try to prime your cache after a
reboot, so I'll mention the 800 pound gorilla sitting in the corner.
I suggest you don't reboot as often, and when you have to do so,
schedule it off-hours, when there is time for the cache to get
populated with minimal pain.
We basically don't reboot our database servers except when we upgrade
the kernel. Even when we were running Windows as the OS on some
servers we were able to tune it so that reboots could be relatively
infrequent by aggressively disabling services and daemons down to the
bare minimum.
-Kevin