Iterating thru FullText Index

2004-03-05 Thread Todd Burke
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

Ignore Replication Temp Tables

2004-01-20 Thread Todd Burke
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

Re: Dual / Single CPU

2003-06-30 Thread Todd Burke
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 > >

Dual / Single CPU

2003-06-30 Thread Todd Burke
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

Replication Performance

2003-06-24 Thread Todd Burke
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]