hi all ,
i'm trying to improve performance of a quite big and heavily used mysql
set of tables.
i want to create some indexes on this table , but before this , i'd like
to remove the ones created by my predecessor , which are sometimes
duplicate , and somtimes useless.
here is an output from
* Benjamin KRIEF
[...]
first of all , i'm asking myself : why is there 2 primary keys on the
same column ?
Don't know... strange.
[...]
mysql drop index login connexion on v2easy0_users;
ERROR 1064: You have an error in your SQL syntax near 'connexion on
v2easy0_users' at line 1
In the last episode (Sep 01), Benjamin KRIEF said:
hi all ,
i'm trying to improve performance of a quite big and heavily used mysql
set of tables.
i want to create some indexes on this table , but before this , i'd like
to remove the ones created by my predecessor , which are sometimes
`,
-- Drop the PRIMARY KEY with 2 id columns
DROP PRIMARY KEY,
-- And re-add it with just one column
ADD PRIMARY KEY (id);
Hope that helps.
Matt
- Original Message -
From: Benjamin KRIEF
Sent: Sunday, August 31, 2003 7:40 PM
Subject: spaces in index name
hi all ,
i'm trying to improve
);
Hope that helps.
Matt
- Original Message -
From: Benjamin KRIEF
Sent: Sunday, August 31, 2003 7:40 PM
Subject: spaces in index name
hi all ,
i'm trying to improve performance of a quite big and heavily used
mysql
set of tables.
i want to create some indexes on this table
Hi,
- Original Message -
From: Benjamin KRIEF
Sent: Sunday, August 31, 2003 8:17 PM
Subject: Re: spaces in index name
thanks for all your answers ! i'd never imagine that mailing-list to
be
so active and efficient!
It's usually not that active on weekends, volume-wise. And I see