99Percent
Tue 20th Jun '06, 4:15pm
We are also having server performance problems during searches due to the fulltext locking the thread and post tables. Apache connections surges as the current ones are busy waiting for the table locks to be released. All forum users must wait for that one user to get his search results.
It occured to me to install another instance of mysql on this same server and configure it as slave with replication. This instance would have its own database files and a different port.
Then configure vBulletin to use the slaveserver for the search script.
However I notice that vBulletin (in 3.5.3, function db->connect) checks to see if the master and slave have different names. This will not work if both of them are set to localhost even if they are using different ports. So at least a hack will have to be done here.
It occured to me to install another instance of mysql on this same server and configure it as slave with replication. This instance would have its own database files and a different port.
Then configure vBulletin to use the slaveserver for the search script.
However I notice that vBulletin (in 3.5.3, function db->connect) checks to see if the master and slave have different names. This will not work if both of them are set to localhost even if they are using different ports. So at least a hack will have to be done here.