RE: Update and lock question.

2013-04-08 Thread Rick James
An optimization (at least in InnoDB) is to delay updating the secondary index(es). If you can provide a reproducible test case, it would probably be worth filing a bug at bugs.mysql.com > -Original Message- > From: Andrés Tello [mailto:mr.crip...@gmail.com] > Sent: Friday, April 05, 201

RE: MySQL on RHEL4

2013-04-08 Thread Rick James
I would guess it would work. Better to upgrade to RHEL 6.3. > -Original Message- > From: Keith Keller [mailto:kkel...@wombat.san-francisco.ca.us] > Sent: Friday, April 05, 2013 6:46 AM > To: mysql@lists.mysql.com > Subject: Re: MySQL on RHEL4 > > On 2013-04-05, Nitin Mehta wrote: > > > >

Re: update a row only if any column has changed, in a very large table

2013-04-08 Thread Andrés Tello
Take a look here. http://dev.mysql.com/doc/refman/5.0/en/timestamp-initialization.html timestamp field can be autoupdated and autoinitilizated With both DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP, the column has the current timestamp for its default value and is automatically updat

Re: Reg: MYSQL Mail Agent

2013-04-08 Thread spameden
2013/4/8 Reindl Harald > do not top-post > > Am 08.04.2013 12:40, schrieb Bharani Kumar: > > On Mon, Apr 8, 2013 at 4:02 PM, Johan De Meersman >wrote: > > > >> - Original Message - > >>> From: "Bharani Kumar" > >>> > >>> How to enable mail agent service in MYSQL. and what are the necess

Re: Reg: MYSQL Mail Agent

2013-04-08 Thread Bharani Kumar
When i use mssql, i used the mail agent, so similar one expecting in MYSQL, On Mon, Apr 8, 2013 at 4:02 PM, Johan De Meersman wrote: > - Original Message - > > From: "Bharani Kumar" > > > > How to enable mail agent service in MYSQL. and what are the necessary > > steps to send mail. >

Re: Reg: MYSQL Mail Agent

2013-04-08 Thread Reindl Harald
do not top-post Am 08.04.2013 12:40, schrieb Bharani Kumar: > On Mon, Apr 8, 2013 at 4:02 PM, Johan De Meersman wrote: > >> - Original Message - >>> From: "Bharani Kumar" >>> >>> How to enable mail agent service in MYSQL. and what are the necessary >>> steps to send mail. >> >> I suspect

Re: Reg: MYSQL Mail Agent

2013-04-08 Thread Johan De Meersman
- Original Message - > From: "Bharani Kumar" > > How to enable mail agent service in MYSQL. and what are the necessary > steps to send mail. I suspect you're in the wrong place - the Mail Agent is an MS SQL service, iirc. MySQL is a different database entirely, and has no built-in provi