database error many messages,needed help. (realy need help)

[Dismounted]

Again - run the top command and post the result.

[geevest.com]

okay here the result :

top - 12:48:37 up 3 days, 24 min, 2 users, load average: 20.79, 22.28, 20.00
Tasks: 357 total, 8 running, 336 sleeping, 0 stopped, 13 zombie Cpu(s): 78.1%
us, 14.7% sy, 0.0% ni, 7.1% id, 0.0% wa, 0.2% hi, 0.0% si Mem: 2073872k total,
1492364k used, 581508k free, 55936k buffers Swap: 2040244k total, 208k used,
2040036k free, 893324k cached

 PID USER      PR  NI %CPU    TIME+  %MEM  VIRT  RES  SHR S COMMAND
25011 zhazha    17   0   14   0:00.44  0.0     0    0    0 Z php <defunct>
25010 zhazha    20   0   14   0:00.43  0.0     0    0    0 Z php <defunct>
25016 zhazha    20   0   13   0:00.39  0.0     0    0    0 Z php <defunct>
25012 zhazha    21   0   12   0:00.38  0.0     0    0    0 Z php <defunct>
25017 zhazha    19   0   12   0:00.38  0.0     0    0    0 Z php <defunct>
25020 zhazha    21   0   12   0:00.38  0.0     0    0    0 Z php <defunct>
25024 zhazha    21   0   11   0:00.34  0.7 25536  13m 5244 R php
25018 zhazha    18   0   10   0:00.32  0.0     0    0    0 Z php <defunct>
10100 mysql     15   0    8 150:26.57  6.1  329m 124m 4288 S mysqld
25025 zhazha    20   0    8   0:00.25  0.6 26156  13m 5120 R php
25027 zhazha    19   0    7   0:00.22  0.6 25892  12m 5160 R php
25028 zhazha    19   0    7   0:00.21  0.6 25784  12m 5108 R php
25030 zhazha    18   0    3   0:00.09  0.4 21780 9036 4652 R php
25029 zhazha    18   0    1   0:00.04  0.2 19888 4840 2896 R php
24903 root      16   0    1   0:00.28  0.1  3388 1216  780 R top
10658 root      17   0    1   5:36.59  0.1  3764 1284  780 S top
16150 nobody    15   0    1   0:00.37  0.2 11316 3936 1460 S httpd
11916 nobody    15   0    0   0:00.50  0.2 11328 3952 1452 S httpd
14076 nobody    16   0    0   0:00.52  0.2 11348 3980 1468 S httpd
17868 nobody    15   0    0   0:00.37  0.2 11348 3980 1464 S httpd
18104 nobody    15   0    0   0:00.34  0.2 11332 3972 1464 S httpd
18739 nobody    16   0    0   0:00.27  0.2 11332 3972 1460 S httpd
18853 nobody    15   0    0   0:00.30  0.2 11324 3976 1484 S httpd
19589 nobody    16   0    0   0:00.23  0.2 11348 3996 1464 S httpd
20153 nobody    15   0    0   0:00.19  0.2 11196 3884 1456 S httpd
20156 nobody    16   0    0   0:00.27  0.2 11188 3884 1460 S httpd
20461 nobody    16   0    0   0:00.18  0.2 11212 3952 1488 S httpd
22137 nobody    16   0    0   0:00.07  0.2 11188 3860 1444 S httpd
22987 nobody    16   0    0   0:00.12  0.2 11188 3892 1460 S httpd
23536 nobody    16   0    0   0:00.02  0.2 11188 3844 1436 S httpd
23595 nobody    16   0    0   0:00.06  0.2 11188 3868 1448 S httpd
23760 nobody    16   0    0   0:00.09  0.2 11176 3844 1440 S httpd
23852 nobody    15   0    0   0:00.05  0.2 11176 3856 1444 S httpd


as you can see this is an issue with the user (indeed your only user and
account it appears) zhazha, to much PHP use, before it was this AND too much
Mysql use, if you can have the makers of your forum software trouble shoot
that would be great, can you please let me know what they say?

--------------- Added [DATE]1214307185[/DATE] at [TIME]1214307185[/TIME] ---------------

my host support say :

Hi,


After reading through several tickets and other admin notes, the problems can
be summarized thusly:

1) The vbulletin software is a resource hog. The number of connections that it
is trying to handle and pass to the server is extremely large.

2) The memory usage required by php on the site is also using an overabundance
of memory.

3) we have tried to optimize the existing software configuration to the nth
degree all without success.

4) The hardware configuration of the server itself is inadequate for your
current needs.

To solve these problems I would recommend the following:

A: Upgrade the server to at least a 4 core processor or better yet, 8 cores
would be optimal. You currently have a single duo core processor.

B: Upgrade the ram to at least 4 Gigs, 8 Gigs would be better. You currently
have 2 Gigs.

