Low performance mysql problem?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
mouragio
Registered User
Posts: 10
Joined: Thu Nov 22, 2007 7:55 am

Low performance mysql problem?

Post by mouragio » Tue Nov 10, 2009 7:59 am

hi All;
a little history:
On my server Compaq DL580G2 with >4 GB ram and 4x36,4 SCSI disks in raid 5; has the following:
- Mysql server 5.1.40
- Mysql Client 5.1.40
- Apache 2.2
- Php 5

On this server i've an forum with phpbb 3.01 (I knwo; i must upgrade). the performance was reasonable.

Last week i've helped a friend of mine with his forums; because he has some hosting provider problems. We have moved hist forums to our server. The visitors of that forum are now complaining that the performance is sometimes not so good. I've experienced this as well. I've played a little with the mysql configuration; but that didn't had the desired outcome.

Now if i turn on slow query log; the following is strange to me:
/usr/local/libexec/mysqld, Version: 5.1.40-log (FreeBSD port: mysql-server-5.1.40). started with:
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
# Time: 091110 2:40:06
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.905759 Lock_time: 0.000163 Rows_sent: 20 Rows_examined: 840091
use vwforum_nwb;
SET timestamp=1257817206;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 3:10:32
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.747627 Lock_time: 0.000173 Rows_sent: 20 Rows_examined: 840090
SET timestamp=1257819032;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 3:17:40
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 19.464543 Lock_time: 0.000277 Rows_sent: 50 Rows_examined: 928340
SET timestamp=1257819460;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, t.topic_id, t.topic_status, t.topic_last_post_time, t.topic_title, t.topic_time, t.topic_replies, t.topic_views, p.post_id, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_topics t, phpbb_posts p, phpbb_users u) WHERE t.topic_moved_id = 0 AND p.post_approved = 1 AND ( f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND u.user_id = p.poster_id AND p.forum_id IN (78, 51, 35, 36, 37) AND p.post_id = t.topic_last_post_id ) AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 50;
# Time: 091110 3:18:48
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 19.852371 Lock_time: 0.000202 Rows_sent: 50 Rows_examined: 928340
SET timestamp=1257819528;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, t.topic_id, t.topic_status, t.topic_last_post_time, t.topic_title, t.topic_time, t.topic_replies, t.topic_views, p.post_id, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_topics t, phpbb_posts p, phpbb_users u) WHERE t.topic_moved_id = 0 AND p.post_approved = 1 AND ( f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND u.user_id = p.poster_id AND p.forum_id IN (78, 51, 35, 36, 37) AND p.post_id = t.topic_last_post_id ) AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 50;
# Time: 091110 3:19:54
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 19.945872 Lock_time: 0.000203 Rows_sent: 50 Rows_examined: 928340
SET timestamp=1257819594;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, t.topic_id, t.topic_status, t.topic_last_post_time, t.topic_title, t.topic_time, t.topic_replies, t.topic_views, p.post_id, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_topics t, phpbb_posts p, phpbb_users u) WHERE t.topic_moved_id = 0 AND p.post_approved = 1 AND ( f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND u.user_id = p.poster_id AND p.forum_id IN (78, 51, 35, 36, 37) AND p.post_id = t.topic_last_post_id ) AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 50;
# Time: 091110 3:20:15
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 19.450903 Lock_time: 0.000403 Rows_sent: 50 Rows_examined: 928340
SET timestamp=1257819615;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, t.topic_id, t.topic_status, t.topic_last_post_time, t.topic_title, t.topic_time, t.topic_replies, t.topic_views, p.post_id, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_topics t, phpbb_posts p, phpbb_users u) WHERE t.topic_moved_id = 0 AND p.post_approved = 1 AND ( f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND u.user_id = p.poster_id AND p.forum_id IN (78, 51, 35, 36, 37) AND p.post_id = t.topic_last_post_id ) AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 50;
# Time: 091110 3:20:36
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 19.736383 Lock_time: 0.000319 Rows_sent: 50 Rows_examined: 928340
SET timestamp=1257819636;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, t.topic_id, t.topic_status, t.topic_last_post_time, t.topic_title, t.topic_time, t.topic_replies, t.topic_views, p.post_id, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_topics t, phpbb_posts p, phpbb_users u) WHERE t.topic_moved_id = 0 AND p.post_approved = 1 AND ( f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND u.user_id = p.poster_id AND p.forum_id IN (78, 51, 35, 36, 37) AND p.post_id = t.topic_last_post_id ) AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 50;
# Time: 091110 3:20:57
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 19.564545 Lock_time: 0.000282 Rows_sent: 50 Rows_examined: 928340
SET timestamp=1257819657;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, t.topic_id, t.topic_status, t.topic_last_post_time, t.topic_title, t.topic_time, t.topic_replies, t.topic_views, p.post_id, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_topics t, phpbb_posts p, phpbb_users u) WHERE t.topic_moved_id = 0 AND p.post_approved = 1 AND ( f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND u.user_id = p.poster_id AND p.forum_id IN (78, 51, 35, 36, 37) AND p.post_id = t.topic_last_post_id ) AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 50;
# Time: 091110 3:40:57
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.831585 Lock_time: 0.000216 Rows_sent: 20 Rows_examined: 840091
SET timestamp=1257820857;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:04:51
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.667780 Lock_time: 0.000338 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822291;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:05:59
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.624386 Lock_time: 0.000173 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822359;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:06:20
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.721041 Lock_time: 0.000228 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822380;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:06:41
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.774874 Lock_time: 0.000234 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822401;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:06:58
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.938736 Lock_time: 0.000157 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822418;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:07:19
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.890010 Lock_time: 0.000159 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822439;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:07:40
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 16.070571 Lock_time: 0.000190 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822460;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:08:01
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.962856 Lock_time: 0.000277 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822481;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:09:11
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.850341 Lock_time: 0.000173 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822551;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:10:17
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.887499 Lock_time: 0.000251 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822617;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:10:37
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.880464 Lock_time: 0.000177 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822637;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:10:58
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.778025 Lock_time: 0.000156 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822658;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:11:19
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.873710 Lock_time: 0.000258 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257822679;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:11:35
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.850407 Lock_time: 0.000254 Rows_sent: 20 Rows_examined: 840091
SET timestamp=1257822695;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 4:42:01
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.730286 Lock_time: 0.000318 Rows_sent: 20 Rows_examined: 840091
SET timestamp=1257824521;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 5:12:29
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.941196 Lock_time: 0.000214 Rows_sent: 20 Rows_examined: 840091
SET timestamp=1257826349;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 5:42:55
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.997859 Lock_time: 0.000163 Rows_sent: 20 Rows_examined: 840091
SET timestamp=1257828175;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 6:13:28
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.965365 Lock_time: 0.000172 Rows_sent: 20 Rows_examined: 840091
SET timestamp=1257830008;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 6:21:41
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.698334 Lock_time: 0.000177 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257830501;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 6:22:52
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.617792 Lock_time: 0.000162 Rows_sent: 20 Rows_examined: 840151
SET timestamp=1257830572;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 6:43:54
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 15.655938 Lock_time: 0.000347 Rows_sent: 20 Rows_examined: 840092
SET timestamp=1257831834;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 7:14:20
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 16.334727 Lock_time: 0.000171 Rows_sent: 20 Rows_examined: 840093
SET timestamp=1257833660;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 7:17:44
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 17.446883 Lock_time: 0.000286 Rows_sent: 20 Rows_examined: 840153
SET timestamp=1257833864;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 7:18:48
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 16.424095 Lock_time: 0.000265 Rows_sent: 20 Rows_examined: 840153
SET timestamp=1257833928;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
# Time: 091110 7:19:54
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 16.018038 Lock_time: 0.000262 Rows_sent: 20 Rows_examined: 840153
SET timestamp=1257833994;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
all the query's that turn out slow are slightly the same; and the rows_examined are all above 800.000. perticulary this amount worries me...

