Comparing text documents

I have lots of text documents archived in a mysql database. I need to compare these documents to see which ones are similar (either they may have a small formatting difference or have a word or two different). Is there a function/method in mysql that will easily accomplish this? If not could you

Re: can't connect to server

At 16:11 30/11/2001 +0100, [EMAIL PROTECTED] wrote: Hi, I don't understand very well your problem, anyway here some informations: Using the MySQL Server as Service To start/stop options: 1- net start mysql/net stop mysql 2- using the SCM (Service Control Manager) 3- using the WinMySQLAdmin

Case insensitive

Hi! i'm converting some database from windows mysql to freebsd. Program wich uses this database is written very bad (not mine) and did not correctly call querries. Problem is with case sensitivity of unix. Is there any way to tell mysql on unix that SELECT * FROM table is ste same as SELECT *

MySQL 3.23.46 is released

Hi! MySQL 3.23.46 is now released. This is a bug fix release that fixes some newly detected bugs in MySQL. If you haven't noticed any problems with your MySQL version and you don't have a batch that automaticly does ANALYZE TABLE once in a while there is need to upgrade. This release should

CVS changed some things:

System = Linux 2.5.1 ARCH:i686-pc-linux-gnu 1. I changed the global.h file to include signal.h since if signal.h is included after global.h I get an error with __sighandler_t. You should change your configuration. 2. I had to install autoconf 2.13 since your autoconf scripts dont work with

CVS errors corrected addition:

Ok that was not too hard, I also solved this problem: 3. In subdirectory sql you try to include lex_hash.h I could not find this file. There is a problem with get_hash_symbol((const char *)tok,len,function) in sql_lex.cc. Do I need another dependent software ? where did you hide this function ?

Re: CVS finally worked.

Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: With the errors corrected, like I wrote in my two previous mailings, I could compile the CVS tree for mysql

Re: Comparing an alias ...

Julio Faerman writes: Hi ... I am need the following query to work : SELECT min(my_colum) as MINIMAL_VALUE WHERE MINIMAL_VALUE 10 The query is not EXACTLY as this one, but i think it is enough to get you the idea of my problem... What would this mean? The WHERE clause is what

QUICK HELP, two selects, maybe nested.

Looking though the docs. MySQL does not support nested selects but i'm looking for a way to speed up my PHP. This is what i have: CREATE TABLE departmentuser ( userid int(10) unsigned zerofill default NULL, departmentid int(10) unsigned zerofill default NULL, KEY

RE: mysqldump: problem/question

Weaver, Walt writes: I knew it. Nobody bothered to read my post. The original problem involved running a lightweight version of mysqldump in a simulated nanokernel environment with reduced power resources. The ultimate result, we hope, is to use it to record Quidditch matches being played

Re: median function?

Michael writes: Umm does this mean there is no way to do what I need? Is it inappropiate to ask if it'd be difficult for such a function to be added into MySQL if it is the case that this is an impossible thing to do (or even just very challenging)? A median is a very common function to need

MySQL thread hanging on Win2K

Hi, I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables. I'm running an import process which inserts a big set of rows ('bout 27 million), as part of a document indexing process. Each new row uses the AUTO_INCREMENT_ID from the previous row. So, I have a loop which

Re: LEFT JOIN fails to correctly join tables

[EMAIL PROTECTED] writes: Description: It seems that that the use of LEFT JOIN when the joined table uses multiple primary key conditions fails to include rows which are clearly matching on those conditions. How-To-Repeat: mysql create table foo (fooID smallint

Re: QUICK HELP, two selects, maybe nested.

Corey Kaye writes: Looking though the docs. MySQL does not support nested selects but i'm looking for a way to speed up my PHP. This is what i have: CREATE TABLE departmentuser ( userid int(10) unsigned zerofill default NULL, departmentid int(10) unsigned zerofill default NULL,

Re: MySQL thread hanging on Win2K

Chris Withers writes: Hi, I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables. I'm running an import process which inserts a big set of rows ('bout 27 million), as part of a document indexing process. Each new row uses the AUTO_INCREMENT_ID from the previous row.

