Can any body give the solution to this problem

[S K Pradeep kumar]

Dear All,



Further to the discussion we had just now, please find the details below.



Website url: www.compliancepanel.com – currently up (moving to
www.globalcompliancepanel.com)

Hosted with: goDaddy on dedicated server

Server: 4GB RAM, 160GB HD, 2GB SWAP, 2.6GHz Quad core processor.

Applications: ofBiz 4.0 based website on a red hat fedora linux 8.0 platform


Database: MySQL 5.0

Size of database and application: 270MB. The size of database grows on an
average of 2MB/day.



*History:* The website was running smoothly for the past 9 months. This
application was developed by a consultant who is working for another
Bangalore based company in part time.


*Problem:* The website will be down within 10 to 40 minutes after starting
the application. The moment the website is down, the database table that is
being accessed at that time is deleted or truncated or corrupted. Even if we
turn off the server hit updates, the MySQL system tables will be corrupted.
We understand that it is utilizing more cpu time (150% sometimes).

* *

*Steps taken: *

reprovisioning the server several times.

Re-installing all applications.

Code: identifying loops in the code and changing it using list methods,
Upgrading MySQL connector and DBCP, Removing all deprecated methods and
resolving the jar conflicts

Tests conducted: stress test using Wapt tool. Gradually increasing 20
virtual users every 10 minutes. The number of hits increased upto 70,000 in
10 hours. The application has behaved well.



*Expectations:*

Resolving the current problem and make the existing application very healthy

Enhancement – currently the application is only 15% of the whole application
perceived.



Kindly let us know if this can be taken up and if so let us know the quote
for the same.



Look forward for your support and co-operation.

With regards,
S K Pradeep kumar,

[Shi Jinghai]

Sounds like a file system problem. MySQL doesn't have any disk
management, it's a database on OS/FS.

在 2010-03-02二的 12:51 +0530，S K Pradeep kumar写道：

> Dear All,
>
>
>
> Further to the discussion we had just now, please find the details below.
>
>
>
> Website url: www.compliancepanel.com – currently up (moving to
> www.globalcompliancepanel.com)
>
> Hosted with: goDaddy on dedicated server
>
> Server: 4GB RAM, 160GB HD, 2GB SWAP, 2.6GHz Quad core processor.
>
> Applications: ofBiz 4.0 based website on a red hat fedora linux 8.0 platform
>
>
> Database: MySQL 5.0
>
> Size of database and application: 270MB. The size of database grows on an
> average of 2MB/day.
>
>
>
> *History:* The website was running smoothly for the past 9 months. This
> application was developed by a consultant who is working for another
> Bangalore based company in part time.
>
>
> *Problem:* The website will be down within 10 to 40 minutes after starting
> the application. The moment the website is down, the database table that is
> being accessed at that time is deleted or truncated or corrupted. Even if we
> turn off the server hit updates, the MySQL system tables will be corrupted.
> We understand that it is utilizing more cpu time (150% sometimes).
>
> * *
>
> *Steps taken: *
>
> reprovisioning the server several times.
>
> Re-installing all applications.
>
> Code: identifying loops in the code and changing it using list methods,
> Upgrading MySQL connector and DBCP, Removing all deprecated methods and
> resolving the jar conflicts
>
> Tests conducted: stress test using Wapt tool. Gradually increasing 20
> virtual users every 10 minutes. The number of hits increased upto 70,000 in
> 10 hours. The application has behaved well.
>
>
>
> *Expectations:*
>
> Resolving the current problem and make the existing application very healthy
>
> Enhancement – currently the application is only 15% of the whole application
> perceived.
>
>
>
> Kindly let us know if this can be taken up and if so let us know the quote
> for the same.
>
>
>
> Look forward for your support and co-operation.
>
> With regards,
> S K Pradeep kumar,

[S K Pradeep kumar]

Hi Shi Jinghai,

Can you please

With regards,
S K Pradeep kumar,

Hi Shi jinghai,

How can i resolve this, is there any setting changes i need to make.

With regards,
S K Pradeep kumar

On Tue, Mar 2, 2010 at 2:50 PM, Shi Jinghai <[hidden email]> wrote:

