MySql 96% CPU
mysql 531 90.8 3.0
MySQL is using about 90% CPU, is there anyway to optmizie SQL to handle the CPU alot better. The program running on it is a mass mailing demon for mailing lists.
MySQL version is 4.0.18-1
System:
Pentium IIII 3.0Ghz
1024 DDR RAM
FreeBSD 5
