So, based on this article, they were looking for a coder in April of this
past year. Did anyone start working on it? Does anyone know the status of
the project?
Tim Gustafson
FalconSoft, Inc
[EMAIL PROTECTED]
http://falconsoft.com/
(831) 425-4522
(831) 621-6299 (Fax)
- Original Message -
Hi,
Till MySQL 5.0 there was no support for FULLTEXT by InnoDB. More info on:
www.innodb.com/innodbtalkUC2005.pdf
Thanks
ViSolve DB Team.
- Original Message -
From: "FalconSoft, Inc" <[EMAIL PROTECTED]>
To:
Sent: Thursday, November 09, 2006 6:28 AM
Subject: InnoDB + FULLTEXT
> Doe
Hi,
Is it possible to access the Full-Text Index structures from SQL?
Thanks a lot,
Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi, I constantly keep receiving this kind of error:
mariuszlenks-ibook-g4:~ mariuszlenk$ cd /usr/local/mysql
mariuszlenks-ibook-g4:/usr/local/mysql mariuszlenk$ sudo ./bin/mysqld_safe
Password:
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file
./bin/mysqld_safe: line 1
It's my understanding that a PK in MySQL is basically the same as a
unique index -- for MyISAM tables at least. For InnoDB it's a bit
different with InnoDB storing rows within the PK index (and inserting
a hidden PK if none is provided).
In short: I don't think you'll see any better perfo
On Wed, Nov 08, Jon Frisby wrote:
> On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
>
> >
> > Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
> >
> > Performance issues? In mysql, in general?
> >
> > Yes, in the context of the application, there is a very good
> > reason for doing
Does anyone know if/when InnoDB will support FULLTEXT indexes? I have a
project that I'm working on now that really needs support for both.
Thanks!
Tim Gustafson
FalconSoft, Inc
[EMAIL PROTECTED]
http://falconsoft.com/
(831) 425-4522
(831) 621-6299 (Fax)
--
MySQL General Mailing List
For lis
This problem is driving me crazy. Please help.
127:~ mariuszlenk$ cd /usr/local/mysql
127:/usr/local/mysql mariuszlenk$ sudo ./bin/mysqld_safe
Password:
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute
Hi list,
I have a table with about 17 millons of records. This table
contain log of web for one month and I have an other table but with only
1 day of log.
If I do a select to get the log for this date 2006-01-01 :
Select * from mytable where mydate => '2006-01-01' and mydate <=
'
I'm curious to know why simply having a UNIQUE constraint on the
column is inadequate...
-JF
On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the application, th
Em Qua, 2006-11-08 às 12:53 -0600, Dan Nelson escreveu:
> "." within brackets is treated literally anyway, so there's no need to
> use "[.period.]".
OK, I had taken the effects of - as being the effects of .
> REGEXP BINARY '^wa[bhkl][-_.acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*'
On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote:
> > > u.login REGEXP
> > > '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*...
> > > But I get, among otherss, a string beginning with 'walt' (several, in
> > > fact).
> >
> > Probably MySQL don't know about th
According to the documentation, [.period.] should match but so should [...]
(if I read it right).
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Christian Hammers [mailto:[EM
In the last episode (Nov 08), Leandro Guimar~aes Faria Corcete DUTRA said:
> Em Qua, 2006-11-08 às 19:16 +0100, Christian Hammers escreveu:
> >
> > On 2006-11-08 Leandro Guimar~aes Faria Corcete DUTRA wrote:
> > > u.login REGEXP
> > > '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][2
Em Qua, 2006-11-08 às 19:16 +0100, Christian Hammers escreveu:
>
> On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote:
> > u.login REGEXP
> > '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*'
> ...
> > But I get, among otherss, a string beginning with 'walt' (sever
On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote:
> u.login REGEXP
> '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*'
...
> But I get, among otherss, a string beginning with 'walt' (several, in fact).
Probably MySQL don't know about this "[.period.]" thing and
I must have understood something wrong in the regexps docs:
SELECT
login
FROM
orolixMain.Usersu
WHERE
u.login REGEXP
'^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*'
;
[EMAIL PROTECTED](none)> \. usr/src/oro/qry/phshr.sql
+-
Depends on the value of your data, and what you might want to invest
in cluster setup (time, money) to get this done.
Another simple option from a hardware perspective might be the use of
a PCI card with RAM that serves as a Serial ATA disk. They're
relatively new on the market but they're out t
Sorry, Microsoft SQL!
From: "Panos Tsapralis" <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2006 6:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Undelete a droped table
I suppose you mySQL - not mSQL (there
I suppose you mySQL - not mSQL (there was a lite RDBMS once named mSQL - I
don't know whether it exists any more...).
On 11/8/06, scott <[EMAIL PROTECTED]> wrote:
As a note: mSQL has an attach function that will allow you to take those
files and recreate the database by only giving it the datab
Good morning, Steffan -
Can you post some details about what you mean when you say the tables
are damaged? What makes you say that / what are the signs/symptoms?
Does the server process crash, or stop responding? Do you see
anything in the error logs? Do you have enough disk space for temp
ta
As a note: mSQL has an attach function that will allow you to
take those files and recreate the database by only giving it the database name
and the file names. It's a way to put back a backup made of the physical
database if you backup directly from the SQL data directory and n
Maybe I should just be looking at using a HEAP table?
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
Depending on the characteristics of the data and baring dependencies on
specific features like FKs or complex JOINs, you may want to take a look at
MySQL Cluster.
MySQL Cluster supports in-memory and disk-based databases. So, it may give
you the high-performance characteristics you are loo
We have an intense data process that runs every few minutes, clearing
and then loading a database with thousands of records of data, which are
then queried on from a website. The periodic load takes about 20
seconds. Some of the front end select queries take a second or two.
This is all runn
I am having an issue with MySQL running on Mac OS X. Currently the version
as stated 5.0.18 on a dual G4 Xserve with 1gb of ram. MySQL is mainly the
only thing running on this server. I am trying to track down an issue in
which MySQL is being overloaded and it consistently damages the same one or
t
Linux Redhat ASEL 4.0
On 11/8/06, Visolve DB Team <[EMAIL PROTECTED]> wrote:
Hi
Actually I don't get any idle processes listed.. but have came across such
mails..
On which platform you are running mysql?
I guess this might be:
If Windows, the server will drop the connection probably because
Hi
Actually I don't get any idle processes listed.. but have came across such
mails..
On which platform you are running mysql?
I guess this might be:
If Windows, the server will drop the connection probably because of
'wait_timeout' expired.
For others, the mysql gets reconnected with 'reconne
28 matches
Mail list logo
