Is there any way to iterate thru the keys in a fulltext index? This issue
does not come up for other indexes since ORDER BY can achieve this:
For example if table t is indexed on part_id
SELECT DISTINCT part_id FROM t ORDER by part_id;
will return all keys in index order
Is there a way to do
Is there any way to disable replication of all temp tables using
replicate-ignore-table or some other means? The names of the temp tables
are generated randomly by a script. Thanks
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
so mysql can take full advantage of the dual cpu w/out a recompile?
Thanks
--Todd
On Mon, 30 Jun 2003, Mike Wexler wrote:
>
>
> Todd Burke wrote:
>
> >Which is the better option to host mysqld:
> >
> >MACHINE A:
> >
> > 2.4 GHz CPU
> >
Which is the better option to host mysqld:
MACHINE A:
2.4 GHz CPU
1024 MB Ram
2x 18 GB SCSI
HDD RAID 1
MACHINE B:
Dual Xeon
1.8 GHz CPU
1024 MB Ram
3x 18 GB SCSI
HDD RAID 5
In other words will mysql benefit from the dual c
ce?
2/ Is there any documentation on handling and configuring large tables?
Hope this is not too confusing...
Many thanks
Todd Burke
phbnyc.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]