Archive for the ‘MySQL’ Category

plesk won’t start after tweaking mysql

Posted by jon on 13 August, 2007

This post was filed in MySQL and has 4 comments

i’ve had this happen to me again the other week and as always, felt like kicking myself for not remembering.
we do a lot of performance tuning on mysql, and as a result, we almost always manage to get plesk mangled. not its fault, it just can’t run without mysql, doh.
not of preference, but plesk happens [...]

Read the rest of this entry >>

Using symbolic links for MySQL data files

Posted by jon on 15 January, 2007

This post was filed in MySQL and has no comments yet

Over a year ago, we had several servers configured for high traffic websites. A mispartioning resulted in /var becoming obscenely small, and it was only after MySQL crashed that we remembered this. We couldn’t afford more downtime if we dealt with the partition size problem, so I thought of quickly moving the data files into [...]

Read the rest of this entry >>