Thanks for replying. Your posts that I've found when searching for
FULLTEXT information have had great ideas. :-) Searching millions of
posts efficiently and effectively isn't easy. :-( Heh.
FULLTEXT does not scale very well once the files get bigger than your
RAM.
The redesign of the index
On Thu, 2003-08-21 at 20:21, Taylor Sittler wrote:
Is there any way to update table values based on values in another table?
For instance, given:
table (column1,column2..)
Table 1 (jobid, jobname)
Table 2 (person, jobid, jobname)
could I update Table 2, setting jobname=Table1.jobname
I apologize for this,
But how exactly do I that?
When I run a query that has a timestamp field, How can I query on just the
date. Time stamp puts in the min, hour, and sec. All I need is the year,
month, and day.
SELECT * FROM table_name WHERE date = '2003-08-25';
- Original Message
When I run a query that has a timestamp field, How can I query on just the
date. Time stamp puts in the min, hour, and sec. All I need is the year,
month, and day.
SELECT * FROM table_name WHERE date = '2003-08-25';
select * FROM table_name WHERE DATE_FORMAT(date,'%Y-%m-%d') = '2003-08-25
Hi!
terence == terence [EMAIL PROTECTED] writes:
terence Dear All,
terence Has the alpha release mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz
terence changed since April 12 2003? Just want to save myself a few hours
terence downloading...
terence I am putting it into production shortly,
I have the following index:
CREATE UNIQUE INDEX SongTopic_idx ON SongTopic(songTitle, artist, album);
Where songtitle, artist and album are varchar() columns.
It appears that this index is not case sensitive. Is that correct? If so,
how can I have it so that it is indeed case sensitive because
On Monday, August 25, 2003, at 03:26 PM, Dan Jones wrote:
[snip]
To make this a tad clearer, I have two tables: Title and Author.
Author
consists of the Author's name and an AuthorID. Title includes an
AuthorID from the Author table. Some of the Author's have been deleted
from the Author
I am coming across an annoying problem with a new InnoDB installation.
On a 4Gig RAM box, Mysql doesn't seem to want to grab the RAM I am
telling it to take.
I would like for it to try and use around 3 Gigs for its
innodb_buffer_pool_size, but it refuses to startup with anything greater
than 512M.
I use a very good book on SQL commands that was recommended in a class I
took. Its generic SQL but its helped me a great deal with MySql commands. it
called Teach Yourself SQL In 10 Minutes by Ben Forta. Each chapter should take
you about 10 minutes to read. Its a SAMS book and very
On Mon, 25 Aug 2003, Wendell Dingus wrote:
I didn't notice a reply to this when first posted. Surely someone has
stuffed a lot of memory into an Opteron or Itanium by now and knows the
answer. Is a 64-bit Malloc all that is necessary or does INNODB have to
specifically support more memory in
I'm trying to move a database from one machine to another. I dumped the
database and successfully loaded it on one machine, but I can't do it on
another machine.
I have the database set up. I created the user to access the database,
and gave all privs with grant option for that database. But when
On Mon, Aug 25, 2003 at 07:10:02PM -0400, Dan Jones wrote:
On Thu, 2003-08-21 at 20:21, Taylor Sittler wrote:
Is there any way to update table values based on values in another table?
For instance, given:
table (column1,column2..)
Table 1 (jobid, jobname)
Table 2 (person, jobid,
I already have mysql 4.0.13 running with all InnoDB tables. I am trying to use
my-huge.cnf since I have 4 gig RAM with 4 x 450 Mhz processes
In my MySQL data directory I have two ib_logfile files
-rw-rw 1 mysqlmysql5242880 Aug 26 01:55 ib_logfile0
-rw-rw 1 mysqlmysql
I have mysql 3.23.51-entropy.ch
I have never used a my.conf file other than to tell it one thing which is
datadir=/usr/local/mysql/data
I have a gig of memory and only apache runs on this machine. It is OS X
10.1.5. How can I tell how mysql is running, since I don¹t have any
variables set in
Marek Lewczyk wrote:
Hello,
Currently I'm testing my app using MySQL 4.1.0 version, and I have a
strange error during execution a union query.
(SELECT IF(_DAT.pri = null, null, ROUND(_DAT.pri/1.22)) AS pri_net,
IF(_DAT.pri = null, null, ROUND(_DAT.price*1)) AS pri_gross,
_DAT.cuid, _CUR.code FROM
* [EMAIL PROTECTED]
I tried the manual but cant make sense of it. How can we use
wildcards on selects?
select * from phrases where ph like '%who%';
--
Jon Haugsand, [EMAIL PROTECTED]
http://www.norges-bank.no
--
MySQL General Mailing List
For list archives:
Apart from my.cnf MySQL also provide you with
my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf.
Files whih are used for diferrent sizes of datadases. Check them out it can
help. if you find the conf you r looking for in one of the cnf file you just
have to rename it to my.cnf.
Vinay
Hi Gord,
I understood that searches in general arecase insensitive (but I might be
wrong of course).
Try to use the word BINARY when creating the table or when making a SELECT.
I am not sure how you would have to apply this to the index.
Best regards
Nils Valentin
Tokyo/Japan
2003 8 26
* Scott Haneda
I have mysql 3.23.51-entropy.ch
I have never used a my.conf file other than to tell it one thing which is
datadir=/usr/local/mysql/data
I have a gig of memory and only apache runs on this machine. It is OS X
10.1.5. How can I tell how mysql is running, since I don¹t have any
on 8/26/03 1:40 AM, Roger Baklund at [EMAIL PROTECTED] wrote:
* Scott Haneda
I have mysql 3.23.51-entropy.ch
I have never used a my.conf file other than to tell it one thing which is
datadir=/usr/local/mysql/data
I have a gig of memory and only apache runs on this machine. It is OS X
* Scott Haneda
[...]
* Roger Baklund
For information on the options files:
URL: http://www.mysql.com/doc/en/Option_files.html
[...]
Where do all my defaults come from if my.cnf only has
datadir=/usr/local/mysql/data
Like the link describes, there are multiple my.cnf files, mysql reads
Hi,
We've been running mysql for the last 20 months without any problems at all. However,
it just stopped with a Dr. Watson error on last Friday's evening when there was not a
single connection or scheduled process running. The mysql server version we have is
3.23.35a. The Stack Trace showed
on 8/26/03 2:05 AM, Roger Baklund at [EMAIL PROTECTED] wrote:
* Scott Haneda
[...]
* Roger Baklund
For information on the options files:
URL: http://www.mysql.com/doc/en/Option_files.html
[...]
Where do all my defaults come from if my.cnf only has
datadir=/usr/local/mysql/data
We've been running mysql for the last 20 months without any problems at all. However,
it just stopped with a Dr. Watson error on last Friday's evening when there was not a
single connection or scheduled process running. The mysql server version we have is
3.23.35a. The Stack Trace showed the
[EMAIL PROTECTED] wrote:
I do not think it is true that mirroring gives no performance benefit
(on a
well implemented controller). For reads, the raid controller can read
either copy of the data, so that effectively two reads can be in
progress
at the same time, doubling read
* Scott Haneda
[...]
That¹s where I am lost, I can see all these options in show variables;
However, I only have /etc/my.cnf, I do not have DATADIR/my.cnf, ~/.my.cnf
and as stated before, there is only a path to my data directory in
/etc/my.cnf
So I still wonder, where are all my other
Pretty much every time I post to mysql list, I get one of the below back,
what is this all about and how can I stop it...
Return-Path: [EMAIL PROTECTED]
Received: from moose.cs.indiana.edu (129.79.254.191) by hostwizard.com with
ESMTP (Eudora Internet Mail Server 3.2.1) for [EMAIL PROTECTED];
Anyone else get one of these for every post to this list?
Return-Path: [EMAIL PROTECTED]
Received: from hauda.pair.com (209.68.2.79) by hostwizard.com with SMTP
(Eudora Internet Mail Server 3.2.1) for [EMAIL PROTECTED];
Tue, 26 Aug 2003 02:43:34 -0700
Received: (qmail 39919 invoked by uid
gord barq [EMAIL PROTECTED] wrote:
I have the following index:
CREATE UNIQUE INDEX SongTopic_idx ON SongTopic(songTitle, artist, album);
Where songtitle, artist and album are varchar() columns.
It appears that this index is not case sensitive. Is that correct? If so,
how can I have it
On Tue, 26 Aug 2003 02:54:13 -0700
Scott Haneda [EMAIL PROTECTED] wrote:
Anyone else get one of these for every post to this list?
yes, every time I post an answer.
---
WBR,
Antony Dovgal aka tony2001
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives:
Bennett Haselton [EMAIL PROTECTED] wrote:
At 03:49 PM 8/25/2003 +0300, Egor Egorov wrote:
Bennett Haselton [EMAIL PROTECTED] wrote:
I found a way to do this before, but I didn't write down how I did it,
so I
don't remember it now. And I've searched http://www.mysql.com/doc/ in
vain.
Matt,
I fully agree that indexing short words and numbers is a necessity
sometimes. I'm processing legal text where abbreviations are widely used
and people want to search for chunks like:
Art. 234 Abs. 3 OR
and the search should also find occurrances of
Art. 234 OR
These are so
Carl B. Constantine [EMAIL PROTECTED] wrote:
I'm trying to move a database from one machine to another. I dumped the
database and successfully loaded it on one machine, but I can't do it on
another machine.
I have the database set up. I created the user to access the database,
and gave all
Scott Haneda wrote:
Anyone else get one of these for every post to this list?
Me too, but not they do spam the lists of MySQL AB :-( .
Jakob
^--
To Unix or not to Unix. That is the question whether 'tis nobler in the
mind to suffer slings and arrows of vast documentation or to take arms
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Sorry if this is a stupid question.
I'm running BK MySQL 4.1.1alpha, and I'm trying to talk to a table with a
charset of UCS2. (I'm mixing hebrew and latin-1 characters in it, and it
seems the best way.) - I'm talking to it from a program I'm
Asif Iqbal [EMAIL PROTECTED] wrote:
I already have mysql 4.0.13 running with all InnoDB tables. I am trying to use
my-huge.cnf since I have 4 gig RAM with 4 x 450 Mhz processes
In my MySQL data directory I have two ib_logfile files
-rw-rw 1 mysqlmysql5242880 Aug 26 01:55
* Roger Baklund
* Scott Haneda
[...]
How do I see the path for defaults-extra-file
That would be in an option file or at the command line when the
mysql daemon was started.
Sorry, that is not correct. The 'defaults-extra-file' option must be the
first parameter on the command line, see:
Anyone else get one of these for every post to this list?
yes, me too.
i informed the domain's postmaster 3 days ago, but no error message nor reply came
back yet. maybe we should just kick them off the list. (@list op)
--
Yves Goergen
[EMAIL PROTECTED]
Please don't CC me (causes double
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Pretty much every time I post to mysql list, I get one of the
below back,
what is this all about and how can I stop it...
Looks like, somehow, the Internet Oracle got subscribed. Maybe a virus
forged mail that
Hello,
I have just started a thread in
comp.databases.theory
with the subject
Is mysql a RDBMS ?
Of course it is not a RDBMS
It never was and will never be
It is an RDBMS as we all know ;-)
Hope some of you can take time to
Reply on the most important misunderstandings.
At present
Hi everybody,
I want to establish replication between multiple (currently three) servers.
Updates/inserts/deletes may happen on all of them. The idea I came up with
was to do a circle-replication. The problem with this is, that if one
server fails the rest may not get updates (until the server
I recently upgraded to 4.1 alpha (MySQL 4.1.0-alpha-standard-log) on
my Linux server, and came across a problem with a query that had been
working in 3.23 that no longer worked in 4.1a. I've simplified the
query to demonstrate the problem:
select trim(upper('foo')) regexp ('^foo$') as
* Victoria Reznichenko ([EMAIL PROTECTED]) wrote:
It means that user doesn't have ALTER privilege.
BUT, I've tried granting the user all privs in mysqlcc and it still
doesn't work. Looking at my other setup, the users look like they are
set up the same.
--
.''`. Carl B. Constantine
: :'
On Tuesday 26 August 2003 04:54, you wrote:
By client character set I assume you mean what do I type into mysql?
utf-8. I think. How can I tell?
If you
- don't specify default-character-set in the my.cnf for the client
- don't run mysql --default-character-set=utf8
- don't execute SET CHARACTER
There are several people with this auto-responder crap going on.. all of
their emails should be de-listed in my opinion..
Here's my sendmail block list thusfar:
[EMAIL PROTECTED]:/] cat /etc/mail/access | grep notify
[EMAIL PROTECTED] REJECT #notify
[EMAIL PROTECTED] REJECT #notify
Ed Leafe [EMAIL PROTECTED] wrote:
I recently upgraded to 4.1 alpha (MySQL 4.1.0-alpha-standard-log) on
my Linux server, and came across a problem with a query that had been
working in 3.23 that no longer worked in 4.1a. I've simplified the
query to demonstrate the problem:
select
Hi list:
I have the following partial result from an explain select:
| table| type | possible_keys
| key
I'm using MySQL 4.1 so how do I define case sensitive collation? Is it on
the columns or on the indexes?
Thanks.
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Case sensitive indexes
Date: Tue, 26 Aug 2003 13:18:19 +0300
gord barq [EMAIL PROTECTED] wrote:
I
On Tue, Aug 26, 2003 at 04:18:26PM +0200, Stefan Kuhn wrote:
Hi everybody,
I want to establish replication between multiple (currently three)
servers. Updates/inserts/deletes may happen on all of them. The
idea I came up with was to do a circle-replication. The problem
with this is, that if
On Tue, 26 Aug 2003, Victoria Reznichenko wrote:
Asif Iqbal [EMAIL PROTECTED] wrote:
I already have mysql 4.0.13 running with all InnoDB tables. I am trying to use
my-huge.cnf since I have 4 gig RAM with 4 x 450 Mhz processes
In my MySQL data directory I have two ib_logfile files
I wan to use a variable for the outfile file name in a select into clause. I am
doing something like:
set @fileName=/tmp/result.text
SELECT col1, col2 INTO OUTFILE @fileName
FIELDS TERMINATED BY ','
FROM test_table;
the interpreter dies at the @fileName...
if I exchange @filename with
Sometimes. I'm not sure why? It looks like some sort of advertisement.
On 26 Aug 2003 at 14:18, [EMAIL PROTECTED] wrote:
Sometimes. I'm not sure why? It looks like some sort of advertisement.
Since all these autoresponders got subscribed right about the time of
the Sobig outbreak, it would make sense that they were subscribed by
the virus. But is there some
What should I do to correct his?
Looks like a slippage in MySQl.
Using phpMyAdmin to correct this error.
- Forwarded message from -
Hi Dave, we get an error when we try to post or reply to any post on our
forums,,www.gamershaven.ca/Forums
mySQL query error: INSERT INTO
Use PHP Domain Administrator (ohoAdmin?) and Export the Table Select Table ,
Structure
-OR-
If you have SSH access, login and you can issue these commands:
mysql -p
USE yourdatabasename; (this is specified in includes/config.php, the
database you run your forum on)
DESCRIBE Table
Take a Hard
Asif,
now take the old log files from the safe place and put them back! That will
save your data.
The instructions about changing the size of the log files are the following:
http://www.innodb.com/ibman.html#Adding_and_removing
If you want to change the number or the size of your InnoDB log
We are currently running about 50 databases on MySQL 4.0.14. Occasionally
our users will get the error:
Couldn't select database. Message: Commands out of sync; You can't run this
command now Message Number: 2014
When this happens to one customer, it affects them all. We end up having to
Hi!
- Original Message -
From: Marc Slemko [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, August 26, 2003 6:56 AM
Subject: RE: 64-Bit and INNODB
On Mon, 25 Aug 2003, Wendell Dingus wrote:
I didn't notice a reply to this when first posted. Surely someone has
Hi!
We have only 2 GB of RAM in our SuSE Linux server, and I can allocate 1400
MB to the buffer pool.
Have you checked what
ulimit -a
says for the user running mysqld?
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
Hi,
Do you use PHP ? If so, which version is installed ?
Regards,
Jocelyn
- Original Message -
From: Free Grafton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 10:05 PM
Subject: How to Track error - Commands Out of Sync
We are currently running about 50
I'd have to say that things look fine in that regard.
core file size (blocks) 0
data seg size (kbytes) unlimited
file size (blocks) unlimited
max locked memory (kbytes) unlimited
max memory size (kbytes)unlimited
open files 1024
pipe size (512 bytes)
So take a look here :
http://bugs.php.net/bug.php?id=19529
and upgrade your PHP version, since it's fixed in PHP 4.3.x ;)
Jocelyn
- Original Message -
From: Free Grafton [EMAIL PROTECTED]
To: Jocelyn Fournier [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 10:23 PM
Subject: Re: How
Hey Folks
Hi there! My first post to the list ...
I am installing mysql 4.0.1-2 on a Redhat 8.0 workalike. I've installed the MySQL
server software, client software, but when I try to install the MySQL-bench...rpm, I
get the failed dependencies error, MySQL-DBI-perl-bin is needed.
I did a
First off to maybe make this easy on you, you do not need the
MySQL-bench rpm if you do not plan on using the benchmarking tools. It
is an optional install.
Otherwise, I do not think rpm cares about capitalization. I believe this
problem is discussed in the MySQL manual, and might have the
Hi guys
this question has probably been answered a million times but I can't seem to find
anything in the Archives:
I am trying to install mysql on XP to use with PHP for a web site that I am working on.
I have done everything that the books are telling me but I can't seem to get either
PHP
-Original Message-
From: Nathan Simms [mailto:[EMAIL PROTECTED]
The problem is that I need my statement to search the
product_name and
description fields as well. However when I add them to my
statement, it
doesn't work???
The statment below does not work:
SELECT
66 matches
Mail list logo
