Re: does mySQL support a boolean data type?

2003-07-13 Thread Andreas D. Landmark
laration of a boolean > >data type? Currently I am using VARCHAR(6)s with either 'TRUE' or > >'FALSE' and would like to cut down on the storage. Or use an enum ('TRUE', 'FALSE), that would work too, certainly quicker and easier than using a VARCHAR. -

Re: Stopping MySQL taking down a server?

2003-07-13 Thread Andreas D. Landmark
MP or more) that way the thread adding an index (or somethingelse CPU-intensive) would just grab one CPU leaving the other(s) to do system and other stuff... (serving other requests for instance). -- Andreas D. Landmark / noXtension -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Recomended RAM for production server. 3Gb overboard?

2003-07-10 Thread Andreas D. Landmark
hough :) I'd say 3-4 Gigabyte was rather excessive, seems like the salesman is trying to increase his own provision of the sale... But with RAM being cheap, and you do have quite a few sessions going there, I'd probably go for something in the area of 1-2 gigabytes... Too much ram doe

Re: Mysql - Dual Xeon or Dual Opteron

2003-07-10 Thread Andreas D. Landmark
> >> with the noticeable difference in clock speed. > > > > But they are capable of more than 2-way... > > Get yourself a quad Xeon-board, and start with two CPUs, adding more as > > you go along... > > > > -- > > Andreas D. Landmark / noXtension >

Re: Mysql - Dual Xeon or Dual Opteron

2003-07-10 Thread Andreas D. Landmark
gt; > Can't you get a machine for testing before you buy it? Xeon > processors aren't necessarily a significant win over Pentium 3s, even > with the noticeable difference in clock speed. But they are capable of more than 2-way... Get yourself a quad Xeon-board, and start w

Re: backup / superuser only

2003-07-10 Thread Andreas D. Landmark
n finished change the port number back to 3306. > Not a very good solution if you ask me, only takes one person to portscan the machine and find it... I'd rather go for the swapping the user table (or setting all hosts to an invalid host so nobody can connect) -- Andreas D. Landmark / n

Sub-selects in a insert statement - is it possible to rewrite?

2001-06-25 Thread Andreas D. Landmark
hing without doing queries on the much bigger log table). Cheers, -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. - Before posting, please