innodb table lock question

2004-06-24 Thread Frank Singleton
Hi, A quick mysql database question (using innodb) and connection with java. If someone locks the table with write, can we set a timeout when we are doing a query on that table, so that that it will timeout and throw an exception after say 60 seconds, rather than block ? /Frank -- MySQL General

Re: mysql 2 nics forward to bound ipaddress

2004-04-02 Thread Frank Singleton
Frank Singleton wrote: Hi, If I start mysql bound to a particular address on our server, eg: mysqld --bind-address=MY_IP_ADDRESS and this server has 2 nics connected via 2 switches. If the first NIC or switch fails, can I use iptables to forward incoming mysql requests from the 2nd (alive

mysql 2 nics forward to bound ipaddress

2004-04-01 Thread Frank Singleton
Hi, If I start mysql bound to a particular address on our server, eg: mysqld --bind-address=MY_IP_ADDRESS and this server has 2 nics connected via 2 switches. If the first NIC or switch fails, can I use iptables to forward incoming mysql requests from the 2nd (alive) nic (IP address) so it *l