Re: innodb_lock_wait_timeout and replication

2012-10-12 Thread Reindl Harald
Am 12.10.2012 19:58, schrieb Hubert de Donnea: > I get all your mails for yearscould you not help me and suppress my name > from your contact what the hell why do people subscribe to a mailing-list without use google to understand what a mailing-list is? http://en.wikipedia.org/wiki/Mail

Re: Extract text from string

2012-10-12 Thread Singer Wang
Of course... There's many libraries for REGEX which you can use, link it with an UDF and boom! http://dev.mysql.com/doc/refman/5.1/en/adding-udf.html S On Fri, Oct 12, 2012 at 12:56 PM, Neil Tompkins < neil.tompk...@googlemail.com> wrote: > Hi, > > Is there such a way in a MySQL query to extr

RE: Extract text from string

2012-10-12 Thread Rick James
No. Or if there is, it is too ugly to contemplate. You are better off doing such in a real programming language. MySQL will locate row(s) containing "this is a test" via LIKE, RLIKE, or FULLTEXT (with caveats). You need to take over from there. > -Original Message- > From: Neil Tompkin

Re: innodb_lock_wait_timeout and replication

2012-10-12 Thread Andrew Moore
You are subscribed to the MySQL mailing list. You will need to unsubscribe yourself. On Fri, Oct 12, 2012 at 6:58 PM, Hubert de Donnea < hubertdedon...@hotmail.com> wrote: > I get all your mails for yearscould you not help me and suppress my > name from your contact thanks > > > To: mysql@li

RE: innodb_lock_wait_timeout and replication

2012-10-12 Thread Hubert de Donnea
I get all your mails for yearscould you not help me and suppress my name from your contact thanks > To: mysql@lists.mysql.com > From: markus.f...@fasel.at > Subject: innodb_lock_wait_timeout and replication > Date: Fri, 12 Oct 2012 16:08:42 +0200 > > I encountered an error > MySQL Error: Lo

Extract text from string

2012-10-12 Thread Neil Tompkins
Hi, Is there such a way in a MySQL query to extract the text "this is a test" from the following strings as a example http://www.domain.com/"; class="link">this is a test http://www.domain.com/"; title="this is a test" class="link">link Thanks Neil

Re: innodb_lock_wait_timeout

2012-10-12 Thread Michael Dykman
In my implementation we found no need to establish a new connection after a lock timeout but just retried on the existing connection. We did instigate a sleep timeout of 10 ms which theoretically increased on each iteration but we never had to try a third time even under very heavy load. On 2012-1

innodb_lock_wait_timeout and replication

2012-10-12 Thread Markus Falb
I encountered an error MySQL Error: Lock wait timeout exceeded; try restarting transaction MySQL Error No: 1205 For this very statement an entry in the binlog was filed ... # Query_time: 52 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 ... Why is there an entry in the binlog if the statement fai

Re: innodb_lock_wait_timeout

2012-10-12 Thread Reindl Harald
Am 12.10.2012 15:39, schrieb Markus Falb: > With a low timeout the connection will be terminated sooner, but if the > application retries another connection is taken. I could have raised the > timeout with the same effect on the db side (1 process is waiting) but > maybe more performant (no new c

Re: innodb_lock_wait_timeout

2012-10-12 Thread Markus Falb
On 11.10.2012 14:43, Johan De Meersman wrote: > > - Original Message - >> From: "Markus Falb" >> >> But why is retrying better than raising the value? >> >> So what is better, adjusting the timeout or retrying application side >> and why? > > Well, raising the timeout would probably help