high cpu mysql load in 4images

[iLinux85]

hello

i have problem with 4images when i running it the server goes to very high cpu load

here is the Queries running when the 4 images running

Code: [Select]

+------+------------------+-----------+------------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id   | User             | Host      | db               | Command | Time | State          | Info                                                                                                 |
+------+------------------+-----------+------------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 2698 | mlaaaz_tobikat   | localhost | user_4images   | Query   |   18 | Sending data   | SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c. |
| 2707 | mlaaaz_tobikat   | localhost | user_4images   | Query   |   18 | Sending data   | SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c. |
| 2735 | mlaaaz_tobikat   | localhost | user_4images   | Query   |   14 | Sending data   | SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c. |
| 2849 | root             | localhost | NULL             | Query   |    0 | NULL           | SHOW PROCESSLIST                                                                                     |
+------+------------------+-----------+------------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)

My mysql configuration

Code: [Select]

[mysqld]
max_connections = 650
safe-show-database
skip-locking
key_buffer = 1536M
max_allowed_packet = 200M
table_cache = 2048
open_files_limit = 6144
sort_buffer_size = 24M
read_buffer_size = 24M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 256M
query_cache_size= 256M
query_cache_limit= 256M
max_heap_table_size = 1024M
tmp_table_size = 1024M
thread_cache_size = 8
wait_timeout = 45
interactive_timeout = 600
long_query_time=1
thread_concurrency = 16
low_priority_updates = 1
join_buffer_size = 4M
concurrent_insert=2
#long_query_time=1
#log-slow-queries=/var/log/mysql/log-slow-queries.log

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -10
open_files_limit = 8192

[mysqlhotcopy]
interactive-timeout

[mysqldump]
quick
max_allowed_packet = 128M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 256M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M