Re: In memory database

[Erin ONeill]

And don't forget table cache. This has really helped speed up my queries when combined with a larger key_buffer and query_cache. I also set the threads to cache which helped too.

Right now I'm resarching why my set up with 4GB of RAM won't let me set the table cache much above 1240 without crashing (it is lighting fast until it crashes so now that I've had a taste - I want it that fast all the time!). I know my Sys Admins have done some tweaking of the kernel because 1240 is above the default of 1024. I'm just not sure if they've completed the tweaking of the kernel. I know Solaris and not linux. I'm installing linux and tweaking the kernel. Hopefully I'll find the answer to give my sys admins. :)

Make sure that you're file descriptors have been set higher than the default of 1024 (in a bash shell: ulimit -n).


good luck!
erin