Re: Quota Support

2002-12-10 Thread Cedric Veilleux
Yes, you certainly needs to chown the files to the specific user id's for filesystem quota to count the files in the user's quota. This will solve your quota needs, although I see many potential problems: - The mysql daemon needs to have access to the files. An easy solution is to chgrp mysql

Very bad bug on FreeBSD

2002-12-06 Thread Cedric Veilleux
Hi, I am running mysql 3.23.53 on FreeBSD 4.4. I compiled mysql from source with the following configure command: --prefix=/usr/local --localstatedir=/var/db/mysql Every now and then, the server seems to change its database directory to /var/tmp. When it happens, show

my InterBase vs mySQL benchmarks!

2001-05-17 Thread Cedric Veilleux
Hi, I am considering developing a project on mySQL or InterBase. I tried to find comparisons, benchmarks, etc, but found nothing... Could anyone point me to such documents? If anyone cares, I wrote a small PHP script to benchmark both DB.. it's really simple, but shows mySQL is faster all

Re: Large search engine

2001-03-24 Thread Cedric Veilleux
of red + 1 Thank you, Cedric Veilleux what you'll need is: 1 table with doc_ids (and perhaps document) 1 table with words 1 table which links words to docs 1 table which gives the position of a word in a doc. create table documents (doc_id integer primary key auto_increment, document

Large search engine

2001-03-22 Thread Cedric Veilleux
the search script will do all the job without sending any other queries. May get quite complicated but it should work, it may also be easier to process sun NEAR star (maybe this is easy to do with LIKE too, I don't know, but I saw nothing in the docs.) Thank you, Cedri