On Tue, Dec 17, 2013 at 02:53:53PM -0500, Adam Hobaugh wrote:
I just updated from 4.0.10 to 4.2.1 and it seems to be working well
except when I am in a ticket, any page that shows a user drop down,
ie display and people load incredible slowly. I enabled slow query
logging and below are the two
On 12/18/2013 11:43 AM, Kevin Falcone wrote:
On Tue, Dec 17, 2013 at 02:53:53PM -0500, Adam Hobaugh wrote:
I just updated from 4.0.10 to 4.2.1 and it seems to be working well
except when I am in a ticket, any page that shows a user drop down,
ie display and people load incredible slowly. I
On Wed, Dec 18, 2013 at 12:29:05PM -0500, Adam Hobaugh wrote:
The slow query logs are most helpful when you then run EXPLAIN on the
query so you know why the database is having trouble.
Here is the EXPLAIN for the two queries.
mysql EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN
On 18 December 2013 10:07, Kevin Falcone falc...@bestpractical.com wrote:
Can you download and run http://mysqltuner.pl on your database.
Fun tip. You can download that with just “wget mysqltuner.pl”. There’s
some redirection magic that makes it work with just that command.
--
Landon
On 12/18/2013 01:07 PM, Kevin Falcone wrote:
Your query here says that MySQL is looking at a pretty tiny dataset
and running the same query on multiple databases here shows a wildly
different explain and very quick results. This usually points to you
having some enormous tables (although the
On Wed, Dec 18, 2013 at 02:15:06PM -0500, Adam Hobaugh wrote:
On 12/18/2013 01:07 PM, Kevin Falcone wrote:
Your query here says that MySQL is looking at a pretty tiny dataset
and running the same query on multiple databases here shows a wildly
different explain and very quick results. This
On 17 December 2013 11:53, Adam Hobaugh a...@cs.pitt.edu wrote:
Hello,
I just updated from 4.0.10 to 4.2.1 and it seems to be working well except
when I am in a ticket, any page that shows a user drop down, ie display and
people load incredible slowly. I enabled slow query logging and below
On 17 December 2013 13:19, Adam Hobaugh a...@cs.pitt.edu wrote:
Hi Adam,
I’m not sure if this applies but we had this issue and it was an RT ACL
issue. I remember that it was an issue with granting or not-granting
rights to special groups Everyone or “Unprivileged” but the details of
On 17 December 2013 13:19, Adam Hobaugh a...@cs.pitt.edu wrote:
Hi Adam,
I’m not sure if this applies but we had this issue and it was an RT ACL
issue. I remember that it was an issue with granting or not-granting
rights to special groups Everyone or “Unprivileged” but the details of