Locking tablesSee
Query cacheSee
Optimize vBulletin and MySQLSee
Install "microslow patch" and "mysql slow query log analyzer" they recommend in that article
Optimize MySQL settings for dedicated vBulletinSee
Please always make sure that the size of your RAM is equal or bigger that the following total usage:
memory >= key_buffer + max_connections * (sort_buffer_size + read_buffer_size)
See also ^-- Article recommending best practices and testing methods
username: georgevanous password: no*69
|
|
|