I have created a table as follows but i was not able to use full text search on
a specific data.
create table racebike (id int auto_increment not null primary key, name
varchar(10), user text,fulltext(name,user));
The table is as follows,
++-+-+
| id | name|
At 07:07 AM 11/4/02 -0800, Jeremy Zawodny wrote:
>On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote:
>>
>> We get the same thing on FreeBSD machines quite often, and it's not
>> related to the actual work being done; MySQL can sit idle but use up
>> all CPU. It happens after a
I have a message board app I'm using where I'm trying to make the code
faster and more efficient than it is now. At times this board will
generate a lot of new posts to it very very quickly. In one section where
posts are added, after the post is made and inserted into mysql, we need to
get the
I noticed in the changelog for mysql 4.0.2 that it now
Use index for ORDER BY in queries of type: SELECT * FROM t WHERE
key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC
Very cool, I need this. Question though, when creating indexes, do we need
to somehow specify desc in the index or does my
Heikki, does this bug affect all versions or just the -max windows
versions... we just installed 4.0.3-beta (unix-freebsd) to do some
benchmarking/testing tonite on innodb and this would impact us. Thx.
>Rafa,
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>Newsgroups: mailing.datab
Hi all, I've been reading a bit on the innodb table type for mysql here and
on the site and some other board sites and just wanted to ask a quick
question or two in general about it, as it relates mostly to message boards
and compared to myisam. Is the only gotcha in forum code generally the
selec
Hi, There are of course several ways of doing it !!
I had to do this kind of thing few weeks ago, and I think the easier way of
doing it is use a treepath schema in a field of your table
+++---+
| id | treepath | name |
+++---+
-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 11:32 AM
To: [EMAIL PROTECTED]
Subject: Re: Backing up/Creating new database
PR,
Monday, May 13, 2002, 5:47:23 PM, you wrote:
P> I have database developed on my laptop. What is the quickest way to
P> backup the
Hi,
I have database developed on my laptop. What is the quickest way to
backup the database and restore it on the server? Can I restore the
database as empty database? Howa bout creating SQL statements based on
the database structure?
Thanks
--
I'm not sure where else to look to try and figure this out, I hope someone
can help. I'm running this mysql on a 4.3 freebsd box, dual cpu with two
mysql daemons (both 3.23.40). One of the daemons is specifically set up
for my highest volume database and the other runs 3 or 4 other db apps.
For
When doing a select that is ordered by a column that is indexed and has a
limit, does mysql not use the index if the order by is descending?
Here's an example:
select parent,number,lastpost from posts where topic=1 and board='abc' and
approved='yes' order by lastpost desc limit 9,12
My app is a
I was wondering if anyone could point me to a message board (perl or php)
that has a very efficient database design to handle threaded views. I know
that this is a difficult task under mysql and have seen the threads on
recursive queries, but I'd like to find some real life examples rather than
s
>second delays, did you compile mysql yourself or use a pre-compiled
>binary...
>
>Sid
>
>
>
>> -----Original Message-
>> From:PR [SMTP:[EMAIL PROTECTED]]
>> Sent:Sunday, August 19, 2001 4:28 PM
>> To: [EMAIL PROTECTED]
>> Subject:
I'm having a problem with my server getting bogged down once in a while and
I'm pretty sure it's due to the mysql daemon getting maxed out with what it
can do... when this happens there might be anywhere from 100 to 150
processes in the processlist and it might take as much as 30 seconds to
return
14 matches
Mail list logo
