Hi,
I've noticed that connections are sometimes left open in MySQL when i use
the Show Processlist command. Does MySQL do any form of housekeeping to
close old connections or is it just down to the developers to make sure they
issue close connection statements?
Thanks.
==
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 10 August 2005 09:07
To: mysql@lists.mysql.com
Subject: Re: Cleanup of connections
Hi,
They appear to be in SLEEP state
Hello.
What state do MySQL threads of your old connections have?
Ben Smith <[EM
ected. If you want to debug this issue, please, provide information
about your operating system and MySQL version. If your
developers connect to MySQL through TCP/IP, check with netstat the state of
connections to MySQL port (usually 3306).
Ben Smith <[EMAIL PROTECTED]> wrote:
> They a
Can I just ask a quick question about this one, mainly about the Group By
statement and how its used in MySQL. It appears that you don't need to
specify in the Group By clause all the columns that are referenced without
an aggregate function i.e vendor is missed out from: GROUP BY p3.id,
p3.price.
om: Scott Noyes [mailto:[EMAIL PROTECTED]
Sent: 11 August 2005 15:39
To: Ben Smith
Cc: mysql@lists.mysql.com
Subject: Re: HELP! sql command question for mysql
> It appears that you don't need to
> specify in the Group By clause all the columns that are referenced
> without an agg
Hello all,
We have 3 instances on the same server, prod, test and dev. Is it possible
to increase the max_connection limit just for one instance, or would
changing the limit effect all 3 ?
Many thanks
** For great Emap magazine subscription & gift offers visit
http://www.emapmagazines.co.uk
Try this instead:
SELECT pubishers.pub_id, titles.pub_ID FROM pubishers JOIN titles ON
pubishers.pub_id = titles.pub_id
HTH.
** For great Emap magazine subscription & gift offers visit
http://www.emapmagazines.co.uk **
MAX() Query
Hello,
I'm trying to write 2 queries, the first to find the most recent club a
player has played for, and then the previous club they played for.
To find the most recent club i use this :
substring(max(concat(STARTDATE,TEAM)),11,100) as TEAM
which concats a players start date to th
Hello,
We are looking to replicate a couple of databases on to a second server.
Having looked through the manual it says we need to add various commands to
my.cnf.
It turns out that we do not have a my.cnf (so apprently MySQL just
defaults), so can we just create this file with the replication c
'mass' inserted once the query
has finished, rather than one row being inserted at a time ?
Thanks
Ben Smith.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
Hi,
This is my first posting, although i've been signed up to the list for a
while.
My problem is this.
Table A (5000 rows)
ID, NAME, SCORE
Table B (1000 rows)
ID, NAME, SCORE
I want all records from Table A and those from Table B where they match, for
this i'm using a right join. However, t
from a SQL Server background, and was a
little dubious of MySQL. However, since becoming more familiar with it, I
have come to love it. Its extremely fast and reliable, and i can fully
understand why its so popular.
Ben Smith
www.exxus.co.uk
- Original Message -
From: "Mike Ro
Hello,
I have this query
select a.match_id, count(a.players_id) as num, a.description
from a
group by a.players_id, a.match_id
order by num desc
I only want to see the records where the count of players_id is greater than
1, and in various other DB's i'd use the Having clause, so i tried
where
13 matches
Mail list logo
