I got this info in Mysql Usage:

mysql CPU 5.43 MEM 135.00 0.0
Top Process %CPU 99.9 [mysqld]
Top Process %CPU 98.6 [mysqld]
Top Process %CPU 98.2 [mysqld]

So i decided to put this in /etc/my.cnf

[safe_mysqld]
log-slow-queries = /var/lib/mysql/mysql-slow-queries.log


but that log does not appear (after serveral days).
why ?

Anyway to optimize that ? it's the resource taking the more part of CPU and MEM...

thanx

Btw... yes... (of course) i restarted mysql
even whole system (because another problem)...

refreshing ...

Add it under the [mysqld] section not under safe_mysqld