massive fulltext indexes - what hardware?

I'm busy building an application that will have 10 million records, each with a chunk of text - about 500 words each, on average. Does anyone have any benchmarks they can share with mysql's fulltext search performance on indexes of this size? What I'd like to know is what size server I need to run

mysql NOT operator

Hello, Could you please tell me how I can write an sql statement in php when I'd llike to select boolean search in one field like "except" or "NOT" result. What I mean here is that I can execute the following: 1. SELECT data_id from table WHERE keyword = a AND keyword =b 2. SELECT data_id from ta

Tables Crash when I Delete A Row

Hi all , I am having some issues with 4.1.7 on Redhat 9 Kernel 2.4.20-8SMP The other day I upgraded to RH9 and then put on: mysql-standard-4.1.7-pc-linux-i686-icc-glibc23 Since then , it seems that one of (not all!) our tables has taken to crashing when you delete records from it. It spits out

Re: Optimize query and/or db structure, FullText search + sort by other fields

Hi All, The temporary table wasn't a better idea, the problem is that if the search returns 1500+ rows ( on a 20 000 recs table), the population of temporary table is still slow making no significant difference. Well, I'm in a strange situation as for the moment. I've created helper tables, eg to p

RE: Advanced SELECT Syntax Help Needed!

Thank you Frederic! It worked perfectly!!! I didn't know you could have several joins linked together! Monique. -Original Message- From: Frederic Wenzel [mailto:[EMAIL PROTECTED] Sent: Saturday, November 06, 2004 3:56 AM To: Rhino Cc: Monique; [EMAIL PROTECTED] Subject: Re: Advanced SE

Re: AW: connection problem with 4.1.7

Hi, I am having an intermitten connection problem with MySQL 4.1.7 . Here is the setup. Intel P4 with HT Fedora Core 1 kernel 2.4.27 smp MySQL version 4.1.7 (RPM install from mysql.org) Qmail with vpopmail using mysql (www.qmailtoaster.com) Sometimes I cannot login to qmail to check mail. Using thu

RE: 4.1.7 serious problems

Are you connecting from the local mysql command line client? Or from some other box? I saw this happen once before, but we were using an old client. Donny > -Original Message- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 06, 2004 4:06 AM > To: [EMAIL PROTECT

Re: Reorder a table

> He means that his primary key column has rows with id=1 and > id=3, but not with id=2. Thanks, this is exactly the problem. I did not blame mysql for anything - I like it a lot. I blamed the news application, to which I referred as "the application". I did not develop the application/ don't ha

Re: Reorder a table

Thanks Michael! That seems like a more reasonable explanation of what the original poster meant than what I understood. I assume he'll clarify what he meant if either of us got it wrong Rhino - Original Message - From: "Michael Stassen" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTE

Re: replication log error

Alvaro Avello wrote: mysql> show slave status\G; *** 1. row *** Master_Host: hubble Master_User: replica Master_Port: 3306 Connect_retry: 60 Master_Log_File: hubble-bin.009 Read_Master_Log_Pos: 646906124

Re: sql query to return unique ids from a table of date stamped results

How will that help? He already has a timestamp column. He's asking how to get the rows conataining the groupwise maximum timestamps. Michael Gleb Paharenko wrote: Hi. May be it will be helpful: http://dev.mysql.com/doc/mysql/en/TIMESTAMP_4.1.html "Rob Keeling" <[EMAIL PROTECTED]> wrote: I am

Re: Reorder a table

He means that his primary key column has rows with id=1 and id=3, but not with id=2. That is, deletions have left holes in the sequence. He theorizes that renumbering will help. I agree with you that it won't. Michael Rhino wrote: - Original Message - From: "Martin" <[EMAIL PROTECTED

Re: sql query to return unique ids from a table of date stamped results

For each ADNO, you want the row with Lastupdatetime equal to that group's MAX(Lastupdatetime) . This is a little bit tricky and a frequently asked question. There are 3 ways to do it documented in the manual . Michael Ro

Re: Reorder a table

- Original Message - From: "Martin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 06, 2004 6:49 AM Subject: Reorder a table > Hi all, > > I have a problem with a news application, which writes news items into a > mysql table. Recently it gets confused, when it ins

Re: Advanced SELECT Syntax Help Needed!

On Fri, 5 Nov 2004 17:49:29 -0500, Rhino <[EMAIL PROTECTED]> wrote: > I'm not sure why you want to use a subquery; if MySQL is anything like DB2, > a join usually performs better than a subquery and the optimizer converts a > subquery to a join ("under the covers") whenever it can anyway. Therefore

Reorder a table

Hi all, I have a problem with a news application, which writes news items into a mysql table. Recently it gets confused, when it inserts new news items into the table. I get the following exception: "Duplicate entry '25' for key 1". root cause was java.sql.SQLException: Invalid argument value, me

Error 1064 in three tables. How do I fix them.

Good Morning. I am new to the list and new to Mysql. I am in the process of running a website and I need a little newbie help. In my database I have three tables that I am having problems with and each one has the same error. Here is the error. 1064 - You have an error in your SQL syntax; che

Re: 4.1.7 serious problems

Ugo, - Original Message - From: "Ugo Bellavance" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, November 05, 2004 3:42 PM Subject: Re: 4.1.7 serious problems Gleb Paharenko wrote: Hi. There were several posts in list like yours. Do you use InnoDB tables? Try to inc

Re: sql query to return unique ids from a table of date stamped results

Hi. May be it will be helpful: http://dev.mysql.com/doc/mysql/en/TIMESTAMP_4.1.html "Rob Keeling" <[EMAIL PROTECTED]> wrote: > I am trying to find the sql statement needed to extract, from a table of > data with multiple instances of a id no, > a list of unique id nos, picking the lates