t;<<<<<<<<<<<
On 3/2/04, 3:05:39 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding Re:
no one can log on any more:
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Bernd Jagla" <[EMAIL PROTECTED]>
> Cc: "
Bernd Jagla wrote:
Hi there,
I have some weird sql statements that seem to eat up all resources from mysqld.
Once I have two of them running at the same time no one can log on any more. Simple
queries involving distinct get a out of memory error.
We have tried changing the index buffer size from
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Bernd Jagla" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 02, 2004 3:43 PM
Subject: Re: no one can log on any more
Are you sure you allotted 512MB for both read_buff
t;<<<<<<<<<<<<<<<<
>
> On 3/2/04, 2:26:31 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding Re:
> no one can log on any more:
Snipped a VERY long message --
Please don't overquote like this when replying.
--
Martijn Tonies
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t;<<<<<<<<<<<
On 3/2/04, 2:26:31 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding Re:
no one can log on any more:
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Bernd Jagla" <[EMAIL PROTECTED]>
> Cc: "
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Bernd Jagla" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 02, 2004 3:14 PM
Subject: Re: no one can log on any more
The database server becomes unresponsive to
gt;> Original Message <<<<<<<<<<<<<<<<<<
On 3/2/04, 2:04:37 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding Re:
no one can log on any more:
> The system is working fine.
> There is no error message when logging on from the co
to the mysql
server already.
B
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Bernd Jagla" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 02, 2004 2:51 PM
Subject: Re: no one can log on any more
What error message, if
t;<<<<<<<<<<<<<
On 3/2/04, 1:37:34 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding Re:
no one can log on any more:
> table: text_data
> type: ALL
> possible_keys: NULL
> key: NULL
> key_len: NULL
> ref: NULL
> rows 1338
ot;mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 02, 2004 2:34 PM
Subject: Re: no one can log on any more
Can you post the explain plan? I would be interested to see if temp table
tables are being created or if the system is swapping or if the the temp
tables are so large that
nal Message <<<<<<<<<<<<<<<<<<
On 3/2/04, 12:35:20 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding Re:
no one can log on any more:
> There are no indices on the new table.
> Top looks normal: approx 100-150% usage (out of 800
solve this one?
Bernd
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Bernd Jagla" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 02, 2004 1:17 PM
Subject: Re: no one can log on any more
When the queries in questio
gt; Original Message <<<<<<<<<<<<<<<<<<
On 3/2/04, 12:08:05 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding Re:
no one can log on any more:
> An explain on the select statements reveals that no index is used and
that
>
ED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 02, 2004 1:02 PM
Subject: Re: no one can log on any more
What does the explain plan reveal?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<&
What does the explain plan reveal?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/2/04, 9:05:17 AM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding no
one can log on a
Hi there,
I have some weird sql statements that seem to eat up all resources from mysqld.
Once I have two of them running at the same time no one can log on any more. Simple
queries involving distinct get a out of memory error.
We have tried changing the index buffer size from 256M to 2G, no
16 matches
Mail list logo