You will need to turn on query logging for you DB. I think you just define a file to log to in the my.cnf file. I am not very familiar with MySQL since we use PostgreSQL as our backend here. Check the MySQL documentation.
Cheers, Ken On Tue, Jul 06, 2010 at 03:21:05PM +0200, Horst Kriegers wrote: > Hi Kenn, > thanks for your answer. > > How can I see the QueryBuilder's executed query ? > > Regards, > Horst > > > >>> Le Mardi, 6. Juillet 2010 ?? 14:57, Kenneth Marshall <[email protected]> > a ??crit : > Hi Horst, > > Is the query hitting the DB the same with the CLI versus > QueryBuilder? Maybe you are hitting a resource limit when > the request goes through the web server. Try checking the > system and web server logs to see if there is any more > information. If it is not generating the same query, then > that will give you a place to look for a problem. Good > luck. At least, there is a good consulting group available > should you need some expert assistance. > > Regards, > Ken > > On Mon, Jul 05, 2010 at 11:20:42AM +0200, Horst Kriegers wrote: > > I've tried in CLI mode and have no problem. > > The execution of request is quick. > > > > Horst > > > > >>> Le Lundi, 5. Juillet 2010 ?? 08:58, "Horst Kriegers" > > <[email protected]> a ??crit : > > Hi and tanks Kenn for your answer. > > > > > > RT_Config : Identical (not modified) > > > > RT_SiteConfig - Differences are minimal : > > - $rtname > > - $DatabasePort > > - $DatabaseUser > > - $DatabaseName > > - $ParseNewMessageForTicketCcs > > - $LogToFileNamed > > - $WebPort > > > > And log files contains nothings special > > > > > > This behavior seem to appear by inserting Custom Fields in the > query. > > > > > > > > Any idea where can I investigate to resolve this problem ? > > > > > > Horst > > > > >>> Le Mercredi, 30. Juin 2010 ?? 16:53, Kenneth Crocker > > <[email protected]> a ??crit : > > Horst, > > > > What are the differences in you RT_Config and RT_SiteConfig.pm > files? > > > > Kenn > > LBNL > > > > On Wed, Jun 30, 2010 at 7:32 AM, Horst Kriegers > > <[email protected]> wrote: > > > > > > Hi, > > Suze Linux 2.6.16 > > RT 3.6.6 > > Apache 2.2.6 > > MySQL 5.1.45 > > We have 2 instances of RT: > > - DEV for development > > - PRD for production > > A query created in RT's Query Builder on the DEV environment works > > fine. > > By creating the same query on the PRD environment froze until > timeout > > appear. > > I've tried to connect the RT DEV to MySQL PRD, all works fine. > > I've tried to connect the RT PRD to MySQL DEV, it froze. > > I've tried to compare the both RT's directory content, all seems to > be > > identical. > > How can I solve this probl??m ? > > Many thanks in advance. > > Horst > > > > > > > _______________________________________________________________________ > > > > Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou > > l'organisme ?? qui il est destin??. Si vous n'??tes pas le > destinataire > > pr??vu, veuillez nous en informer au plus vite et d??truire le > pr??sent > > courriel. Dans ce cas, il ne vous est pas permis de copier ce > courriel, > > de le distribuer ou de l'utiliser de quelque mani??re que ce soit. > > > _______________________________________________________________________ > > > > The content of this e-mail is intended only and solely for the use > of > > the named recipient or organisation. If you are not the named > recipient, > > please inform us immediately and delete the present e-mail. In this > > case, you are nor allowed to copy, distribute or use this e-mail in > any > > way. > > > _______________________________________________________________________ > > > > > > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > > Buy a copy at http://rtbook.bestpractical.com > > > > > > > > > > > _______________________________________________________________________ > > > > Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou > > l'organisme ?? qui il est destin??. Si vous n'??tes pas le > destinataire > > pr??vu, veuillez nous en informer au plus vite et d??truire le > pr??sent > > courriel. Dans ce cas, il ne vous est pas permis de copier ce > courriel, > > de le distribuer ou de l'utiliser de quelque mani??re que ce soit. > > > _______________________________________________________________________ > > > > The content of this e-mail is intended only and solely for the use > of > > the named recipient or organisation. If you are not the named > recipient, > > please inform us immediately and delete the present e-mail. In this > > case, you are nor allowed to copy, distribute or use this e-mail in > any > > way. > > > _______________________________________________________________________ > > > > > > ___________________________________________________________ > > Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou > > > l'organisme ?? qui il est destin??. Si vous n'??tes pas le > destinataire > > pr??vu, veuillez nous en informer au plus vite et d??truire le > pr??sent > > courriel. Dans ce cas, il ne vous est pas permis de copier ce > courriel, > > de le distribuer ou de l'utiliser de quelque mani??re que ce soit. > > > > The content of this e-mail is intended only and solely for the use > > of the named recipient or organisation. If you are not the named > > recipient, please inform us immediately and delete the present > e-mail. > > In this case, you are nor allowed to copy, distribute or use this > > e-mail in any way. > > ___________________________________________________________ > > > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > > Buy a copy at http://rtbook.bestpractical.com > > ___________________________________________________________ > Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou > l'organisme ?? qui il est destin??. Si vous n'??tes pas le destinataire > pr??vu, veuillez nous en informer au plus vite et d??truire le pr??sent > courriel. Dans ce cas, il ne vous est pas permis de copier ce courriel, > de le distribuer ou de l'utiliser de quelque mani??re que ce soit. > > The content of this e-mail is intended only and solely for the use > of the named recipient or organisation. If you are not the named > recipient, please inform us immediately and delete the present e-mail. > In this case, you are nor allowed to copy, distribute or use this > e-mail in any way. > ___________________________________________________________ > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
