It's getting faster now, but still pretty slow in accepting finished tasks.
I think it is caused by that huge 'ibdata' file, which was a bottleneck for it. --- On Fri, 10/23/09, yoyo <[email protected]> wrote: > From: yoyo <[email protected]> > Subject: Re: [boinc_dev] Too many connections for the project ? > To: "Kunsheng Chen" <[email protected]> > Cc: "BOINC_dev" <[email protected]> > Date: Friday, October 23, 2009, 7:33 PM > Seems that your mysql is to slow to > handle all requests. > So how many user/hosts are attached to your project? > How long does a WU run? > How many wu/results do you have in your DB? > > You should switch on mysql slow statement logging and look > which requests are lasting long and tune there. > Maybe you must create some index or shrink your database. > > Where are your database fieles stored and how much RAM does > the system has? > > yoyo > Kunsheng Chen schrieb: > > My project reminds me "too many connections" in the > site, I think it is Mysql related again. A restart didn't > work... But the server is still working in a slow > manner anyway. > > > > > > > ----------------------------------------------------------- > > Database/file status > > > > Warning: mysql_pconnect() [function.mysql-pconnect]: > Too many connections in /****/db.inc on line 23 > > The database server is not accessible > > > ------------------------------------------------------------- > > > > > > Any idea ? > > > > > > Thanks, > > -Kun > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around http://mail.yahoo.com > _______________________________________________ > > boinc_dev mailing list > > [email protected] > > http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev > > To unsubscribe, visit the above URL and > > (near bottom of page) enter your email address. > > > > > > _______________________________________________ boinc_dev mailing list [email protected] http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev To unsubscribe, visit the above URL and (near bottom of page) enter your email address.
