Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
Regards, Cor
- Original Message -
From: Sebastian Mendel [EMAIL PROTECTED]
To: Michael Stearne [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
Sent: Thursday, January
Iago, all,
[EMAIL PROTECTED] wrote:
Hi.
I has a Linux server with MySQL 4.0.27 and I want to upgrade to 4.0.30 but I
both the 4.0 and 4.1 MySQL release families have reached their end of
active development and are in extended lifecycle only.
This means there is neither development not
C.R.Vegelin wrote:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
AFAIK, MySQL (atleast from version 5.0 onwards) is capable of
using multiple indexes.
--
Regards,
Anup Shukla
--
MySQL General Mailing List
For list archives:
Iago, all,
Joerg Bruehe wrote:
[EMAIL PROTECTED] wrote:
[[...]]
couldn't find in HYPERLINK http://www.mysql.comwww.mysql.com or in
the web
the file mysql-standard-4.0.27-pc-linux-gnu-i686.tar.gz. Also the link
HYPERLINK
C.R.Vegelin schrieb:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
IMHO, but i heard elselike too, but cannot find any proof in the manual ...
--
Sebastian
--
MySQL General Mailing List
For list archives:
Anup Shukla schrieb:
C.R.Vegelin wrote:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
AFAIK, MySQL (atleast from version 5.0 onwards) is capable of
using multiple indexes.
i have heard of something similar too, but cannot
Perrin Harkins schrieb:
On Jan 11, 2008 7:22 AM, Sebastian Mendel [EMAIL PROTECTED] wrote:
i can only find one source in the manual, where MySQL is using more than on
index:
http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html
Uh, how many sources do you need?
1?
It
On Jan 11, 2008 7:22 AM, Sebastian Mendel [EMAIL PROTECTED] wrote:
i can only find one source in the manual, where MySQL is using more than on
index:
http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html
Uh, how many sources do you need? It uses multiple indexes, just like
it
Dear Users
I searched google, find alot of tips, but none of the them was
successfully.
After a db move with ibdata files, which cannot be dumped (cause of a table
failure) we made a hardcopy of the files and moved it onto the new server.
Eg. we copy ibdatafiles, the original my.cnf to the new
Hi, Joerg.
Thanks for the response.
In ftp://mysql.secsup.org/pub/software/mysql/Downloads/MySQL-4.0/ and other
similars that I find looking for mysql/Downloads/MySQL-4.0 in google there
is only MySQL 4.0.26 and 4.0.27.
both the 4.0 and 4.1 MySQL release families have reached their end of
Sebastian Mendel schrieb:
Anup Shukla schrieb:
C.R.Vegelin wrote:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
AFAIK, MySQL (atleast from version 5.0 onwards) is capable of
using multiple indexes.
i have heard of
Notwithstanding end-of-life status, is there an issue in MySQL v3.23
r.e. the union operator?
My installation returns a syntax error on any query containing the union
operator, even with the sample queries provided in the documentation:
mysql SELECT REPEAT('a',1) UNION SELECT
On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote:
Notwithstanding end-of-life status, is there an issue in MySQL v3.23
r.e. the union operator?
My installation returns a syntax error on any query containing the union
operator, even with the sample queries provided in the
Jim Winstead wrote, On 1/11/2008 12:54 PM:
On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote:
Notwithstanding end-of-life status, is there an issue in MySQL v3.23
r.e. the union operator?
My installation returns a syntax error on any query containing the union
operator, even with
14 matches
Mail list logo