Does anyone has any clue what can cause the slowdown? and more important: what can i do about it? is there maybe an corrupt table? indexing problems?......

thanxx in advance for tour answers...
Last edited by mouragio on Tue Nov 10, 2009 8:10 am, edited 1 time in total.

mouragio
Registered User
Posts: 10
Joined: Thu Nov 22, 2007 7:55 am

Re: Low performance mysql problem?

Post by mouragio » Tue Nov 10, 2009 8:00 am

ow one more thing... the forum that is added is an version 3.0.5; so up to date....

User avatar
Kellanved
Former Team Member
Posts: 2635
Joined: Wed Jan 26, 2005 2:48 pm
Location: Meta-level

Re: Low performance mysql problem?

Post by Kellanved » Tue Nov 10, 2009 8:24 am

That is a very poorly written query. In fact, it does not look like a query you would find in phpBB - probably some MOD.
Nocando is in Idontwanna county. No support via PM

mouragio
Registered User
Posts: 10
Joined: Thu Nov 22, 2007 7:55 am

Re: Low performance mysql problem?

Post by mouragio » Tue Nov 10, 2009 8:57 am

ok; I've asked what mods are implemented...

that could be :) thanxx for the answer. will return with the result...

mouragio
Registered User
Posts: 10
Joined: Thu Nov 22, 2007 7:55 am

