[geevest.com]

im realy tired about this for 3months.my issue never fixed
my host support say :

Hello again,


Thank you for verifying.


Your my.cnf file, which controls a lot of optimization settings for MySQL,
seems to match all but one of our recommended settings, for your type of
hardware. Originally, one of our monitoring techs lowered your max_connections
from 1500 to 500, but I've just noticed that wait_timeout is 28800 rather than
the suggested 30. You're welcome to have any settings you'd like, but this
difference will keep a lot of MySQL connections open if VB isn't coded to
close connections once it's finished with it's query.


I found that some of your forum tables are damaged which can cause extra
resources needed by MySQL to process the request. I'd like to stop MySQL, back
up the DB, and run a repair. The process shouldn't take more than 20 minutes.
When would be a good time to do this?


Aside from these minor corrections, I'm seeing no reasons why the server would
be responsible for the high load you're experiencing. In the midst of typing
this response, several php procs for user 'zhazha' were spawned from
/home/zhazha/public_html/forum/showtread.php and forumdisplay.php. After
killing the procs, your load went from 23 down to 4.15.


A majority of your HTTP connections are from Indonesian IPs, but none of them
have an odd number of connections. This leads me to believe your current
hardware and/or VBulletin isn't capable of handling your load demands. Because
I don't believe the above mentioned fixes won't make a large difference, you
may want to consider adding more memory, at the very least. Thanks!

Hello again,


I'm afraid that's something I can't promise. The problem is that your server
isn't handling the load very well, the load is either from the number of
connections, VB not handling so many requests at once, or a combination of the
two. It's possible you may need a better hardware upgrade if you want to
continue to handle this amount of traffic, or adding another GB or two may be
all you need. I'd recommend addressing my earlier suggestions before making
any hardware-related changes, however.

Thanks!

i take dedicated server for this.
so until now my issue never fixed.what should i do for this friend?
i really need ur help for this.
well thank you very much,i hope my problem solved in here.