Zmanda ZRM backup, although the fancy webinterface is only available in the
commercial version. Backups are stored on the host that runs the server, and of
course it serves multiple MySQL machines.
Webinterface is annoyingly slow, though :-)
- Original Message -
From: Michael Heaney
interactive/wait_timeout = 120Seconds
max_connection = 1500
still we are getting errors.
--
Regards,
Dhaval
On Fri, May 6, 2011 at 4:05 PM, Nigel Wood nw...@plus.net wrote:
On Fri, 2011-05-06 at 11:12 +0100, Dhaval Jaiswal wrote:
Caused by: java.net.SocketException: Socket closed
I'd
Yeah, we have some of the SQL statements which are running more than 1
minutes. However, for small queries it's also throwing errors DBCP.
--
Regards,
Dhaval
On Fri, May 6, 2011 at 4:59 PM, Martin Gainty mgai...@hotmail.com wrote:
Id the execution delivers results in under a minute then
This used to work fine in Mysql 4.3, but no longer works in 5.5.8:
set @txt='needle';
select * from table where field like CONCAT('%',@txt,'%');
--returns the null set. If I substitute like this:
select * from table where field like '%needle%';
it works perfectly (and as it did in 4.x).
Hi, I just tried this on a schema I had laying about and it worked fine:
mysql SET @dude='pilgrim';
Query OK, 0 rows affected (0.00 sec)
mysql SELECT namefield FROM mytable WHERE namefield LIKE
CONCAT('%',@dude,'%');
+---+
| name
