Mysql Problems

[waleed]

the admin sent me email saying the 4images program cause Mysql Problems this is the Log

I noticed a script on your site has been causing mysql problems on my web
server for some reason:

| 1042850 | maghna    | localhost             | maghna    | Query   | 2
| 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 |
| 1042853 | maghna    | localhost             | maghna    | Query   | 1
| Locked               | SELECT c.cat_id, c.cat_name, c.cat_description,
c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_vie |
| 1042854 | maghna    | localhost             | maghna    | Query   | 1
| Locked               | SELECT c.cat_id, c.cat_name, c.cat_description,
c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_vie |
| 1042855 | maghna    | localhost             | maghna    | Query   | 1
| Locked               | SELECT c.cat_id, c.cat_name, c.cat_description,
c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_vie |
| 1042856 | maghna    | localhost             | maghna    | Query   | 1
| Locked               | SELECT c.cat_id, c.cat_name, c.cat_description,
c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_vie |

It looks like maybe a gallery script or something? Please check it for me
and let me know.
BTW i didnt make any  modification or add any scripts so plz whats the problem ?

[V@no]

mmmm....and the problem is....
that is the problem explanation your administrator gave u???
They mention some problems, but they didnt explain what EXACTLY are the problems?

[waleed]

ok veno thanx for replying
this is the Description from the admin :

The problem is not really the bandwidth even though it is using a lot, but
its the mysql thing. I see the problem really comes from the file
category.php and the way you put ReWrite rules or something.

in fact i didnt understand what really the problem can u help me plz 

[V@no]

actualy he still didnt explain WHAT EXACTLY IS THE PROBLEM...

[Chris]

I've seen this kind of reply before.  This is a clear indication of a hosting reseller who is inexperienced in technical support or a hosting company with support teams off-shore who are inexperienced.  Sound right?

[waleed]

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 ?

[V@no]

well, if u ask them to explain what is the problem and they still trying present them selves like they know what they are talking about and yet explain nothing, then perhaps let them read this topic...I dont know what else to suggest u...

[waleed]

V@no do u think its random pic problem ?

[V@no]

I dont know what is the problem in the first place...how can I say something not knowing what are they talking about?

[Chris]

16 rows in set (0.00 sec)[/b]

That doesn't look like a problem to me.  Without more details from your provider about the problem I don't see how anyone can offer suggestions.

[waleed]

i really need help veno or any smart boy me and my admin dont know how can we solve this problem .. ADMIN always says ur 4images causing mysql problems andd he cant explain where is the problem exactly so this the last emal from him :

Hey,

I wanted to say your images is causing mysql problems again but they seem
to be very random.

See this:

| 710877 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710878 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710880 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710881 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710882 | maghna               | localhost                       | maghna
| Query   | 5    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710883 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710884 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710885 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710886 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710887 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710889 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710891 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710892 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710893 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710895 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710896 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT i.image_id, i.cat_id,
i.user_id, i.image_name, i.image_description, i.image_keywords, i.image |
| 710899 | maghna               | localhost                       | maghna
| Query   | 4    | closing tables       | SELECT c.cat_id, c.cat_name,
c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_vie |

This happens many many many times I dont know, maybe someone is flooding or
mass downloading from the web site? These lines show like 50 times it
should never be so much

you guys plz help me

[V@no]

ok, "can u tell me how can I fix my car? no? why not? ah...u dont even know what is wrong with it..."
so, what is your (admin's) question again?

P.S. did your admin see this thread yet? if he/she has and yet still sends u same type of email, then there is something wrong with the admin, not mysql...

[V@no]

ADMIN always says ur 4images causing mysql problems andd he cant explain where is the problem exactly

oh gee...is there anything so unique (besides the admin) in your host provider that other hosts dont have, which hold you from switching?

[waleed]

ok veno do u see any problem with the code i posted ?
and i'll give him the link right now

[V@no]

no, I dont even see on what I should pay attention there...that is just mysql access log if I'm not misstaken...