All,
Is there a mysql configuration to kill queries that have been locked for quite
some time. If there's none what is an alternative approach to kill these locked
queries and what is the root cause of it?
Thanks,
Mon
Does this happen if your table is InnoDB?
Thanks all,
Mon
From: Claudio Nanni claudio.na...@gmail.com
To: monloi perez mlp_fol...@yahoo.com
Cc: mysql mailing list mysql@lists.mysql.com
Sent: Thu, October 14, 2010 3:16:38 PM
Subject: Re: How to kill locked
All,
Sorry if this is the wrong mailing list to post yet please help me out or
redirect me to the right one.
Here are some concerns we PHP Developers have over our MySQL Database.
1) While inserting and connection lost, what will happen? Is the query
going to be there forever?
2)
Any idea on this?
-Mon
From: Michael Satterwhite mich...@weblore.com
To: mysql@lists.mysql.com
Sent: Mon, September 13, 2010 1:07:38 AM
Subject: Re: skip locking
Received.
On Sunday, September 12, 2010 09:32:12 am monloi perez wrote:
Hi All,
Sorry if I
Hi All,
Sorry if I posted on the wrong list.
I've had this issue with my previous server already, seems like skip-locking
configuration does not seem to work on myisam tables.
Also what is the difference between myisam and innodb tables. The reason I
wanted to know is that I think
Thansk,
Will try to turn on log_warnings.
-Mon
From: Nitin Mehta ntn...@yahoo.com
To: monloi perez mlp_fol...@yahoo.com; Ananda Kumar anan...@gmail.com
Cc: mysql mailing list mysql@lists.mysql.com
Sent: Sun, September 5, 2010 12:03:45 PM
Subject: Re: Logs
on the db server? meaning the mysqld log right? THere is really no data for
teh
current error. The last error they said was too much connections and shouldnt
that be logged in mysqld.log?
Thanks,
Mon
From: Ananda Kumar anan...@gmail.com
To: monloi perez
All,
I'm not sure if this is the right mailing list since the specific mailing lists
doesn't seem to meet my concern.
For some reason mysql client stops logging to mysqd.log. We had an issue on Aug
20. But when I checked the log, the latest was on Aug 2.
Any idea on how to resolve this or what
Hi All,
I'm not sure if this question is fine, I'm new to the list and I just have one
very important question.
Can anyone help me suggest the right optimization for our company's server.
Our current server is a Dell PowerEdge 1900 a QuadCore with 1TB total (Raid 1)
of HD space and 4G RAM.
The