Re: Low performance mysql problem?

Post by mouragio » Tue Nov 10, 2009 9:10 am

hmmm doens't look like a mod...

mods installed:
-Quickreply
- RSS feeds 2.0
- Ultimate SEO 0.60
- paypal donate

Just got a longrunner myself; and it was on the "view latest posts" query...
had a tail on the slow query log and instantly it came with the same:
# Time: 091110 10:09:24
# User@Host: vwforum[vwforum] @ localhost []
# Query_time: 19.335539 Lock_time: 0.000266 Rows_sent: 20 Rows_examined: 840140
SET timestamp=1257844164;
SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, u.username, u.user_id, u.user_email, u.user_allow_viewemail FROM (phpbb_forums f, phpbb_posts p, phpbb_users u) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id AND u.user_id = p.poster_id AND f.forum_id NOT IN (35, 36, 51, 54, 55, 56, 79, 104) ORDER BY p.post_time DESC
LIMIT 20;
So it'looks like it is standard phpbb ?

User avatar
Kellanved
Former Team Member
Posts: 2635
Joined: Wed Jan 26, 2005 2:48 pm
Location: Meta-level

Re: Low performance mysql problem?

Post by Kellanved » Tue Nov 10, 2009 9:36 am

mouragio wrote:
So it'looks like it is standard phpbb ?
No, looks like a MOD. I am almost certain that that isn't a phpBB query.
Nocando is in Idontwanna county. No support via PM

mouragio
Registered User
Posts: 10
Joined: Thu Nov 22, 2007 7:55 am

Re: Low performance mysql problem?

Post by mouragio » Tue Nov 10, 2009 9:51 am

ok; thank you... Maybe it's the SEO... i will look further in it.

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 2523
Joined: Mon Jul 10, 2006 9:58 pm
Name: Andreas Fischer

Re: Low performance mysql problem?

Post by bantu » Wed Nov 11, 2009 1:39 pm

Just update to 3.0.6-RC or 3.0.6 when it's released and you'll have ATOM/RSS and QuickReply built in. :)
Powered by Coffee

mouragio
Registered User
Posts: 10
Joined: Thu Nov 22, 2007 7:55 am

Re: Low performance mysql problem?

Post by mouragio » Fri Nov 13, 2009 9:03 am

thanx... update will be done as soon as it's out of RC; but i think that has nothing to do with the performance...

what i saw was that the old server was a dell 1950; so 64 bit machine... this one is a compaq dl580; 32 bits...

But that should not make a diffrece; or will it?

mouragio
Registered User
Posts: 10
Joined: Thu Nov 22, 2007 7:55 am

