right configuration.

2007-03-24 Thread Ananda Kumar
Hi Friends, We are in the processing of building a new Mysql database. We are planing to use innodb. I need help on couple of questions. 1. What are the best parameter setting in my.cnf for innodb. 2. Is it possible to allocate each table a separate tablespace. 3. Is it possible to create index i

Re: problems with replication when db is changed

2007-03-24 Thread Mathieu Bruneau
Bgs a écrit : > > Greetings, > > We have regular problems with mysql replication when there is a db > change. This is mostly ALTER TABLE. The sync breaks and we either have > to do the changes manually or either shut down the whole system for a > new sync from zero. Is there a way to sync alter

Re: Index not used sometimes -- why?

2007-03-24 Thread Mathieu Bruneau
M5 a écrit : > Sometimes, when I run a query on a table, the index will be used. But if > I run the SAME query, but on a larger set of rows (e.g., where id > BETWEEN 1 AND 10 vs WHERE id BETWEEN 1 AND 500), the index is not > used. (EXPLAIN tells me this.) And as a result, the query runs slow.

Re: SPAM ?

2007-03-24 Thread Martijn Tonies
> Hi, > > I also get the problem of keep receiving the email from the email list Yeah, same here. I keep getting e-mail from a list that I subscribed to and confirmed my subscription for ... Dang, how do I solve that. ;) -- Martijn -- MySQL General Mailing List For list archives: http:/

Index not used sometimes -- why?

2007-03-24 Thread M5
Sometimes, when I run a query on a table, the index will be used. But if I run the SAME query, but on a larger set of rows (e.g., where id BETWEEN 1 AND 10 vs WHERE id BETWEEN 1 AND 500), the index is not used. (EXPLAIN tells me this.) And as a result, the query runs slow. The question

Re: SPAM ?

2007-03-24 Thread LP
Hi, I also get the problem of keep receiving the email from the email list Regards KEVIN - Original Message - From: "Jacques Brignon" <[EMAIL PROTECTED]> To: "'Jerry Schwartz'" <[EMAIL PROTECTED]> Cc: "'MySQL List'" Sent: Saturday, March 24, 2007 10:45 PM Subject: SPAM ? Hi, I

SPAM ?

2007-03-24 Thread Jacques Brignon
Hi, I keep receiving this message by several dozens each day, how can this be stopped? Regards Jacques > -Message d'origine- > De : Jerry Schwartz [mailto:[EMAIL PROTECTED] > Envoyé : jeudi 22 mars 2007 17:53 > À : [EMAIL PROTECTED]; 'James Tu' > Cc : 'MySQL List' > Objet : RE: Finding