Database performance tuning
So I decided to try it on the Linode with MySQL. And the performance sucks sucks suck. It took 42:01.
I think the application itself is a bit big, "top" shows it as 12m. But there's got to be some way to tune MySQL to fit well on a 96Mb linode. Any hints?
Have you tweaked MySQL via my.cnf? Sometimes that helps performance
Tweaked what? Any suggestions what parameters to tune, and what values work on a 96?
watch -n1 cat /proc/io_status
For the former, if you see tokens go negative, you've hit the limiter – most likely due to swap thrashing, which the second command will show you (si and so).
Some of mysql's default settings will eat up a decent chunk of RAM, and depending on other things you've got running you might be swap thrashing.
It's amazingly annoying - I took the database dumps and the code directly from Gradwell to here, and yet on Gradwell it takes 1:14 and here it takes 43:54.
Keep in mind that Xen is coming, which will greatly improve performance. Compare the following kernel build times:
dom0 (Xen host): 5m19.758s