no, the lsof list are incoming connections with
a high port on the other host, to nearly each
one ever connected from rsyslog multiple times
strange thing, this are only maillogs from rsyslog
the other machine logging all no-mail messages
the same way does not show this behavior
mysqld 905 2
And there are no outgoing connections from that host to another mysql server?
- Original Message -
> From: "Reindl Harald"
> To: mysql@lists.mysql.com
> Sent: Monday, 27 February, 2012 1:48:15 PM
> Subject: Re: file descriptor leak?
>
> it is simply not possible that there are 1926 or mo
it is simply not possible that there are 1926 or more
connections to mysqld open, limit in my.cnf is 500
and it does only affect mysqld
otal buffers: 4.6G global + 1.2M per thread (500 max threads)
Highest usage of available connections: 16% (82/500)
Maximum possible memory usage: 5.2G (60% of in
Well, it *did* close the gap by a couple of hundred connections :-)
I honestly have no idea what could cause this. I wouldn't immediately think of
a leak in MySQL as those are system tools that *should* check the same location
for their stats. Most peculiar.
I seem to remember you running mostl
lsof -n| grep '^mysqld' | grep ESTABLISHED | wc -l; netstat -n | grep mysql |
grep VERBUNDEN | wc -l
1926
18
Am 27.02.2012 13:32, schrieb Johan De Meersman:
> - Original Message -
>> From: "Reindl Harald"
>>
>> other machines (rsyslog configured for mysql)
>
> Hmm, that would mean a lo
- Original Message -
> From: "Reindl Harald"
>
> other machines (rsyslog configured for mysql)
Hmm, that would mean a lot of very brief connections, I guess. Coud you try
with my line? I don't expect it to vanish, but I think it should close the gap
a little.
>
> netstat | grep mysql
i have this only on one machine heavily used
as mail-storage and syslog-server for all
other machines (rsyslog configured for mysql)
netstat | grep mysql | wc -l
19
lsof | grep mysql | grep ESTABLISHED | wc -l
2247
Am 27.02.2012 13:08, schrieb Johan De Meersman:
> Interesting. I slightly reforma
Interesting. I slightly reformatted your commands for both speed and to
minimise the time between them:
(lsof -n| grep '^mysqld' | grep ESTABLISHED | wc -l) & (netstat -n | grep
3306 | grep ESTABLISHED | wc -l) & wait
I get the occasional couple of connections difference, but mostly it turns o
Am 27.02.2012 09:05, schrieb Pengkui Luo:
> Hi, I am new to mysql and have a question regarding how to read/import
> existing mysql databases (i.e. binaries, not sql dumps) copied from
> somewhere.
>
> However, the "show databases;" command did not give me the "foo" database;
> and the "use foo;
Hi, I am new to mysql and have a question regarding how to read/import
existing mysql databases (i.e. binaries, not sql dumps) copied from
somewhere.
What I now have is a whole mysql directory that contains all binary files
(version 5.0.27 for 32bit Linux) copied from somewhere, including database
10 matches
Mail list logo