> Sounds like a file system problem. MySQL doesn't have any disk
> management, it's a database on OS/FS.
>
> 在 2010-03-02二的 12:51 +0530，S K Pradeep kumar写道：
> > Dear All,
> >
> >
> >
> > Further to the discussion we had just now, please find the details below.
> >
> >
> >
> > Website url: www.compliancepanel.com �C currently up (moving to
> > www.globalcompliancepanel.com)
> >
> > Hosted with: goDaddy on dedicated server
> >
> > Server: 4GB RAM, 160GB HD, 2GB SWAP, 2.6GHz Quad core processor.
> >
> > Applications: ofBiz 4.0 based website on a red hat fedora linux 8.0
> platform
> >
> >
> > Database: MySQL 5.0
> >
> > Size of database and application: 270MB. The size of database grows on an
> > average of 2MB/day.
> >
> >
> >
> > *History:* The website was running smoothly for the past 9 months. This
> > application was developed by a consultant who is working for another
> > Bangalore based company in part time.
> >
> >
> > *Problem:* The website will be down within 10 to 40 minutes after
> starting
> > the application. The moment the website is down, the database table that
> is
> > being accessed at that time is deleted or truncated or corrupted. Even if
> we
> > turn off the server hit updates, the MySQL system tables will be
> corrupted.
> > We understand that it is utilizing more cpu time (150% sometimes).
> >
> > * *
> >
> > *Steps taken: *
> >
> > reprovisioning the server several times.
> >
> > Re-installing all applications.
> >
> > Code: identifying loops in the code and changing it using list methods,
> > Upgrading MySQL connector and DBCP, Removing all deprecated methods and
> > resolving the jar conflicts
> >
> > Tests conducted: stress test using Wapt tool. Gradually increasing 20
> > virtual users every 10 minutes. The number of hits increased upto 70,000
> in
> > 10 hours. The application has behaved well.
> >
> >
> >
> > *Expectations:*
> >
> > Resolving the current problem and make the existing application very
> healthy
> >
> > Enhancement �C currently the application is only 15% of the whole
> application
> > perceived.
> >
> >
> >
> > Kindly let us know if this can be taken up and if so let us know the
> quote
> > for the same.
> >
> >
> >
> > Look forward for your support and co-operation.
> >
> > With regards,
> > S K Pradeep kumar,
>
>

[Shi Jinghai]

I guess there are bad sectors in the hard disk. Run
smartctl -l error yourharddisk
or
smartctl -H yourharddisk
to see whether there's any problem.

Good luck,

在 2010-03-02二的 15:05 +0530，S K Pradeep kumar写道：

> Hi Shi Jinghai,
>
> Can you please
>
> With regards,
> S K Pradeep kumar,
>
> Hi Shi jinghai,
>
> How can i resolve this, is there any setting changes i need to make.
>
> With regards,
> S K Pradeep kumar
>
> On Tue, Mar 2, 2010 at 2:50 PM, Shi Jinghai <[hidden email]> wrote:
>         Sounds like a file system problem. MySQL doesn't have any disk
>         management, it's a database on OS/FS.
>        
>         在 2010-03-02二的 12:51 +0530，S K Pradeep kumar写道：
>        
>         > Dear All,
>         >
>         >
>         >
>         > Further to the discussion we had just now, please find the
>         details below.
>         >
>         >
>         >
>         > Website url: www.compliancepanel.com C currently up (moving
>         to
>         > www.globalcompliancepanel.com)
>         >
>         > Hosted with: goDaddy on dedicated server
>         >
>         > Server: 4GB RAM, 160GB HD, 2GB SWAP, 2.6GHz Quad core
>         processor.
>         >
>         > Applications: ofBiz 4.0 based website on a red hat fedora
>         linux 8.0 platform
>         >
>         >
>         > Database: MySQL 5.0
>         >
>         > Size of database and application: 270MB. The size of
>         database grows on an
>         > average of 2MB/day.
>         >
>         >
>         >
>         > *History:* The website was running smoothly for the past 9
>         months. This
>         > application was developed by a consultant who is working for
>         another
>         > Bangalore based company in part time.
>         >
>         >
>         > *Problem:* The website will be down within 10 to 40 minutes
>         after starting
>         > the application. The moment the website is down, the
>         database table that is
>         > being accessed at that time is deleted or truncated or
>         corrupted. Even if we
>         > turn off the server hit updates, the MySQL system tables
>         will be corrupted.
>         > We understand that it is utilizing more cpu time (150%
>         sometimes).
>         >
>         > * *
>         >
>         > *Steps taken: *
>         >
>         > reprovisioning the server several times.
>         >
>         > Re-installing all applications.
>         >
>         > Code: identifying loops in the code and changing it using
>         list methods,
>         > Upgrading MySQL connector and DBCP, Removing all deprecated
>         methods and
>         > resolving the jar conflicts
>         >
>         > Tests conducted: stress test using Wapt tool. Gradually
>         increasing 20
>         > virtual users every 10 minutes. The number of hits increased
>         upto 70,000 in
>         > 10 hours. The application has behaved well.
>         >
>         >
>         >
>         > *Expectations:*
>         >
>         > Resolving the current problem and make the existing
>         application very healthy
>         >
>         > Enhancement C currently the application is only 15% of the
>         whole application
>         > perceived.
>         >
>         >
>         >
>         > Kindly let us know if this can be taken up and if so let us
>         know the quote
>         > for the same.
>         >
>         >
>         >
>         > Look forward for your support and co-operation.
>         >
>         > With regards,
>         > S K Pradeep kumar,
>        
>        
>