Forum Performance

[Rab]

Wirah forum is getting pretty slow at creating new posts. Probably worth a look before it starts failing.

[Rab]

Called it.

[Leland]

thanks rab

[Wirah]

I've noticed this myself. I did get a few error emails. It looks like file upload errors relating to charts in the db.

Database error in vBulletin 5.6.1: 

Invalid SQL: 

SELECT 
IF(filehash = MD5(filedata), 1, 0) AS filehash_matches, 
IF(filesize = LENGTH(filedata), 1, 0) AS filesize_matches 
FROM filedata AS fd 
WHERE filedataid = 2114 

/**checkFiledataConsistency**/; 

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

This one came from Dwopple's account. I assume he was uploading an image.

This doesn't explain why new posts would take time to create though. Either way I've done some research and found a fix that will convert our tables to utf8. I'll run this soon and hopefully we'll see a performance boost (the script also converts some table engines too). Fingers crossed.

I also suspect our tables could do with some optimization too. I'll look into that too. There must be an option somewhere that validates all our indexes and makes sure the tables are setup correctly.