oper to make a bug report?
- how can we find the problem on the server? there's the option to log
every sql statement which might show up the error, but because this would
slow down the server immensely we don't want to do this right now.
claus
--
MySQL General Mailing List
For list arc
vers\etc\hosts.
>Submitter-Id: ?
>Originator:Claus Olesen
>Organization: Transdyn Controls, Inc.
>MySQL support: none
>Synopsis: Cannot connect after upgrading to mysql-4.0.8
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
&g
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
to use index.
Has anyone of you seen this behavious before?
/Claus
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
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