Re: QUICK HELP, two selects, maybe nested.

I looked that up and IN is an OR ... correct ? Would be like saying: Show me the records where departmentid = 142 OR departmentid = 368 I did however find this: select * from departmentuser r1, departmentuser r2 where r1.userid=r2.userid and r1.departmentid=368 and r2.departmentid=142;

Re: MySQL thread hanging on Win2K

Hi Sinisa, Sinisa Milivojevic wrote: There are several possibilities. You could be reaching some OS limits or haning user / group permission problems. Don't think its permissions, since I had a similar process which ran fine, but I had to change the schema to use the last insert id for

RE: MySQL v.s. Oracle

MySQL is faster than any other database out there on small to medium sized web sites, but when you are going into larger sites, like yours, Oracle or MS SQL Server will be better suited for the task. Oracle does have one major draw back Price... For your size, you will spend in the

Re: Comparing text documents

On Saturday 01 Dec 2001 10:41, Ovanes Manucharyan wrote: I have lots of text documents archived in a mysql database. I need to compare these documents to see which ones are similar (either they may have a small formatting difference or have a word or two different). Is there a function/method

RE: MySQL v.s. Oracle

Hi! Look at the InnoDB/MySQL user stories at http://www.innodb.com 1200 queries per second on a single processor Intel box is easy to attain. A terabyte of data is handled at an InnoDB/MySQL site. InnoDB is close to Oracle in architecture. Regards, Heikki http://www.innodb.com -- Order

Re: MySQL v.s. Oracle

We are currently using MySQL for our database driven website. Currently, we have about 100,000 users. In January, we will be getting 2 million new registered users on our website. Yes, but how many hits are you expecting, and what sort of queries will be ran? We're buying a $50,000 Sun box

Re: Comparing an alias ...

HAVING worked OK thus . - What would this mean? The WHERE clause is what determines what rows will be used in the GROUP BY functions, e.g. MIN(). How do you know what rows to use when you need to know what rows to use before you can figure out the criteria for what rows to use? Trying to

Re: is there a timestamp function for a table

In message [EMAIL PROTECTED], Mark Worsdall [EMAIL PROTECTED] writes Hi, Want I need is to find out when a table was last updated, not a records timestamp. Is there a way? or for SW people: way is there a? Obviously not. -- Work:- postmasterAThinwick.demon.co.uk

MySQL on SMP machine

How to get an advantage from Dual ProcessorMachine when i'm using MySQL, should i recompile MySQL what option should be activated ? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual)

MySQL still hanging on Win2K :-(

Hi again, Sinisa... Chris Withers wrote: Okay, table_cache increased from 64 to 256... * check free disk space on all drives Well, it got up to indexing 10,000 documents this time but then hung again. Now, I don't know if this is because increasing the table_cache made a difference or

64bit mysql and gcc

Greetings, I am having some trouble getting a 64bit mysql (built with gcc) to work correctly. I am able to build and start mysql, but it crashes anytime I try to manipulate a table with some data in it. This is using mysql-3.23.42. Here is what I see in the error log. 011130 18:53:35 mysqld

Re: tricky update, how?

Hi. MySQL doesn't (yet) suport sub-queries. For further information have a look at http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html. Bye, Benjamin. On Thu, Nov 29, 2001 at 12:07:01AM -0500, [EMAIL PROTECTED] wrote: Hi all, I wanna try the following query,

Re: Possible bug - further refinement

Hi. I tested this with 3.23.38 and was not able to reproduce the problem. The UPDATE works as supposed for me. Did you compile the server yourself? If so, try an official binary. If not, please post more information, like where you got your binary from, which version it is and so on. Use

Changing the socket location?

I was wondering is there anyway to change the socket location from /tmp/mysql.sock to something else, other than recompiling :-)? If there is not I would like to highly recommend it as an option. TIA stevet _ Do You Yahoo!? Get your

MyODBC Problem with SQL2000 - MySQL Data Transformation

