Subject: Provider
Provider ist 1und1 mit 10 Mysql-Datenbanken im Paket.
Es ging laut 1und1 um die Rechenleistungen, die eine hohe Serverlast verursacht haben sollen:
Email von 1und1:
Es handelte sich um Abfragen folgender Form, welche in ihrer grossen
Anzahl problematisch sind:
dbo105265101 114 SELECT LastActivity FROM `unb1_Guests` WHERE
Session=%%;
dbo105265101 98 DELETE FROM `unb1_Guests` WHERE LastActivity<%%;
dbo105265101 89 UPDATE `unb1_Guests` SET `LastActivity`=%%,
`LastForum`=%% WHERE Session=%%;
dbo105265101 82 SELECT COUNT(*) FROM `unb1_Guests` WHERE LastActivity >
%% AND UserName <> %%;
dbo105265101 63 SELECT COUNT(*) FROM `unb1_Stat` WHERE Date=%%;
dbo105265101 51 SELECT * FROM `unb1_Users` WHERE ID=%%;
dbo105265101 50 UPDATE `unb1_Stat` SET OnlineUsers = %% WHERE Date=%%;
dbo105265101 50 UPDATE `unb1_Stat` SET OnlineGuests = %% WHERE Date=%%;
dbo105265101 48 SELECT * FROM `unb1_Posts` WHERE ID=%%;
dbo105265101 41 INSERT INTO `unb1_Guests` SET `Session`=%%,
`LastActivity`=%%, `UserName`=%%;
dbo105265101 40 UPDATE `unb1_Stat` SET PageHits = %% + %% WHERE Date=%%;
dbo105265101 35 SELECT `Group` FROM `unb1_GroupMembers` WHERE User=%%;
dbo105265101 26 SELECT unb1_Threads.ID, unb1_Threads.Forum FROM
unb1_Posts LEFT JOIN unb1_Threads ON unb1_Posts.Thread = %% WHERE
(unb1_Posts.Date >= %%) GROUP BY unb1_Threads.ID;
dbo105265101 18 SELECT unb1_Posts.*, unb1_Users.Name AS UserName2 FROM
unb1_Threads LEFT JOIN unb1_Posts ON unb1_Posts.Date=%% AND
unb1_Posts.Thread=%% LEFT JOIN unb1_Users ON unb1_Posts.User=%% WHERE
unb1_Posts.Thread IN %%;
dbo105265101 17 SELECT * FROM `unb1_Threads` WHERE ID=%%;
dbo105265101 13 DESCRIBE `unb1_Forums`;
dbo105265101 11 UPDATE `unb1_Threads` SET `Views` = `Views` + %% WHERE
ID=%%;
dbo105265101 10 UPDATE `unb1_Guests` SET `LastActivity`=%% WHERE
Session=%%;
dbo105265101 10 SELECT COUNT(ID) FROM `unb1_Posts` WHERE Thread=%%;
dbo105265101 9 SELECT * FROM `unb1_Forums` WHERE ID=%%;
dbo105265101 7 SELECT * FROM `unb1_Posts` WHERE Thread=%% LIMIT %%;
dbo105265101 5 SELECT COUNT(*) FROM `unb1_Threads` AS t LEFT JOIN
`unb1_UserForumFlags` AS uff_f ON uff_f.User = %% AND uff_f.Forum = %%
AND uff_f.Thread = %% LEFT JOIN `unb1_UserForumFlags` AS uff_t ON
uff_t.User = %% AND uff_t.Forum = %% AND uff_t.Thread = %% WHERE ID IN
%% AND NOT (Options & %%) AND (uff_f.Flags IS NULL OR NOT (uff_f.Flags &
%%)) AND (uff_t.Flags IS NULL OR NOT (uff_t.Flags & %%));
dbo105265101 4 SELECT t.* FROM `unb1_Threads` AS t LEFT JOIN
`unb1_UserForumFlags` AS uff_f ON uff_f.User = %% AND uff_f.Forum = %%
AND uff_f.Thread = %% LEFT JOIN `unb1_UserForumFlags` AS uff_t ON
uff_t.User = %% AND uff_t.Forum = %% AND uff_t.Thread = %% WHERE ID IN
%% AND NOT (Options & %%) AND (uff_f.Flags IS NULL OR NOT (uff_f.Flags &
%%)) AND (uff_t.Flags IS NULL OR NOT (uff_t.Flags & %%)) LIMIT %%;
dbo105265101 4 SELECT * FROM `unb1_Announces` WHERE (Forum=%% OR (Forum
IN %% AND Options & %%)) AND Options & %% AND Options & %% IN %% ORDER
BY Options & %% DESC, Date DESC;
dbo105265101 3 SELECT ip FROM myphpgb_ip_ban WHERE ip=%% AND type=%%;
dbo105265101 3 SELECT COUNT(ID) FROM `unb1_Posts` WHERE Thread=%% AND
Date<=%%;
dbo105265101 3 SELECT comment, date, email, homepage, icq, id, ip, name,
text, time FROM myphpgb_entries LIMIT %%;
dbo105265101 3 SELECT ID, Forum FROM `unb1_Threads` WHERE (Options & %%)
AND Question != %% AND NOT (Options & %%) AND Date >= %% AND
(unb1_Threads.PollTimeout >= %% OR unb1_Threads.PollTimeout = %%);
dbo105265101 3 SELECT unb1_Posts.User, COUNT(*) FROM unb1_Posts GROUP BY
User;
dbo105265101 3 SELECT * FROM `unb1_Users` WHERE ID IN %% ORDER BY ID;
dbo105265101 3 SELECT COUNT(*) FROM `unb1_Threads` AS t LEFT JOIN
`unb1_UserForumFlags` AS uff_f ON uff_f.User = %% AND uff_f.Forum = %%
AND uff_f.Thread = %% LEFT JOIN `unb1_UserForumFlags` AS uff_t ON
uff_t.User = %% AND uff_t.Forum = %% AND uff_t.Thread = %% WHERE
t.Forum=%% AND (uff_t.Flags IS NULL OR NOT (uff_t.Flags & %%));
dbo105265101 2 SELECT bgcolor, bgimage, border, cellpadding,
cellspacing, html, image_email, image_homepage, tablealign, tablewidth,
tdcolor, td2color FROM myphpgb_template WHERE id=%%;
dbo105265101 2 SELECT Thread, count(distinct User) as cnt FROM
`unb1_Posts` WHERE Thread in %% GROUP BY Thread;
dbo105265101 2 SELECT date FROM myphpgb_statistic WHERE date=%%;
dbo105265101 2 SELECT Thread, count(*) AS cnt FROM `unb1_ThreadWatch`
WHERE Thread IN %% GROUP BY Thread;
dbo105265101 2 SELECT bbcode, deactivate_html, default_style,
default_template, entries_per_site, guestbook_status, guestbook_title,
links_in_sitefunction, max_word_length, release_entries, show_ip,
smilies, statistic, statistic_ban FROM myphpgb_properties;
dbo105265101 2 SELECT id FROM myphpgb_entries;
dbo105265101 2 SELECT images_in_entries FROM myphpgb_properties;
dbo105265101 2 SELECT Thread FROM `unb1_Posts` WHERE Thread IN %% AND
User=%%;
dbo105265101 1 SELECT unb1_Posts.ID AS PostID, unb1_Posts.Date,
unb1_Posts.Thread, unb1_Posts.User, unb1_Posts.UserName,
unb1_Threads.Forum, unb1_Threads.Subject, unb1_Threads.Date AS
ThreadDate FROM unb1_Threads LEFT JOIN unb1_Posts ON unb1_Threads.ID =
%% AND unb1_Posts.Date = %% WHERE unb1_Threads.LastPostDate IN %% ORDER
BY unb1_Posts.Date DESC;
dbo105265101 1 UPDATE myphpgb_statistic SET hits=%%+%% WHERE date=%%;
dbo105265101 1 SELECT * FROM `unb1_Announces` WHERE (Forum=%% OR (Forum
IN %% AND Options & %%)) AND Options & %% IN %% ORDER BY Options & %%
DESC, Date DESC;
dbo105265101 1 SELECT bbcode, filename, height, name, width FROM
myphpgb_smilies;
dbo105265101 1 SELECT language FROM myphpgb_properties;
dbo105265101 1 SELECT * FROM `unb1_PollVotes` WHERE Thread=%% ORDER BY
Sort;
dbo105265101 1 SELECT badword FROM myphpgb_badwords;
dbo105265101 1 SELECT style FROM myphpgb_style WHERE id=%%;
dbo105265101 1 SELECT * FROM `unb1_Announces` WHERE (Forum=%%) AND
Options & %% IN %% ORDER BY Options & %% DESC, Date DESC;
dbo105265101 1 SELECT * FROM `unb1_Posts` WHERE ID IN %% LIMIT %%;
dbo105265101 1 SELECT * FROM `unb1_Forums` ORDER BY Parent, Sort;
dbo105265101 1 SELECT unb1_Posts.ID, unb1_Threads.ID, unb1_Threads.Forum
FROM unb1_Posts LEFT JOIN unb1_Threads ON unb1_Posts.Thread = %% WHERE
(unb1_Posts.User = %%);
Reply
solic
Show profile
Link to this post