Re: Low performance mysql problem?

Post by mouragio » Fri Nov 13, 2009 9:30 am

another thing; looks like there is another problem... the slowdown doesn't seem to be in the above....

just had another; yesterday in the evening this list was very, very long... this one is a bit shorter; but... the state "locked" doesn't seem very good...
+--------+---------+-----------+-------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+---------+-----------+-------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 171037 | root | localhost | | Query | 0 | | show processlist |
| 171283 | vwforum | localhost | vwforum_nwb | Query | 18 | Sorting result | SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_i |
| 171291 | vwforum | localhost | vwforum_nwb | Query | 16 | Locked | UPDATE phpbb_users
SET user_lastvisit = 1258104426
WHERE user_id = 25543 |
| 171310 | vwforum | localhost | vwforum_nwb | Query | 13 | Locked | SELECT u.*, s.*
FROM phpbb_sessions s, phpbb_users u
WHERE s.session_id = 'a3c2a8c4bb29cc055 |
| 171312 | vwforum | localhost | vwforum_nwb | Query | 13 | Locked | SELECT u.*, s.*
FROM phpbb_sessions s, phpbb_users u
WHERE s.session_id = '83be0f6f749e7c3b5 |
| 171314 | vwforum | localhost | vwforum_nwb | Query | 12 | Locked | SELECT u.*, s.*
FROM phpbb_sessions s, phpbb_users u
WHERE s.session_id = 'a3c2a8c4bb29cc055 |
| 171336 | vwforum | localhost | vwforum_nwb | Query | 7 | Locked | SELECT u.*, s.*
FROM phpbb_sessions s, phpbb_users u
WHERE s.session_id = 'fd02ab43c9c875247 |
| 171351 | vwforum | localhost | vwforum_nwb | Query | 4 | Locked | SELECT u.*, s.*
FROM phpbb_sessions s, phpbb_users u
WHERE s.session_id = '680762d79d5e82e9b |
+--------+---------+-----------+-------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
Uptime: 46142 Threads: 8 Questions: 1920542 Slow queries: 102 Opens: 63376 Flush tables: 1 Open tables: 64 Queries per second avg: 41.622
Can anyone help me with this? i'm getting a little frustrated by these slowdowns...

thanxx in advance for your help.

mouragio
Registered User
Posts: 10
Joined: Thu Nov 22, 2007 7:55 am

Re: Low performance mysql problem?

Post by mouragio » Mon Nov 23, 2009 10:25 am

I'm a little bit further now...
The tables topics and forums are now on innodb instead of MyISAM, that part doesn't lock anymore

