the admin always send me email saying the 4images program cause mysql problem and he is about to blocking my site this is the last email from him :
it just cuases mysql to go nuts, the queries just sit there and more and more
come over and over.
mysql> show processlist;
+---------+----------------------+----------------------------+-----------+
---------+------+----------------------+-----------------------------------
-------------------------------------------------------------------+
| Id | User | Host | db |
Command | Time | State | Info
|
+---------+----------------------+----------------------------+-----------+
---------+------+----------------------+-----------------------------------
-------------------------------------------------------------------+
| 2191597 | maghna | localhost | maghna |
Query | 7 | Writing to net | SELECT DISTINCT i.image_id,
i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords |
| 2191601 | maghna | localhost | maghna |
Query | 2 | Copying to tmp table | SELECT DISTINCT i.image_id,
i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords |
| 2191603 | maghna | localhost | maghna |
Query | 2 | Copying to tmp table | SELECT DISTINCT i.image_id,
i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords |
| 2191606 | root | localhost | NULL |
Query | 0 | NULL | show processlist
|
| 2191607 | maghna | localhost | maghna |
Query | 8 | Writing to net | SELECT c.cat_id, c.cat_name,
c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_vie |
| 2191609 | nydeasoft | www.nydeasoftware.com:2178 | nydeasoft |
Sleep | 2 | | NULL
|
| 2191610 | maghna | localhost | maghna |
Query | 0 | Copying to tmp table | SELECT c.cat_id, c.cat_name,
c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_vie |
| 2191613 | nydeasoft | www.nydeasoftware.com:1387 | nydeasoft |
Query | 0 | Writing to net | SELECT p.program_id,
p.program_title, p.program_long_descr, p.program_type_id,
pt.program_type_descr |
| 2191614 | mcnicks | localhost | mcnicks |
Query | 0 | Writing to net | SELECT * FROM wp_users WHERE
user_level > 0 |
| 2191615 | maghna2 | localhost | maghna2 |
Query | 0 | Writing to net | SELECT * FROM book_config
|
| 2191616 | maghna | localhost | maghna |
Query | 0 | Writing to net | SELECT setting_name, setting_value
FROM 4images_settings |
| 2191618 | nydeasoft | www.nydeasoftware.com:4197 | nydeasoft |
Query | 0 | Writing to net | SELECT DISTINCT(p.program_id),
p.program_title, p.program_url, p.program_type_id, pt.program_type_de |
| 2191619 | unauthenticated user | localhost | NULL |
Connect | NULL | Writing to net | NULL
|
+---------+----------------------+----------------------------+-----------+
---------+------+----------------------+-----------------------------------
-------------------------------------------------------------------+
16 rows in set (0.00 sec)i need help plz whats going on ?