I'm able to index 600,000 records in about 5 to 6 minutes on a dual PII
450
running Win2K and MySQL 4.0.0a
Similar stucture
ID
Title
Description
Indexing Title and Description.
On Wed, 2002-01-09 at 20:26, Jon Shoberg wrote:
>
> I have a simple table with A LOT of data, 2.1M rows. this is p
On Sat, Jan 12, 2002 at 11:42:57PM +0100, Carsten Gehling wrote:
> Then maybe you can tell me how I should tune the server? You know
> make it use more memory, and thereby performing better? It's
> probably a FAQ, if so just post a URL to a guide.
Hmm. You might be interesting in reading this:
On Fri, Jan 11, 2002 at 08:08:51AM -0800, Kyle Hayes wrote:
> We write our own replication system using our own checkpointing and
> code. We start with the update logs (we're not happy about the
> future removal of the update logs because of this). I've looked
> through the MySQL source to see
Hello everyone,
I currently have a webserver and a database server that is running red hat
7.2 and I am learning MySQL. I was just wondering, does anyone want to
host their database on my server, it's free and strictly for training
purposes. The reason for this is because I want to learn how
Hello everyone,
I currently have a webserver and a database server that is running red hat
7.2 and I am learning MySQL. I was just wondering, does anyone want to
host their database on my server, it's free and strictly for training
purposes. The reason for this is because I want to learn how
On Sat, 12 Jan 2002, Tom Jones wrote:
> >Table: flights
> >Fields: depart, depart_time, arrive, arrive_time, flight_no, flight_group
>
> I'm trying to do a search on "depart" and "arrive" and show only the records
> which have matching "flight_group"
SELECT depart, arrive
FROM flights
WHERE
At 16:46 12/01/02 -0800, Mark Peterson wrote:
>I'm having trouble with the installation of MySQL. The database was
>installed on the "C" drive.
Please follow the steps below:
- The instructions below assume that you have opened a prompt
screen at c:\mysql\bin directory.
- After a boot, open
I disagree. The 4GB slowdown is usualy caused by indexing problems
associated with the OS having increased overhead when looking up and
inserting data. I have eliminated this slowdown in Solaris and Linux be
re-indexing the entire database once it becomes larger then 4GB. This
fixes the problem
The size limitation is becauseof the operating system parameters. In
order to use tables larger then 3 GB, use either Redhat 7.2 or Solaris 8.
These operating systems allow file sizes greater then 2 GB. For the most
part I achievedtables sizes using these operating system of greater the 50
GB.
I'm having trouble with the installation of MySQL. The database was
installed on the "C" drive.
After installation, I performed the following tests to ensure that the
database was properly installed: I execute the "mysqlshow" command and the
names of the "test" and "mysql" databases were displaye
Wow, our posts crossed in the mail and you suggested the same approach that
I discovered independently!
(Great minds think alike, right?)
I'm working remotely, the server is many states away, and I don't have a
local developement environment. I'm modifying the actual working site,
though I try to
I'm facing an interesting data recovery challenge after a malicious hack
last week. It seems all the hacker did was log in to the machine and
"rm -rf /" and despite being assured backups were taken off-site daily it
seems that the only surviving full backup of the MySQL data files is from
August
I'm going re-post this query. Roger Backlund had been attempting to help me
but I've either stumped him or he's busy having a life :) Besides, my
first posting had several problems, since I was working from memory.
Finally, in the process of preparing this query, I found a small change
that
> I'm going to send direct from the programming computer, using a different
> e-mail address.
Ok, I reply to the list, but CC to you. Think I found your problem...
> I did find that I had one invalid foreign key value in table A, but my
> problem remains...
>
> I tried this:
>
> Database PosenL
On Sat, 12 Jan 2002 17:06:36 -0600, jerry wrote:
>Hi-
>
>Anyone know what web.mysql.com is doing? It's from a netstat on a
>RH 7.2
>running mysql 3.23.47
>
>myhost.mydomain:4570 web.mysql.com:auth TIME_WAIT
>
>Thanks-
>
>
this is the list sending you mail
-z
sql mysql
---
off topic topic of mysql databaseperl
i need to know how to build a linux timestamp from a date given to me in
the following format 01-18-99 (m-d-y) i am using mysql to store this as an
int(11).
i know php has a mktime function, does anyone know if perl has something
similar?
> Hello,
> I've been trying to figure this out but I feel like I'm just
> banging my head
> on the wall.
That must be quite painful...
> I hope this is the right forum to pose this question.
It's certainly one of the better ones, yes.
> I have a table of flights which has several fields
>
> >T
Hello,
I've been trying to figure this out but I feel like I'm just banging my head
on the wall.
I hope this is the right forum to pose this question.
I have a table of flights which has several fields
>Table: flights
>Fields: depart, depart_time, arrive, arrive_time, flight_no, flight_group
I
Hi-
Anyone know what web.mysql.com is doing? It's from a netstat on a RH 7.2
running mysql 3.23.47
myhost.mydomain:4570 web.mysql.com:auth TIME_WAIT
Thanks-
-
Before posting, please check:
http://www.mysql.com/
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
Sent: Saturday, January 12, 2002 11:23 PM
> In the last episode (Jan 12), Carsten Gehling said:
> > Maybe it's just me, but I find that my mysqld proccesses consume
> > quite a lot of memory. 7584 KB each to be exact.
>
> 7 MB i
In the last episode (Jan 12), Carsten Gehling said:
> Maybe it's just me, but I find that my mysqld proccesses consume
> quite a lot of memory. 7584 KB each to be exact.
7 MB is nothing. I'm amazed you get any performace at all out of that,
since it can't have any cache. Is this reported from p
Maybe it's just me, but I find that my mysqld proccesses consume quite a lot
of memory. 7584 KB each to be exact.
I've installed MySQL using the RPM on mysql.com (and I don't use the MAX
version). I haven't made any config file, just installed it and let it run.
Can I do anything about it? It's
Oops! And switch "=" to "like" and add quotes:
$sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name like '%$sname%' ");
$sth->execute();
- Original Message -
From: "Douglas Forrest" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 12, 2002 4
No closing quotes in prepare.
Also, I've never seen code that's looks quite like that; this may be
cleaner:
$sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name=%$sname%");
$sth->execute();
- Original Message -
From: "Dan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturda
Per Moisdon a écrit :
>
> I'm sorry but I can't connect to mysql.
> I work on Linux SuSe 7.2 and Mysql version is 3.23.37.
> I installed it with Yast2 from the package of the SuSe distribution.
> I can't start the daemon and of course I can't connect (localhost) the
> server.
> I join the error f
Hi!
Two-way replication is complex, and even more difficult is coping with
broken communications.
MySQL only supports one-way replication (master -> slaves). Auto-inc column
values are communicated in the binlog to the slaves.
Some ideas:
- Generate primary keys where you concatenate the id of
* =James Birkholz=
> In a message dated 1/12/02 10:48:45 AM Central Standard Time,
> [EMAIL PROTECTED] writes:
> ---snip---
> << SELECT A.Name, B.Name, P.ID
>FROM Persons P
>LEFT JOIN QualityA A USING(A_ID)
>LEFT JOIN QualityB B USING(B_ID)
>WHERE P.ID = thatGuy; >>
> ---snip---
>
In a message dated 1/12/02 10:48:45 AM Central Standard Time,
[EMAIL PROTECTED] writes:
---snip---
<< SELECT A.Name, B.Name, P.ID
FROM Persons P
LEFT JOIN QualityA A USING(A_ID)
LEFT JOIN QualityB B USING(B_ID)
WHERE P.ID = thatGuy; >>
---snip---
That doesn't work, get an error as it
* Dan
> Can someone tell me what's wrong with this code:
>
> $sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name=?);
>
> $sth->execute("%$sname%");
You should use the LIKE operator:
Name LIKE "%roger%"
http://www.mysql.com/doc/S/t/String_comparison_functions.html >
--
Roger
--
James,
> I'm new to the list, to mysql and to dynamic website programming. I'm not
> new to programming, had my nose in Access97 for the last few years, off and
> on. So I'm used to being coddled with sql and can't find a syntax that
> works for this situation:
>
> (I'm using phpMyAdmin to work
[EMAIL PROTECTED] writes:
> >Description:
> When I query using
> "SELECT d1.document_id as document_id_1, d2.document_id as document_id_2,
>sum(d1.weight * d2.weight) as similarity FROM dw_merge as d1 INNER JOIN dw_merge as
>d2 ON d1.word_id=d2.word_id WHERE d1.document_id=5 AND d1.weight >
Hi Travis,
> I have the database files, now how do I put them back into mysql?
mysqlhotcopy simply copies the data files to another directory. To restore
them, terminate the mysql server and then copy the files back to the mysql
data directory (e.g. /var/lib/mysql/).
Note that mysqlhotcopy fails
mysql and Perl
Can someone tell me what's wrong with this code:
$sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name=?);
$sth->execute("%$sname%");
$dname = $sth->fetchrow_array;
$names is supposed to be a substring. So if I want to search for a middle
name or just a first name or even a
Trond Eivind Glomsrød writes:
>
> We used to do that, but got complaints:
> https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=51711
>
> It wreaked havoc on bin-logs.
>
> OTOH, we need to be able to have scripts controlling the DB as root,
> while not needing to have a passwordless DB accoun
Jeremy Zawodny writes:
> On Fri, Jan 11, 2002 at 11:54:26AM -0500, [EMAIL PROTECTED] wrote:
> >
> > Any suggestions on loging tools I cna run to try to find out more
> > information? The machine is coloced about 3 hours for me, so I would
> > hate to have to drive there and install FreeBSD on it,
I'm new to the list, to mysql and to dynamic website programming. I'm not
new to programming, had my nose in Access97 for the last few years, off and
on. So I'm used to being coddled with sql and can't find a syntax that
works for this situation:
(I'm using phpMyAdmin to work with the database an
Therrel Griffin writes:
> Just wanted to know if anyone has compiled MySQL under QNX, and if they
> did, how they did it. Any help would be appreciated.
> Therrel
>
MySQL can be built on QNX 6.* with GNU tools.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa
Hi!
On Jan 09, Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC wrote:
>
> Hello
>
> Recently we have installed mysql ver 4.0.1(from
> binaries).We loaded about 1.6 million records in a table.
> One of the fields 'ti' is text field. We created fulltext
> index on this fie
Aaron Brick writes:
> hi all,
>
> in debian, the /etc/init.d/mysql script waits for the appearance of
> /var/run/mysqld/mysqld.pid to conclude that the server has started. since
> the red hat init script does not do that, my program's own installer has to.
> however we have had a report that wait
Hi!
On Jan 07, Jason Kushmaul wrote:
> I have changed a fulltext variable ft_min_word_len from the default 4 to
> 1, and the manual says to rebuild my fulltext indexes once again.
> I verified that this variable changed with SHOW VARIABLES and it did change.
>
> I have tried optimize table, ana
* Carl Troein
> CREATE TABLE t1 (txt varchar(10) default NULL);
> INSERT INTO t1 VALUES ('aaa');
> INSERT INTO t1 VALUES (NULL);
> SELECT BINARY txt AS t FROM t1 GROUP BY t;
FYI:
I tried this on my win2000 3.23.30-gamma server, it crashed.
If I remove "BINARY" or "GROUP BY t", it does not crash
Matthew,
Posting simple questions, even different people repeatedly posting simple questions is
NOT spam. It may be a problem for some people, but it is not what this discussion is
about.
Spam is people not interested in MySQL at all posting a "Business opportunity" ("Dear
mysql, Join today f
When i try to login to database (success) it breakes down. Maybe you fix it?
Dmitri
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Becky McElroy writes:
>> Two questions regarding multi-table operations:
>>
>> 1) I've got multi-table delete working with a couple of BDB tables,
>> where it's properly deleting from one or both tables, and all
>> po
At 12:13 12/01/2002 +0100, Carl Troein wrote:
Hi!
Thanks you for the bug report I was be able to repeat
in the 4.0.1 Windows release too.
Regards,
Miguel
>CREATE TABLE t1 (txt varchar(10) default NULL);
>INSERT INTO t1 VALUES ('aaa');
>INSERT INTO t1 VALUES (NULL);
>SELECT BINARY txt AS t FROM t
Hours after I left this mailing list, I found a bug
in 3.23.47. Since it's so easy to reproduce the bug here,
I'll let this example speak for itself:
CREATE TABLE t1 (txt varchar(10) default NULL);
INSERT INTO t1 VALUES ('aaa');
INSERT INTO t1 VALUES (NULL);
SELECT BINARY txt AS t FROM t1 GROUP B
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Ken Menzel writes:
>> >From show status (in mysql 4.0.1)
>> | Com_select | 192446|
>> | Questions| 121881|
>>
>> Why are there more selects than the total number of questions? Is
>Description:
When I query using
"SELECT d1.document_id as document_id_1, d2.document_id as document_id_2,
sum(d1.weight * d2.weight) as similarity FROM dw_merge as d1 INNER JOIN dw_merge as d2
ON d1.word_id=d2.word_id WHERE d1.document_id=5 AND d1.weight > 0.05 AND d2.weight >
0.05 GROUP
Hello all,
Please advise location of the toc.
Kind reagrds
Emmanuel
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: 10 January 2002 16:59
> To: Rick Emery
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: Jeremy's MySQL Book
>
>
> On Thu, Jan 10, 2002 at 08:32:03AM
49 matches
Mail list logo
