Hi,
My original query was a UNION query :) and that one is really fast.
The problem i had was that every 8-12 day mysql sad that all of my
max_connections was in use. I think i will stick with my UNION query it
seems faster.
// Fredrik.
Bill Easton wrote:
Fredrik,
I haven't read all of th
ED]>
To: Donny Simonton <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: Max connections being used every 10-12 day.
I really appreciate your help :)
I did some cleanup of my indexes(there are a c
I really appreciate your help :)
I did some cleanup of my indexes(there are a couple of them left to
clean out but it takes so long time):
mysql> show index from
art;
+++--
x. This
is covered by 1st_2 or 1st_3.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Tom Crimmins
Sent: Monday, January 03, 2005 2:49 PM
To: Donny Simonton; 'Fredrik Carlsson'
Cc: mysql@lists.mysql.com
Subject: RE: Max connections being
onday, January 03, 2005 1:12 PM
To: 'Fredrik Carlsson'
Cc: mysql@lists.mysql.com
Subject: RE: Max connections being used every 10-12 day.
Frederik,
I may be losing my mind, but I don't think I am according to your show
index, you have multiple indexes on the same fields which is abso
g (id)
where A.id=60 or B.parent=60
order by A.date
Donny
> -Original Message-
> From: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 03, 2005 11:08 AM
> To: Donny Simonton
> Cc: mysql@lists.mysql.com
> Subject: Re: Max connections being used every 10-12 da
mysql> describe art;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| id | int(11) | | PRI | NULL| auto_increment |
| parent
; From: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 02, 2005 4:45 PM
> To: mysql@lists.mysql.com
> Subject: Re: Max connections being used every 10-12 day.
>
> The inner join statement returned the same stuff but it was not as fast
> as the union is and the inne
The inner join statement returned the same stuff but it was not as fast
as the union is and the inner join seems to use more cpu resources.
Could these union queries really be the problem behind my occasional
lock ups and that 200 connections being used? i mean the server is not
that loaded and
rom: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 02, 2005 5:18 AM
> To: Donny Simonton
> Cc: mysql@lists.mysql.com
> Subject: Re: Max connections being used every 10-12 day.
>
> It is a single PIII 500MHz, so i just changed thread_concurrency to 2
> :), than
Fredrik Carlsson wrote:
It is a single PIII 500MHz, so i just changed thread_concurrency to 2
:), thanks
The slow query log don't show that many slow queries, but they did
show alot of queries that was'nt using any index, can these queries
cause some kind of occasional lock up?
Is there a fas
It is a single PIII 500MHz, so i just changed thread_concurrency to 2
:), thanks
The slow query log don't show that many slow queries, but they did show
alot of queries that was'nt using any index, can these queries cause
some kind of occasional lock up?
Is there a faster way to perform this
e awful queries or you have some tables that are
getting corrupted and are being repaired during that time.
Donny
> -Original Message-
> From: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 01, 2005 4:37 AM
> To: mysql@lists.mysql.com
> Subject: Max c
mysql has about 50GB of temp space to work with so thats not the problem.
Its strange because the server is not that loaded and around 12-04 at
night no cronjobs that affects mysql or general server performance are
being run.
Is is possible to se how many queued up questions mysql has at the mom
age-
> From: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: 01 January 2005 10:37
> To: mysql@lists.mysql.com
> Subject: Max connections being used every 10-12 day.
>
>
> Hi list,
>
> I have a rather serious problem that i really dont know how to solve,
>
>
Hi list,
I have a rather serious problem that i really dont know how to solve,
Every 8-12 day my mysql server stops responding and i get the error code
that indicates that max_connections are full, the problem is that i have
checked all of
my code over and over again to se that every connections
16 matches
Mail list logo
