[gabrielt]

Thanks. I was looking for something like this for a while, and for some reason I didn't find this before. I will do some tests and post here is the performance of our forum increased or not.

[gabrielt]

With our very busy forums, converting to InnoDB made the CPU load on our MySQL server to go throught he roof. I had to revert back to MyISAM.

[s_cocis]

how to convert back?

[kotkerk]

create file cv.php with content:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

change args in the line

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

1 arg = convert FROM
2 arg = convert TO
3 arg = show or no output (optional, default = false)
4 arg = test mode. if set to true - no changes in DB (optional, default = false)

close forum
make Data Base backup
upload file to forum root and execute in browser
confirm chages in DB
delete file
open forum

[masterross]

A little update of the script on vb 4.2.x:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

In this way it will exclude vb_language as it should stay in MyISAM.


Aldo this script should be run in AdminCP, not the root!
And if you have some big tables you should manually convert them trough shell console and after that run the script.


Regards!