as you may have seen sometimes the SQL backend of this blog dies.
I believe this is caused by the amount of ram available on the machine, but feel free to teach me.
Right now mysql uses
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
23902 mysql 18 0 42M 28M sigwait 0:12 0.83% 0.83% mysqld
I tried to optimize it a little, but had small to none real effect using
query_cache_type = 1
query_cache_size = 1M
query_cache_limit = 1M
thread_cache_size = 3
tmp_table_size = 50000000
key_buffer_size = 6291456
Given that all I have are 192Megs of ram, and the machine is performing happiliy if it weren’t for the DB dying, is there anything I can do? (“Move over to a bigger iron” is not a valid answer).
I think I’m not using InnoDB, and that all tables are MyISAM – if that makes a difference.
I’m on 5.0.2x train already.
In other news, I’m @home in Bologna and I have fever.
It won’t be fun to reach Milan tonight or tomorrow morning. :|