Database error: cannot use database pollo
MySQL Error: 2014 (Commands out of sync; You can't run this command now)
Session halted.
Why?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Just added more indexes and found a good one.
thanx for the advise ! =)
/C
- Original Message -
From: "Claus Reestrup" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 29, 2002 2:28 PM
Subject: Wont use Index when data is not evenly distributed
Cant figure out why MySQL wont use index on a big table.
Ok, the data is not evenly distributed which might be the problem.
Look here:
I have a table with 1 million records, with the following fields:
IdUser, int
X, int
Y, int
Z, int
C, char(10)
no, varchars, text, or blobs.
IdUser is a user id
Hi.
I have a perl script that uses many temporary tables (HEAP mostly) and when running
the script many times in parallel some of the script instances fail.
The query uses temporary tables and recently I discovered that some
of the queries uses filesort (disk access) due to GROUP BY
making the res
have a strange definition of "hang".
>
> Claus Reestrup wrote:
>
> >Hi!
> >
> >I have a problem with MySQL that hangs when concurrent queries run.
> >
> >The symptom is this:
> >A) A Perl program that performs several queries using temporary tables t
Hi!
I have a problem with MySQL that hangs when concurrent queries run.
The symptom is this:
A) A Perl program that performs several queries using temporary tables takes 8 seconds
to run.
CPU utilisation around 30% (using the 'top' command)
B) Running two instances of the same perl program in p
Hi everyone!
I'm fairly familiar with the table locking methods in MySQL but I have a
problem I can't solve.
I have two main tables which are read simultaneously by many clients. The
clients only do reads, but they do it very extensively and for 30 secs each.
The two main tables needs updates e