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
devel module
Install the devel module. http://drupal.org/project/devel
It may help you to more exactly pinpoint where the bad queries comes from.
Protect yourself! Make sure
Protect yourself!
Make sure you're backing up your database frequently, just in case they do something without telling you!
- Corey
Hope they wouldn't do that...
Hope they wouldn't do that, bu you are right, German people are not the easiest to deal with...
http://www.oliondor.com