Vb 4.1.5 high load , please help

[TechPro]

I upgraded my vb yesterday and everything has started to show the following (mySQL processes):

copying to tmp table
and
waiting for table meta lock

I would really appreciate some help

The load rises very quickly to 30s and then the 80s.

If I block others to view the board, it is quite normal on load (1 or 2). As soon as I open it for public within a second the peak goes up.

It is a spanish board with less members, still the problem.

TechPro Reviewed by TechPro on 23rd Sep 2011. Vb 4.1.5 high load , please help I upgraded my vb yesterday and everything has started to show the following (mySQL processes): copying to tmp table and waiting for table meta lock I would really appreciate some help :) The load rises very quickly to 30s and then the 80s. Rating: 5

[DOPE]

Do you have vBOptimize installed?

[TechPro]

Could you please link me to it?

I have disabled all my hooks still the post table is in the copying to tmp table state.

[TechPro]

Copying to tmp table | SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
thread.postusername, thread.da |
| 41 | wf_887 | localhost | wf_887 | Query | 651 | Copying to tmp table

this is a part of the mysql processes

[TechPro]

any help please?

[NewEraCracker]

Which is your MySQL version?

Also I am not familiar with vB but I think you'd have to rebuild posts before opening board to public after upgrading (don't ask me how. wait for replies)

Also can you post here the output of this script when ran in your server?

https://raw.github.com/NewEraCracker/php_work/master/check_compatibility.php

[my123world]

Need Some Help Regarding This.. I Can Do Some Optimization.