Mozilla has launched Firefox 4 web browser. Being in a technical support role at vBulletin.com, I spend the majority of my time in front of a web browser. Currently, I use Firefox 3.6.16 browser with quite alot of useful Firefox Add-ons to make life easier and can have up to...
Came across a useful MySQL query at themattreid.com blog to use MySQL information_schema to calculate MySQL table engine data usage statistics for Innodb and MyISAM. select round(sum(innodb_data_size + innodb_index_size) / (innodb_data_free + sum(innodb_data_size + innodb_index_size))) * 100 as ‘innodb_tablespace_utilization_perc’ , (data_size + index_size) / gb as total_size_gb , index_size /...
‘MySQL server has gone away‘ and ‘Lost connection to server during query‘ MySQL error messages are one of the more common encountered with vBulletin forums. The main reason being non-optimal MySQL server settings – usually the default my.cnf values for MySQL are in use or setting the wait_timeout value too...
Web site page load speed optimization is now the topic of discussion on alot of online webmaster forums. Ever since Google announced changes to their search algorithms to factor in web site page loading speed, there have been alot of tools, guides and resources popping up on the internet for...
vBulletin versions 3.7.x and higher have feature to offload some frequently called database queries to a vBulletin Datastore Cache – which maybe via File cache, Xcache, APC Cache or Memcached server caching. My personal preference is using Xcache for vBulletin Datastore Cache for single server setups which are Apache web...
While setting up 2x load balanced Litespeed web servers for a vBulletin v4.1.2 forum, I came across an issue when I enabled vBulletin config.php for datastore caching via Memcached where vBulletin would report the datastore cache was corrupt with the below quoted message. Rebuilding vBulletin Bitfields from tools.php only fixed...
Another script I installed on a Varnish caching frontend, 4images Image Gallery Management had a similar server port work around fix as with vBulletin v4.1.2. 4images Image Gallery Management script when installed with Varnish cache as frontend, led to resulting image urls being defined as domain.com:82. To fix this so...
Testing vBulletin 4.1.2 with Varnish cache as proxy frontend to Litespeed web server v4.0.20 on a VPS server and came across an interesting problem, in admincp editing options i.e. turning on/off forums, it would timeout. If you use Unixy Varnish Cpanel plugin or Varnish cache, please read below. Looking at...
Name: George Liu
Online Handle: eva2000
Location: Brisbane, Australia
Occupation: vBulletin.com technical support since 2001
This is personal blog and no way officially affiliated with vBulletin.com. [More...]