Forum Very Slow

[Shamil.]

Hi, I'm enquiring about my forum which has become very slow in the past few days:

http://thinkteen.co.uk/forum

The MySQL and http server are hosted on two different machines, both with the same spec. The mysql and http servers have already been optimized and since then, little or no activity has occurred on the forum, so no major changes.

I've disabled all hooks via define('DISABLE_HOOKS', true); but it is still slow.

there is a vB database error when viewing profiles:

Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM album AS album
LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
WHERE album.userid = 65
AND album.state IN ('public', 'private', 'profile')
AND (album.visible > 0 OR album.moderation > 0)
ORDER BY album.lastpicturedate DESC
LIMIT 2;
MySQL Error : Table 'admin_ttvbulletin.picture' doesn't exist
Error Number : 1146
Request Date : Saturday, July 26th 2008 @ 08:21:21 AM
Error Date : Saturday, July 26th 2008 @ 08:21:22 AM
Script : http://thinkteen.co.uk/forum/members/-unreal.html
Referrer : http://thinkteen.co.uk/forum/support....html#post7089
IP Address : Username : Shamil
Classname : vB_Database_MySQL
MySQL Version : 5.0.37-standard

[Steve Machol]

It appears you are missing the 'picture' table. Are you using a table prefix?

[Shamil.]

Hi Steve, I am not using a table prefix as far as I am aware. None is specified in for configuration file.

[Steve Machol]

Strange. I do not see how you could have upgraded without that table being created. Run this query to add that table:

CREATE TABLE picture (
pictureid INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL DEFAULT '0',
caption TEXT,
extension VARCHAR(20) BINARY NOT NULL DEFAULT '',
filedata MEDIUMBLOB,
filesize INT UNSIGNED NOT NULL DEFAULT '0',
width SMALLINT UNSIGNED NOT NULL DEFAULT '0',
height SMALLINT UNSIGNED NOT NULL DEFAULT '0',
thumbnail MEDIUMBLOB,
thumbnail_filesize INT UNSIGNED NOT NULL DEFAULT '0',
thumbnail_width SMALLINT UNSIGNED NOT NULL DEFAULT '0',
thumbnail_height SMALLINT UNSIGNED NOT NULL DEFAULT '0',
thumbnail_dateline INT UNSIGNED NOT NULL DEFAULT '0',
idhash VARCHAR(32) NOT NULL DEFAULT '',
reportthreadid INT UNSIGNED NOT NULL DEFAULT '0',
state ENUM('visible', 'moderation') NOT NULL DEFAULT 'visible',
PRIMARY KEY (pictureid),
KEY userid (userid)
);


You can run queries in the SQL tab in phpMyAdmin, or to run queries from the Admin CP:

Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

Then enter your query in the Manual Query box and click on 'Continue'.

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

$config['SpecialUsers']['canrunqueries'] = 'x';

...with x being your userid number, not username.

[Shamil.]

Done and it works now - but as for it being slow...

[Steve Machol]

Slowness is almost certainly a server issue, particularly since the web server and database are on two different servers. Your forums really aren't large enough to cause slowing on their own.

Since you say these have both been optimized then there really is nothing we can do. I suggest either contacting your host or looking for a server expert to help with this.