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
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
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.
> 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:/
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
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
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