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 <[email protected]> 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, > >