Hi Folks, I'm having a problem when I try to populate a MySQL database using DTS in SQL2000. The data types on the SQL2k table are varchar, as well as the types in MySQL. I am receiving a 'Data Overflow' error for each column that it tries to update. I've tried numerous ways of population, each

Re: Changing the socket location?

You can specify the location when you start up the server --socket=/path/to/mysql.sock or enter it in your my.cnf file: socket = /path/to/mysql.sock in the [mysqld] group On Sat, 17 Nov 2001 21:34:24 -0600, Stephen P Toothman [EMAIL PROTECTED] wrote: I was wondering is there anyway to

Re: linux, mysql and intel processor or amd processor

Barbara Ferrell writes: i am setting up a musql database on linux. if you had a choice which processor would you use. does it really matter. i keep reading that linux runs better with an intel processor. Who is claiming that? While it's true that the first and main platform for Linux is

Re: Changing the socket location?

Stephen P Toothman writes: I was wondering is there anyway to change the socket location from /tmp/mysql.sock to something else, other than recompiling :-)? If there is not I would like to highly recommend it as an option. Change it in the config file (my.cnf). It's right there. Just be

tables locked during long compound INSERT/DELETE ?

I have web sites where there are periodic inserts ( deletes ) of many new records generated by crawlers. In order to reduce the # of queries I do compound operations like INSERT VALUES(a),(b),(c), and DELETE FROM table WHERE record_id IN ($LONG_ID_LIST). At the same as these operations are

tables locked during long compound INSERT/DELETE ? correction

Sorry I confused read lock with locks that prevent other threads to read. This is what I meant : I have web sites where there are periodic inserts ( deletes ) of many new records generated by crawlers. In order to reduce the # of queries I do compound operations like INSERT

Netscape ignores %20 with $sort=id DESC

Hi, some users of my web are having problems with sorting a MySQL table because older versions of Netscape do not recognize a blank space and do not convert it into a %20. Here's my situation: $sort = id DESC if ($page_num != $total_num_page){print a

Re: Netscape ignores %20 with $sort=id DESC

htmlentities($sort); http://www.php.net/manual/en/function.htmlentities.php Ack, at 12/1/01, Paul Markov said: Hi, some users of my web are having problems with sorting a MySQL table because older versions of Netscape do not recognize a blank space and do not convert it into a %20. Here's my

Re: Netscape ignores %20 with $sort=id DESC

Maurice, If I do $sort = id+DESC I get this error: Warning: Supplied argument is not a valid MySQL result resource (not sure what you mean by URI escape $sort). Tell me more... Thanks! Paul. Maurice Aubrey wrote: On Sat, Dec 01, 2001 at 06:52:13PM -0700, Rosyna wrote:

RE: MySQL v.s. Oracle

Not sure that total users is a good metric; queries per second may be better. We host web sites and use MySQL with MyISAM tables for small and medium-sized sites, Oracle for the big ones. Oracle's row-level locking abilities make a big, deciding difference for the bigger, more active sites.

Re: LEFT JOIN fails to correctly join tables

On 1-Dec-2001 16:49 Sinisa Milivojevic wrote: | | Thank you for the repeatable test case. I've just tested this with 3.23.46 and it still fails. regards. -- -Dale - Before posting, please check:

Re: MySQL still hanging on Win2K :-(

At 22:00 01/12/01 +, Chris Withers wrote: Hi, I have a Win2000 machine and I would like to do a test with your problem. Please can you send me more specify details (definition table and SQL statements) so as I can build a C/C++ client program for try to repeat the issue ?. Regards, Miguel

can you have a no-default column; error if unspecified?

Is it possible to set a column to have no possible default value, so if you try to create a record that doesn't specify a value for that column, you'll get an error? For example, if I have a table where the date field should always be set. I took out the default NULL value, but that just

Re: [MySQL] can you have a no-default column; error if unspecified?

Bennett Haselton wrote: Is it possible to set a column to have no possible default value, so if you try to create a record that doesn't specify a value for that column, you'll get an error? Set it to NOT NULL For example, if I have a table where the date field should always be set.