RE: URGENT - daemon dying frequently

2001-04-09 Thread Opec Kemp \( Ozemail \)
I know this is slightly off-topic but it's related to changing the number of file descriptors on FreeBSD: - FreeBSD by Torsten Sturm How do I check my maximum filedescriptors? Do sysctl -a and look for the value of kern.maxfilesp

RE: URGENT - daemon dying frequently

2001-04-09 Thread Opec Kemp \( Ozemail \)
Looks like you're running out of the file descriptor to handle the connection etc. I'm not really a FreeBSD person but here's what I've found on this site: http://ircache.nlanr.net/Polygraph/Tips/FreeBSD-3.3/ Try increasing max file descriptors in /sys/conf/param.c #define MAXFILES (16384) This

RE: Trojan Horse Virus in MySQL?

2001-03-21 Thread Opec Kemp \( Ozemail \)
Where did you download your MySQL executable from?. Did you download it from MySQL official site or other Mirrors? If you download it from the mirror (or worst from the Official site) and got the Virus then you should let the MySQL Admin know as this is a pretty serious problem. > I've had MySQL

RE: Is sequencing possible in Mysql?

2001-02-22 Thread Opec Kemp \( Ozemail \)
Basically you'd have a DB set up like this: hits_table main_table +--+ +-+ | id | (long int) <- | id | +--+ +-+ | num

RE: Is sequencing possible in Mysql?

2001-02-22 Thread Opec Kemp \( Ozemail \)
Hi, Yes that would be a better solution than to keep inserting a new record. However, you'll have to be careful with the concurrent update of the 2nd field ie if 2 process tries to update the same field at the same time etc. So locking table before update would help. > I have a table that has 2

RE: Keeping MySQL from listening to ports to connections

2001-02-22 Thread Opec Kemp \( Ozemail \)
Hi, As far as I know you can make MySQL listen for Unix Socket connection (as well as TCP/IP connection). As to how much more secure Unix socket is to TCP/IP I really can't tell you. But again AFAIK, to connect to Unix socket you have to be on the same machine as MySQL server. So your Apps would h

RE: XML support under mySQL

2001-02-22 Thread Opec Kemp \( Ozemail \)
*big snip* I agree with Cal, the XML module should really be sperated from the RDMB. XML is really great but, lets face it not everyone is going to use it so why force it down thier troat?. The really great thing about Open Source is that you do have a choice (unlike MS , Oracle). :) You have to