Re: Max connections being used every 10-12 day.

: Max connections being used every 10-12 day. 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

Re: Max connections being used every 10-12 day.

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

Re: Max connections being used every 10-12 day.

mysql describe art; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | parent

RE: Max connections being used every 10-12 day.

) 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 day. mysql describe art

RE: Max connections being used every 10-12 day.

, 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 absolutely worthless

RE: Max connections being used every 10-12 day.

. 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 used every 10-12 day

Re: Max connections being used every 10-12 day.

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;

Re: Max connections being used every 10-12 day.

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

Re: Max connections being used every 10-12 day.

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

RE: Max connections being used every 10-12 day.

[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 :), thanks The slow query log don't show that many slow

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 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

RE: Max connections being used every 10-12 day.

: 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 inner join seems to use more cpu

Max connections being used every 10-12 day.

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

RE: Max connections being used every 10-12 day.

- 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, Every 8-12 day my mysql server stops responding and i get

Re: Max connections being used every 10-12 day.

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

RE: Max connections being used every 10-12 day.

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 connections being used every 10-12