C: Consider optimizing the php software you are using for the site itself. The
number of concurrent connections are causing 'out of memory' errors which
causes the failed or dropped mysql connections causing downtime for the site.

D: Consider changing the software you are using for the bulletin board. The
current problem is that the board is spawning over 1100
/usr/bin/php/home/zhazha/public_html/forum/showthread.php processes.

To put it simply, you are trying to toast 100 slices of bread on a 4 slice
toaster. The answer to this issue is you need a bigger toaster. This may be
oversimplifying the issue but it is accurate. This is my opinion, but the
final decision is yours to make. We can improve via upgrade or continue to see
the same issues reappear again and again. Please let me know how you would
like to proceed.

Let me also take this time to say thank you for your time and patience while
we try and resolve this issue. I know the frustration level is high, but there
is a solution to this if we continue to work together to find it.






Regards,
David Singer

Here is the my current plan :
DEDICATED SERVER.
Item: Webmaster Plan1
Processor: Pentium 4 3GHZ Hyperthreaded
Memory: 1GB DDR SDRAM
Hd1: 120GB 7200RPM SATA / 8MB Cache
Hd2: 120GB 7200RPM SATA / 8MB Cache
RemoteBackup: No Remote Backup Needed
OS: Linux - CentOS 4
ControlPanel: CPanel / Web Host Manager
(+ServerSecure)
(+Fantastico/XController)


You currently have a single duo core processor with 2 Gigs of ram.


but its not enough?
my uniq visitors / day just only 4k.
so i must upgrade my server or what sir?
thanks

[Dismounted]

To answer your host's comments:

1) vBulletin is NOT a resource hog. It only opens as many connections to the server as people visiting.
2) You still have ~500MB of free memory....
3-4) Your load average is high, very high in fact. So your processor would be dragging you down as well.

[geevest.com]

but now im already upgrade in to 4GB ram.

[SEOvB]

turn persistant connectons off in the config.php file if its on.

[geevest.com]

Originally Posted by FRDS

turn persistant connectons off in the config.php file if its on.

may i know about persistant connections its for what? thx

--------------- Added [DATE]1214413338[/DATE] at [TIME]1214413338[/TIME] ---------------

btw im already upgrade in to 4GB ram.but my issue never solved.
my host just say :

Hello again,


There's nothing further we can do for you, regarding your vbulletin issues. As
Ian and myself have stated before, we've optimized your server's services and
have reviewed it's overall setup several times. We've gone above and beyond
our realm of support trying to keep your server stable, but your server is
flooded by connections and the demands from VB bring it offline.


I apologize for the inconvenience this has caused you, but everything we
provide support for is working as expected. If the VB support staff isn't able
to provide an additional step for you, I'd recommend trying either new forum
software or reinstalling VB. I'm not trying to push you away from that
software, but our Support staff isn't trained on the ins and outs of VB, only
identifying what's causing an issue and how best to resolve it. We don't
provide support for 3rd party applications (i.e. anything outside of cPanel,
not directly related to the Operating System).


Please let me know if there's anything else I can help you with. Though we
can't resolve the VB problems, I can assure you that we're always here for
questions or problems with anything pertaining to cPanel.

i think the problem its because vbulletin.not my host.because im already upgrade in to 4GB ram.
and my issue always getting from vbulletin.

[y2ksw]

I was suggesting to copy the vBulletin database to a fresh install just to be sure there is no vbulletin issue. The server hardware seems ok to me, since the site is pretty fast under normal conditions. Now with 4 GB it is slightly better.

If a fresh copy fails, I suggest to move hosting and run a dedicated server under own regime. Of course, excellent computer knowledge is required

[legija]

Apache should be compiled with PHP, and PHP should not run as CGI. Thats why it eats so much resources.

As i can see, PHP runs as separate module here. I remember once my hoster did this to my server due to some obscure bug , and server was rendered unusable in just few visits.

[Dismounted]

Again, vBulletin is NOT a resource hog. It only opens as many connections to the server as people visiting.

Look at the output of top, you have too many PHP forks running - this is killing the server, not the amount of RAM, but the CPU power required.

[geevest.com]

Originally Posted by y2ksw

I was suggesting to copy the vBulletin database to a fresh install just to be sure there is no vbulletin issue. The server hardware seems ok to me, since the site is pretty fast under normal conditions. Now with 4 GB it is slightly better.

If a fresh copy fails, I suggest to move hosting and run a dedicated server under own regime. Of course, excellent computer knowledge is required

friend u mean i must backup the database forum and then create a new installation forum,
then upload my database in to a new forum. right?

and how about the plugin menu? thx

--------------- Added [DATE]1214486448[/DATE] at [TIME]1214486448[/TIME] ---------------

now my forum using vb.3.7.1 PL2.
its impossible if i create a new installation vb.3.7.2 and restore the database from vb.3.7.1 PL2 ?