Alright, my server has 99% CPU loaded by mysqld all the time unfortenetely. Everyone tells me I need to upgrade mysql and it would really help my server's performance, Plus you can tweak 5.xx better.
So I decided to upgrade =)
Hopefully someone can help me do that w/o loosing my MySQL Data =)
OS: Fedora Core 3
Looking for some easy way to upgrade.... apt-get didn't work. Says there is nothing to upgrade... actually didn't want to update my PHP either... I went through hell upgrading this a month ago.
So I found some RPMs: http://remi.collet.free.fr/index.php...4-mysql-5020-1
Well... should be easy to upgrade with yum? right? well, no, gave me an error:
[root@fc3 ~]# yum --enablerepo=remi update mysql\*
Traceback (most recent call last):
File "/usr/bin/yum", line 7, in ?
File "/usr/share/yum-cli/yummain.py", line 34, in main
File "/usr/lib/python2.3/locale.py", line 381, in setlocale
return _setlocale(category, locale)
locale.Error: unsupported locale setting
yeah, btw, how do I change my default sys locale back to en_US? =) lol
surely, there is always an option to wipe out MySQL 3.xx rpms... and then install 5.0.20 Rpms... but is there a better way? I'm just really afraid to screw system up. It's a production server. Hope someone can help.