Hello,

I have a website hosted on 1and1, they sent me an email saying that my website (with less than 150 visitors a day) slow down the shared database server, and they gave me a list of requests which make problem, but I don't know what it means nor what to do? Thanks for help! Here is the list they sent me, can you find what might slow down their servers?

DATABASENAME 705 5453[38](7.73) 1437[17](2.04) 621[10](0.88)
59663[9167](84.63)
DATABASENAME 294 SELECT dst FROM url_alias WHERE src = %%;
DATABASENAME 76 SELECT n.nid, n.vid, n.type, n.status, n.created,
n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS
revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid,
u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = %%
INNER JOIN node_revisions r ON r.vid = %% WHERE n.nid = %%;
DATABASENAME 45 SELECT data, created, headers, expire FROM cache WHERE
cid = %%;
DATABASENAME 40 SELECT last_comment_timestamp, last_comment_name,
comment_count FROM node_comment_statistics WHERE nid = %%;
DATABASENAME 25 SELECT t.* FROM term_node r INNER JOIN term_data t ON
r.tid = %% INNER JOIN vocabulary v ON t.vid = %% WHERE r.nid = %% ORDER
BY v.weight, t.weight, t.name;
DATABASENAME 24 SELECT sid FROM sessions WHERE sid = %%;
DATABASENAME 22 SELECT filename, filepath FROM files WHERE nid=%%;
DATABASENAME 18 SELECT iid FROM image_attach WHERE nid=%%;
DATABASENAME 15 INSERT INTO accesslog (title, path, url, hostname, uid,
sid, timer, timestamp) values %%;
DATABASENAME 15 SELECT src FROM url_alias WHERE dst = %%;

Comments

pcs305’s picture

Install the devel module. http://drupal.org/project/devel
It may help you to more exactly pinpoint where the bad queries comes from.

coreyp_1’s picture

Protect yourself!

Make sure you're backing up your database frequently, just in case they do something without telling you!

- Corey

wwwoliondorcom’s picture

Hope they wouldn't do that, bu you are right, German people are not the easiest to deal with...

http://www.oliondor.com