From: Nicolas <ni...@sh...> - 2012-03-23 14:30:02
|
Hi, When I refresh a Full Job (working with a base job), on BAT, the application doesn't respond. The CPU of DIR server is at 100% on mysql. While rebooting mysql service, problem disapears, and I've got the error on BAT : SELECT DISTINCT MEDIATYPE FROM MEDIATYPE ORDER BY MEDIATYPE I think this request have some problems to be resolve, and take all CPU for mysql. Any idea to correct ? -- Nicolas http://www.shivaserv.fr [1] Links: ------ [1] http://www.shivaserv.fr |
From: John D. <dre...@gm...> - 2012-03-23 15:15:23
|
2012/3/23 Nicolas <ni...@sh...>: > Hi, > > When I refresh a Full Job (working with a base job), on BAT, the application > doesn't respond. The CPU of DIR server is at 100% on mysql. > > While rebooting mysql service, problem disapears, and I've got the error on > BAT : > > Select Distinct MediaType From MediaType order by mediatype > > > > I think this request have some problems to be resolve, and take all CPU for > mysql. > > > > Any idea to correct ? > I am not sure that is a real error. It looks like it is printing the query used.. John |