Hi,
The server where i faced this problem was master server(Replication) but it was
not in use.
I simply comment the server-id=1 in my.cnf and run the command "revoke
replication slave on".
And now i see the increasing aborted_connects stopped.
anyway, thanks to all for your support
Regards
Hi,
http://bugs.mysql.com/bug.php?id=42039
"The --with-mysqld-libs option should be given an argument, something
like --with-mysqld-libs="-L/path/to/lib -lfoo -lbar"
2009/12/27 Kurian Thayil :
> Hi All,
>
> I was trying to compile MySQL 5.1.41 in a Fedora 12 box. I don't want to do an
> RPM ins
Hi,
> I am getting "Can't execute the given command because you have active locked
> tables or an active transaction" error when I am trying to truncate table. I
> am unable to understand the error as when I am using the mysql query browser
> then the same command is working fine but when I am doi
Hi,
MySQL replicate the databases at SQL level, so if the two servers are
using the same engine (innodb), they will be replicated without
problems.
If the BLOB data is big, don't configure the replication over a WAN or
you will get too much latency (of course, it depends on your
bandwidth).
2009
@Walter
By the way your guess is the most likely, good shot!
Claudio
On 30 dec 2009 20:59, "Claudio Nanni" wrote:
Waltet, I think you are not the only one shooting in the dark, in this case
reading the manual can really help.
aborted_connects is increased by a failed attempt to connect to MySQ
Waltet, I think you are not the only one shooting in the dark, in this case
reading the manual can really help.
aborted_connects is increased by a failed attempt to connect to MySQL (wrong
password?) but NOT by a timed-out client.
Could be a cron job setup with some credentials that were changed wi
Random shot in the dark: I've seen this happen with some monitoring
tools that just check to see if the database is up.
Walter
On Wed, Dec 30, 2009 at 17:13, Jeetendra Ranjan
wrote:
> Hi,
>
> My MySQL server Aborted_connects status is showing 8692 and is rapidly
> increasing.
>
> What are reaso
This error may be caused by applications that don't close their connections
when they finish. The session stays open until the timeout. If this
becomes a problem, look at the various applications running on your system.
You might be able to program them better, to either close their connections
o
On 12/30/09 1:13 AM, "Jeetendra Ranjan"
wrote:
> Hi,
>
> My MySQL server Aborted_connects status is showing 8692 and is rapidly
> increasing.
>
> What are reasons and how do i decrease the same?
>
> We are using connect() method in PHP code and have tried below command
>
> mysqladmin flush-ho
You do realize this is a MySQL mailing list and not a collectd mailing list?
I suggest you try here: http://collectd.org/
On Tue, Dec 29, 2009 at 10:38 PM, Kaushal Shriyan
wrote:
> On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan
> wrote:
> > On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan
Set them globally.
Thanks,
Dilipkumar
Database Engineering
Pager mail:9884430...@nma.vodafone.in
-Original Message-
From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com]
Sent: Wednesday, December 30, 2009 3:08 PM
To: Parikh, Dilip Kumar
Cc: mysql@lists.mysql.com
Subject: Re: Abo
Thanks , but i want to solve this problem without shutting down the db
server.
- Original Message -
From: "Parikh, Dilip Kumar"
To: "Jeetendra Ranjan"
Cc:
Sent: Wednesday, December 30, 2009 2:56 PM
Subject: RE: Aborted_connects is incresing repidly
Try using this param in ur my.
Try using this param in ur my.cnf file and restart the mysql to take the new
changes.
# Troubleshoot for MySQL error 2013 Error or Host blockout
set-variable = connect_timeout=60
set-variable = max_connect_errors=1000
Thanks,
Dilipkumar
Database Engineering
Mphasis, an EDS company
phone: +9
Hi All,I am getting "Can't execute the given command
because you have active locked tables or an active transaction" error when
I am trying to truncate table. I am unable to understand the error as when I am
using the mysql query browser then the same command is working fine but when I
am doing it
You can use this --max_connect_errors=9 to avoid this error
2009/12/30 Parikh, Dilip Kumar
> Jetendra,
>
> Can u attach your my.cnf files and also your variable status (show
> variable status). This is required because we need to tune some params.
>
> Thanks,
> Dilipkumar
>
> -Origin
15 matches
Mail list logo
