[SOLVED] Help with my.cnf , and/or any tips to reduce CPU usage (90%) =(

[saintseiya]

Im running a virtual game that reads and writes from a database. Since the writes are a lot on some of the tables, i changed their type to InnoDB, but the others are still the default type (MyIsam?).

 

Anyway my problem is that the mysql seems to be using way too much CPU (90%) and im running dual core 3GHZ each.

 

Memory is fine (3% and under).

 

I was wondering if there is something obvious im doing wrong. I turned on slow query logging a few minutes ago to see if i can get some insights from it but if anyone can advice id greatly appreciate it.

 

Thanks.

 

my.cnf:

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1

 

[mysql.server]

user=mysql

basedir=/var/lib

 

[mysqld_safe]

err-log=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

 

log-slow-queries = /var/log/mysql-slow.log

long_query_time = 2

 

[saintseiya]

Just so everybody who didnt know like me... before i saw crazy loads and got freaked out... make sure you optimize ALL your tables, one badly optimized table can kill your system no matter how good it is hah.

 

Sorry for this question, i feel really dumb now that i know what the problem was. Took down load from 2.00 to 0.04. I feel good now. Good but dumb.