non-interactive installation of mysql

2011-05-06 Thread Gergely Buday
Hi there, this might be not mysql question in the narrow sense but I hope somebody will be able to help me: I'm trying to install mysql-server non-interactively on a ubuntu box: remote 'echo mysql-server-5.1 mysql-server/root_password password "" | sudo debconf-set-selections' remote 'echo mysql-

RE: DBCP error

2011-05-06 Thread Martin Gainty
connection leaks will occur because of code maladies did you check your code to ensure: you are closing Statement Handles when you have finished executing the statement? you are closing Connection Handles when you have finished DML and DDL operations with the Database? ? Martin

RE: Input needed...

2011-05-06 Thread Martin Gainty
> From: h.rei...@thelounge.net > To: mysql@lists.mysql.com > Subject: Re: Input needed... > > Am 06.05.2011 13:26, schrieb J M: > > Config: > > > > Running on 8G Server.. Currently utilizing 7G.. running only mysql.. > > > [mysqld] > > innodb_data_home_dir = /var/lib/mysql/ > > innodb_data_file

Re: Input needed...

2011-05-06 Thread Reindl Harald
Am 06.05.2011 13:26, schrieb J M: > Config: > > Running on 8G Server.. Currently utilizing 7G.. running only mysql.. > [mysqld] > port= 3306 > socket = /var/lib/mysql/mysql.sock > skip-locking > key_buffer_size = 384M depends on the size of all yur keys > max_allowed_packet

RE: Input needed...

2011-05-06 Thread Martin Gainty
Harald- could you re-iterate the details of the malady or error you are experiencing? danke, Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich

Re: Input needed...

2011-05-06 Thread J M
Config: Running on 8G Server.. Currently utilizing 7G.. running only mysql.. [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer_size = 384M max_allowed_packet = 1M table_

Re: Fwd: DBCP error

2011-05-06 Thread Nigel Wood
On Fri, 2011-05-06 at 11:12 +0100, Dhaval Jaiswal wrote: > Caused by: java.net.SocketException: Socket closed I'd suggest you look at server side timeout and maximum connection settings in http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html I'd suspect wait_timeout is the setting y

Fwd: DBCP error

2011-05-06 Thread Dhaval Jaiswal
Hi All, We are frequently getting DBCP error. We have seen this error in catalina.log & apps log. This issue has started since last 2 -3 days. We have checked the application code when this error has occured and assure that there is no connection leakage in code. Mysql server is also running fine

Re: RV: independent tables

2011-05-06 Thread Phil
Why not just use a union ? select userID,NULL as clientID from user where userCodeDrivingLicense = '321321321' union select NULL as userID,clientID from client where clientCodeDrivingLicense = '321321321'; 2011/5/6 Rocio Gomez Escribano > Tables "client" an "user" are quite similar, but they

RE: RV: independent tables

2011-05-06 Thread Nigel Wood
On Fri, 2011-05-06 at 09:00 +0100, Rocio Gomez Escribano wrote: > Tables "client" an "user" are quite similar, but they don't have any > intersection, I mean, if somebody is a client, he or she cant be a user. So, > I have his or her driving license and I need to know what kind of person is. > > I

RE: RV: independent tables

2011-05-06 Thread Rocio Gomez Escribano
Tables "client" an "user" are quite similar, but they don't have any intersection, I mean, if somebody is a client, he or she cant be a user. So, I have his or her driving license and I need to know what kind of person is. Im trying some join left, right, but I'm unable to get it!! Rocío Gómez