Re: Reply-to is to originator rather than to list

2007-10-21 Thread Christophe Gregoir
Some good advice, applying to both mailing lists and businesses: Always reply-to-all, unless there is a good reason not to. My 2 cents. Rob Wultsch schreef: I was previously on a list where the reply-to was setup as it is on the mysql list, with the originator receiving a response rather than

Re: database structure

2007-07-02 Thread Christophe Gregoir
CREATE TABLE `tags` (`tagid` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, `location` VARCHAR(255) NOT NULL DEFAULT '') ENGINE=INNODB; CREATE TABLE `dimension_type` (`id` ..., `type` VARCHAR(255) NOT NULL DEFAULT '') ENGINE=INNODB; CREATE TABLE `tags_shape_dimensions` (`tag` INT(11) UNSIGNED, `dim

Re: question about "Queries per second avg"

2007-04-06 Thread Christophe Gregoir
Ofcourse, the number of queries is just the value of Questions. Christophe Gregoir wrote: I have to admit, Google doesn't provide much information. Let's take a closer look and see if we can't figure out ourselves what that value means. Here is the output of `mysqladmi

Re: question about "Queries per second avg"

2007-04-06 Thread Christophe Gregoir
load. Question answered ? grtz C.R.Vegelin wrote: Thanks Christophe, Question rephrased: how do you explain 0.05 q/s = 20 s/q with an immediate response ? Cor - Original Message - From: "Christophe Gregoir" <[EMAIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL

Re: question about "Queries per second avg"

2007-04-06 Thread Christophe Gregoir
C.R.Vegelin wrote: ... How should I interpret "Queries per second avg" ? How about as 'queries per second on average' :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ORDER BY question

2007-03-21 Thread Christophe Gregoir
Hey Mike, Sounds like you would be better of with an ENUM of integers, e.g. ENUM(-1,1,2,3) where -1 stands for to be started, 1 for started and so on. To answer your question: ORDER BY `status` = 'to be started', `status` = 'started', `status` = 'finished', `status` = 'canceled' Mike van Hoo

Re: indexes and size

2007-03-20 Thread Christophe Gregoir
Hiep Nguyen wrote: i believe "date" is a reserved word for mysql. don't use reserved word for the column name. it's confused. Using reserved words may be confusing, but it is fine as long as you put them between backticks, as I'm sure the OP is aware of. On Tue, 20 Mar 2007, Peter wrot

Re: Can't Bind to Port

2007-03-02 Thread Christophe Gregoir
Drew Jenkins wrote: - Original Message From: Borokov Smith <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 6:21:59 PM Subject: Re: Can't Bind to Port netstat -nlp | grep 3306 Option p requires a protocol. What pro