Hi Leo,
Also include the EXPLAIN SELECT ...; output, and the SHOW CREATE TABLE table\G
for each table used in the query.
Have you considered that your query's execution time depends on other activity
on the server? Have you tried skipping the cache ( SELECT SQL_NO_CACHE ... )
and see if you
In the last episode (Aug 13), Leo Siefert said:
> After playing around with the query in PhpMyAdmin I am totally perplexed
> as to what could be causing the problem. Sometimes the query will execute
> in less than 30 seconds, but other times it takes from 4 to 10 or more
> minutes. It never seem
I have a moderate sized database set up and a program that allows users to
create ad-hoc queries into the data based on entries in a form, so that I, as
the programmer, have control over the actual construction of the queries and
can do what is needed to optimize queries. I also keep a log of al
Been there, done that - over and over. It is one of the FAQs:
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html
>-Original Message-
>From: Noah Garrett Wallach [mailto:no...@yahoo-inc.com]
>Sent: Thursday, August 13, 2009 2:49 AM
>To: mysql@lists.mysql.com
>Subject: settin
Maybe this thread [0] is useful for you.
http://forums.mysql.com/read.php?10,70927,71012#msg-71012
On Thu, Aug 13, 2009 at 1:48 PM, Noah Garrett Wallach
wrote:
> Okay it appears my mysql database is simply screwed up.
>
> I am attempting to rebuild the root account and privileges and now I
> can