Problem with the slow query exist:
| Id | User | Host | db | Command | Time | State | Info
|
+-------+---------+-----------+-------------+---------+------+----------------------+--------------------------------------------------------------------------------
----------------------+
| 17311 | vwforum | localhost | vwforum_nwb | Query | 218 | Copying to tmp table | SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.forum_topi
cs, f.forum_posts, f. |
| 17425 | vwforum | localhost | vwforum_nwb | Query | 201 | Locked | INSERT INTO phpbb_posts (forum_id, poster_id, icon_id, poster_ip, post_time, p
ost_approved, enable_ |
| 17426 | vwforum | localhost | vwforum_nwb | Query | 200 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 10979
AND p.post_approved = 1


ORDE |
| 17452 | vwforum | localhost | vwforum_nwb | Query | 194 | Locked | SELECT o.*, p.bbcode_bitfield, p.bbcode_uid
FROM phpbb_poll_options o, phpbb_posts p
WHERE o.top |
| 17455 | vwforum | localhost | vwforum_nwb | Query | 193 | Locked | SELECT p.*, f.forum_id, f.forum_name, t.*, u.username, u.username_clean, u.user
_sig, u.user_sig_bbco |
| 17456 | vwforum | localhost | vwforum_nwb | Query | 193 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 38777
AND p.post_approved = 1


ORDE |
| 17477 | vwforum | localhost | vwforum_nwb | Query | 187 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 93542
AND p.post_approved = 1


ORDE |
| 17484 | vwforum | localhost | vwforum_nwb | Query | 186 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 93855
AND p.post_approved = 1


ORDE |
| 17508 | vwforum | localhost | vwforum_nwb | Query | 181 | Locked | SELECT p.*, f.forum_id, f.forum_name, t.*, u.username, u.username_clean, u.user
_sig, u.user_sig_bbco |
| 17509 | vwforum | localhost | vwforum_nwb | Query | 181 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 93933
AND p.post_approved = 1


ORDE |
| 17511 | vwforum | localhost | vwforum_nwb | Query | 180 | Locked | SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id,
f.left_id, f.right_i |
| 17518 | vwforum | localhost | vwforum_nwb | Query | 179 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 93855
AND p.post_approved = 1


ORDE |
| 17539 | vwforum | localhost | vwforum_nwb | Query | 176 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 38777
AND p.post_approved = 1


ORDE |
| 17540 | vwforum | localhost | vwforum_nwb | Query | 176 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 93855
AND p.post_approved = 1


ORDE |
| 17552 | vwforum | localhost | vwforum_nwb | Query | 172 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 91949
AND p.post_approved = 1


ORDE |
| 17561 | vwforum | localhost | vwforum_nwb | Query | 170 | Locked | SELECT f.forum_id, f.forum_status, f.forum_password, f.forum_name, f.parent_id,
f.left_id, f.right_i |
| 17569 | vwforum | localhost | vwforum_nwb | Query | 167 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 82481
AND p.post_approved = 1


ORDE |
| 17573 | vwforum | localhost | vwforum_nwb | Query | 166 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 91181
AND p.post_approved = 1


ORDE |
| 17574 | vwforum | localhost | vwforum_nwb | Query | 166 | Locked | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 78003
AND p.post_approved = 1


ORDE |
| 17578 | vwforum | localhost | vwforum_nwb | Query | 166 | Locked | SELECT p.post_id

etc etc etc.....
The thing that bothers me is the top query (Copying to tmp table) I think this is now the one that occupies the phpbb_posts table; therefore all other query's are locked....

Problem is I cannot convert phpbb_posts to innobd because fulltekst mysql search is used....

Maybe now somebody has a clue?

thanxx, regards, rene

User avatar
Kellanved
Former Team Member
Posts: 2635
Joined: Wed Jan 26, 2005 2:48 pm
Location: Meta-level

Re: Low performance mysql problem?

Post by Kellanved » Mon Nov 23, 2009 10:53 am

Many, possibly all, of these queries are not phpBB queries, I suspect poorly written MODs. Particularly something that adds bbcode to polls and some topic aggregator - RSS feeds possible?
Nocando is in Idontwanna county. No support via PM

mouragio
Registered User
Posts: 10
Joined: Thu Nov 22, 2007 7:55 am

Re: Low performance mysql problem?

Post by mouragio » Mon Nov 23, 2009 12:15 pm

ok; well I dunno any more....

20 minutes ago the server has hung up itself (too many connections)...

restart of mysql-server was very slow; now it is running again.


The strange thing is that the "old" server (Dell 1950 64bit 4GB/ 2x146GB SAS) was running very smoothly with the same site (did only an export/import)...

LiamWi
Registered User
Posts: 23
Joined: Tue Jan 29, 2008 12:52 pm

Re: Low performance mysql problem?

Post by LiamWi » Sat Nov 28, 2009 6:53 pm

I am having this problem too. I removed Simple Syndication and it is still happening.

Also removed Knowledge Base and the SEO which were both disabled but still there. I'll let you know if it helps.

LiamWi
Registered User
Posts: 23
Joined: Tue Jan 29, 2008 12:52 pm

Re: Low performance mysql problem?

Post by LiamWi » Sat Nov 28, 2009 7:20 pm

Nope it is still happening.

Locked

Return to “[3.0.x] Support Forum”