Hi list:
I have the following partial result from an explain select:
| table| type | possible_keys
| key
Hello,
I am relatively new to MySql (4.0.14) but I have read through the relevent
documentation and am still confused about how row level locking behaves
with InnoDB tables.
I created a database with a single innodb table which has 2 columns, one
of which is indexed. The locking behavior I see w
Any hint where and how to get mysql 4.1.1?
Thanks
John
-Original Message-
From: Jon Haugsand [mailto:[EMAIL PROTECTED]
Sent: Monday, August 25, 2003 3:14 AM
To: '[EMAIL PROTECTED]'
Subject: Re: utf8 support
* John Li
> MySql 4.1 should have utf8 charset support, I downloaded the alpha
> -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:
>
> SELE
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 o
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 solut
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 sear
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:
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) 8
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
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
Inno
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
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
restart
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 f
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 loo
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 ib
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 wa
Sometimes. I'm not sure why? It looks like some sort of advertisement.
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 "/tmp/re
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 fil
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,
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:
Hi list:
I have the following partial result from an explain select:
| table| type | possible_keys
| key
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:
>
>
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
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 CHARACTE
* 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
: :'
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 trimUpp
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
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 th
> -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 a
> 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 ma
* 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
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:
-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 d
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
aga
"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
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 commo
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/d
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: http://lists.mysql.com/
"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
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 30
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]>;
* 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
> [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
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 fol
on 8/26/03 2:05 AM, Roger Baklund at [EMAIL PROTECTED] wrote:
> * Scott Haneda
> [...]
>> * Roger Baklund
>>> For information on the options files:
>>>
>>> http://www.mysql.com/doc/en/Option_files.html >
> [...]
>
>> Where do all my defaults come from if my.cnf only has
>> datadir=/usr/local/mys
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 th
* Scott Haneda
[...]
> * Roger Baklund
> > For information on the options files:
> >
> > 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 re
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
* 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 hav
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月
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
* [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: http://lists.my
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 FR
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 my.
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 mysqlmysql52
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 1 (jobid, jobname)
> > Table 2 (person, jobid, jobname)
> >
> >
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, 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
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 some other fashion? Heikki? Thanks in
advance!
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 inexpensiv
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.
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 tab
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
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 producti
> 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
67 matches
Mail list logo
