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, |
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, |
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, > > |
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, > > > |
Free forum by Nabble | Edit this page |