Re: BSDI 4.2 and Mysql

[Husri Hassan]

Ok, thanks Carlos M. Gutierrez
I got another error as below:

mysql\""-DHAVE_CONFIG_H
-I./../include  -I./../regex-I.
-I../include -I.. -I.-O3 -DDBUG_OFF   -fno-implicit-templates
-fno-exceptions -fno-rtti  -c sql_yacc.cc
sql_yacc.yy:5250: virtual memory exhausted
gmake[3]: *** [sql_yacc.o] Error 1
gmake[3]: Leaving directory `/var/src/mysql-3.23.46/sql'
gmake[2]: *** [all-recursive] Error 1
gmake[2]: Leaving directory `/var/src/mysql-3.23.46/sql'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/var/src/mysql-3.23.46'
gmake: *** [all-recursive-am] Error 2

-husri

"Carlos M. Gutierrez" wrote:

> On Wed, 5 Dec 2001, Husri Hassan wrote:
>
> > Got the below error messages when i run make command:
>
> If I recall correctly, you need to use 'gmake' instead of 'make' on BSDI.
>
> > make: don't know how to make mi_test_all. Stop
> > *** Error code 1


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: help with timestamp...

[Kodrik]

> At 11:25 PM 12/4/01 -0700, *Himerus* wrote:
> >Can anyone give me a good link on how to put in a timestamp on a form
> >that inserts directly into a sql database??? I keep trying it, but it's
> >only coming thru as 00 , so on.

I enter my timestamp as a unix timestamp in an INT field.
I have never encounter a case where the mysql time functions were a benefit, 
on the contrary.

I get the unix timestamp from the program but I think mysql could generate it 
as well.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mac OSX and MySQL

[Robert Alexander]

At 22:24 -0700 2001/12/04, René Fournier wrote:
>The migration continues...
>
>Now I have to get my mysql database running under MySQL 3.23.46 on 
>OSX 10.1.1. I've dumped the structure and contents of the database 
>(on Windows) into a text file, and now I'd like to recreate it in 
>the new enivronment. I think I can use the mysql admin tools via 
>command line (but really, what is the syntax for piping a 'dumped' 
>database into a new database? "mysqladmin create database < 
>dumpeddb.sql"??), but one question about users...


Allo René,

Depending on the command you used to dump the data, the table 
creation commands will already be in the mysqldump file. You can look 
at it with a text editor.

Your guess was almost right. :>  To bring the dump into your new 
database, just do:

mysql database_name -p < backup_file.sql

The '-p' will prompt for your password.

There's a bunch of good info in the manual about this. Check out 
"4.8.5 mysqldump, Dumping Table Structure and Data."


>I have to create a MySQL for my PHP scripts. How do I do this in Mac 
>OSX? There are a bunch of command line tools, but I'm not sure which 
>one[s] to use.

Not sure I understand this question.  What do you mean by "create a 
MySQL for my PHP?"


>Thanks.
>
>...Rene

Hope this helps,

/Rob

~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca   416-823-6599
mailto:[EMAIL PROTECTED]

"Life's unfair - but root password helps!"

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

how to import oracle db to mysql

[srinivas]

hi there,

how to import oracle db to mysql.
can somebody help me.

regards

srinivas 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: help with timestamp...

[Jaime Teng]

Hi,

Depends on what type of timestamp you are looking at. But
in general, you use the mysql built in function:
now() and if you want to convert that into unix_timestamp,
unix_timestamp(now()) will do the trick.


mysql> select now();
+-+
| now()   |
+-+
| 2001-12-05 14:31:06 |
+-+

mysql> select unix_timestamp(now());
+---+
| unix_timestamp(now()) |
+---+
|1007533917 |
+---+

REPLACE formtable VALUES (now(),data here);
or
REPLACE formtable VALUES (unix_timestamp(now()),data here);

jaime


At 11:25 PM 12/4/01 -0700, *Himerus* wrote:
>Can anyone give me a good link on how to put in a timestamp on a form
>that inserts directly into a sql database??? I keep trying it, but it's
>only coming thru as 00 , so on. 
>
>
>Thanks.
>Newbie Jake.
>
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> 
>
>

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

help with timestamp...

[*Himerus*]

Can anyone give me a good link on how to put in a timestamp on a form
that inserts directly into a sql database??? I keep trying it, but it's
only coming thru as 00 , so on. 


Thanks.
Newbie Jake.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

BSDI 4.2 and Mysql

[Husri Hassan]

Hi,

Got the below error messages when i run make command:
- OS : BSDI 4.2
- MYSQL : mysql-3.23.46 / mysql-3.23.40
- Machine : intel base.

Anybody can help us.

gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include -I..-O3
-DDBUG_OFF   -D__BSD__ -DHAVE_BROKEN_REALPATH -c resolve_stack_dump.c
/bin/sh ../libtool --mode=link gcc  -O3 -DDBUG_OFF   -D__BSD__
-DHAVE_BROKEN_REALPATH  -o resolve_stack_dump  resolve_stack_dump.o
../mysys/libmysys.a  ../dbug/libdbug.a
../strings/libmystrings.a -lz -lm
gcc -O3 -DDBUG_OFF -D__BSD__ -DHAVE_BROKEN_REALPATH -o
resolve_stack_dump resolve_stack_dump.o ../mysys/libmysys.a
../dbug/libdbug.a ../strings/libmystrings.a -lz -lm
Making all in regex
Making all in isam
Making all in merge
Making all in myisam
make: don't know how to make mi_test_all. Stop
*** Error code 1

Stop.
*** Error code 1

-husri


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mac OSX and MySQL

[René Fournier]

The migration continues...

Now I have to get my mysql database running under MySQL 3.23.46 on OSX 
10.1.1. I've dumped the structure and contents of the database (on 
Windows) into a text file, and now I'd like to recreate it in the new 
enivronment. I think I can use the mysql admin tools via command line 
(but really, what is the syntax for piping a 'dumped' database into a 
new database? "mysqladmin create database < dumpeddb.sql"??), but one 
question about users...

I have to create a MySQL for my PHP scripts. How do I do this in Mac 
OSX? There are a bunch of command line tools, but I'm not sure which 
one[s] to use.

Thanks.

...Rene

---
René Fournier
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Settings

[Robert Alexander]

Hi,

Take a look at the files:

-rw-r--r--   1 root other   2534 Oct 11 22:40 my-huge.cnf
-rw-r--r--   1 root other   2512 Oct 11 22:40 my-large.cnf
-rw-r--r--   1 root other   2496 Oct 11 22:40 my-medium.cnf
-rw-r--r--   1 root other   2211 Oct 11 22:40 my-small.cnf

found in the support-files directory in your MySQL installation (usually 
/usr/local/mysql/support-files) and read about the my.cnf file in the manual at:

4. MySQL Database Administration -> 4.1 Configuring MySQL -> 4.1.2 my.cnf Option Files.

This will give you a good start on setting up your server.

All the best,
/Rob


>What information would you need to recommend the initial settings for a
>MySQL server.  We are about to deploy a new server and move our website over
>to the server and I would like to have a somewhat optimized configuration
>from the start.  Let me know what you need, and I'll provide it.
>
>Thanks,
>
>P
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca   416-823-6599
mailto:[EMAIL PROTECTED]

"Life's unfair - but root password helps!"

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re: Problem with GROUP BY ... DESC

[Arjen G. Lentz]

Hi,

- Original Message -
From: "AJ" <[EMAIL PROTECTED]>


> > > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
> > > The problem that has cropped up I have is that in all GROUP BY column
DESC
> > > statements, the DESC is now not being recognized, and the query is being
> > > returned in ascending order.  If I use ORDER BY... DESC that works fine.
> >I'm seeing the same bug on 3.23.45 (and maybe others but I can't remember
> >all the versions I've played with recently).  It does the same thing where
> >it accepts the syntax but does not respect it (and returns rows in the
> >default ASC ordering).
>
> The problem is apparently solved if you kluge with e.g.
>  select field, count(field) from table group by field order by field
desc
> but it IS a kluge.

That wouldn't not be a kludge actually, since the SQL-99 standard does not
allow ASC/DESC on GROUP BY at all.
It is an extention in the MySQL server (see
http://www.mysql.com/doc/S/E/SELECT.html), and basically it is a shortcut for
exactly what you describe: an ORDER BY with the same fields as the earlier
GROUP BY.

I tried it too on a 3.23, and indeed it does appear to not be working.
Contrary to what is described above though, there is no ordering at all in my
output, not ascending either. So basically it is as you would expect it to be
without any ORDER BY operation. Maybe the output others got was just sheer
luck, as it depends on the order the server reads the data rows

Anyway, I've sent a note to the developers about this, including a sample
reproducing it.


Regards,
Arjen.

--
MySQL Training Worldwide, http://www.mysql.com/training/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Technical Writer, Trainer
/_/  /_/\_, /___/\___\_\___/   Brisbane, QLD Australia
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Keeping track of database changes

[Steve Werby]

"Philip Molter" <[EMAIL PROTECTED]> wrote:
> We've got a fairly critical database system that we're setting up
> and we need to know if there's an easy way to track changes made
> to the database (hopefully at a fairly low level).
>
> In essence, what we want, is a log of what fields and values are
> changed by the primary key on each table, including timestamps of
> said changes.

mysqld can be started with several logging options.  Run "./mysqld --help |
grep log" for details (and read the manual).  Transactions are an option,
but I have no experience with them outside of PostgreSQL so I'll let someone
else touch on that.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Using c-isam calls to access MySQL ISAM data files

[Tobias Crush]

Hi All,

We am currently investigating the possiblity of migrating a legacy app from
Informix C-ISAM files to MySQL.  To do this we are looking to be able to
retain the core application code as unchanged as possible.

What we want to do is be able to develop a new front end that accesses the
data through the normal MySQL channels AND use the existing legacy
application code to access the datafiles directly as they currently do.

Has anyone attempted to run a MySQL database with updates occuring through a
front end accessing the database through the regular database managment
engine and direct file updates happening from legacy code in the background?
Is it possible.

Thanks for your help.

Tobias Crush
Senior Consultant
Partnership Technology Group




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL access denied from localhost

[Arjen G. Lentz]

Hi,

- Original Message -
From: "mweb" <[EMAIL PROTECTED]>


> I know this is a probably a FAQ, and have read
> http://www.mysql.com/doc/A/c/Access_denied.html, but everything looks OK to
> me. If I look at the mysql db from the monitor I get all the privileges OK
> for user "testuser"

Log in as root and do
SHOW GRANTS FOR testuser@localhost;
This will show you all the info used by the server for that user@host
combination, which should be easier to read than the raw grant tables.
Consider that the server sorts the entries by host, with the most specific
host entry first (i.e. wildcards come last).

A few notes:
- User=" " (blank) is not recommended: corresponds to ALL (any) users. Should
only be used for testing.
- Do set up and use passwords for all users.
- And if you edit privileges directly in the mysql db tables, you have to do
FLUSH PRIVILEGES to have the server reload that info; if you use GRANT/REVOKE
statements, that is not necessary.


Regards,
Arjen.

--
MySQL Training Worldwide, http://www.mysql.com/training/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Technical Writer, Trainer
/_/  /_/\_, /___/\___\_\___/   Brisbane, QLD Australia
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

databases without passwords

[esp5]

hey,

I was wondering if it was possible to have a database that has users - but no
passwords. Furthermore, I'd like the default user that starts up with mysql to 
be the unix/winnt user.  (The database that I'm using is not mission critical -
its more a 'scratchpad' database than anything else)

Any help on this would be greatly appreciated..

Ed

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Settings

[Marc Pozzuoli]

What information would you need to recommend the initial settings for a
MySQL server.  We are about to deploy a new server and move our website over
to the server and I would like to have a somewhat optimized configuration
from the start.  Let me know what you need, and I'll provide it.

Thanks,

P


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem with ASP + mySQL

[ST Ooi]

I think the query should be as below

SELECT Min(Col1) as Col1, Col2 FROM Table1 GROUP BY Col2

then somewhere in your page,

response.write(rs("Col1"))

Thanks

ST Ooi
Malaysia

- Original Message -
From: "Jimmy44 --" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 05, 2001 5:39 AM
Subject: Problem with ASP + mySQL


> Dear all,
>
> I am having the following problem with ASP + mySQL
> Actually, when executing the following Query:
> SELECT Min(Col1), Col2 FROM Table1 GROUP BY Col2
>
> I get an empty recordSet, while executing the following query doesn't
return
> an empty recordSet:
> SELECT Col1,Col FROM Table1 GROUP BY Col1
>
> I am connection using:
> RS.Open SQLQuery, Connection
>
> Can someone help?
>
> Thanks,
>
> Jimmy
>
>
>
>
>
>

__
> Send a friend your Buddy Card and stay in contact always with Excite
Messenger
> http://messenger.excite.com
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Why can't I get SORT BY to work with FULLTEXT?

[Sergei Golubchik]

Hi!

On Dec 04, Mark J. Degallier wrote:
> If I run this query it works:
> SELECT * FROM products WHERE (MATCH
> (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('anystring'))
> 
> But if I run this query it does not:
> SELECT * FROM products WHERE (MATCH
> (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('anystring')) ORDER
> BY 'item_no'
> 
> Is ORDER BY allowed with this type of query?

Yes, ORDER BY is allowed.
(mysql-test/t/fulltext_order_by.test can be used a s proof)

If you'll provide us with more info I'll be able to explain
what's going wrong.

By the way, why did you put item_no 'in quotes' ?
If they're present in your original query - it's a mistake.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: innodb vs myisam optimizations

[Sergei Golubchik]

Hi!

On Dec 04, Gurupartap Davis wrote:
> I'm converting a table to innodb from myisam in mysql 4.0 and I was
> wondering why it takes sooo long to do a SELECT COUNT(*)

MyISAM stores total number of rows in MYI file header.
It's read into memory when table is opened.

So for SELECT COUNT(*) FROM MyISAM_table
NySQL need not acess data or even index - it can return an
answer immidiately.

InnoDB doesn't store total number of rows anywhere (afaik).

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Why can't I get SORT BY to work with FULLTEXT?

[Mark J. Degallier]

If I run this query it works:
SELECT * FROM products WHERE (MATCH
(title,short_desc,long_desc,spec_desc,item_no) AGAINST ('anystring'))

But if I run this query it does not:
SELECT * FROM products WHERE (MATCH
(title,short_desc,long_desc,spec_desc,item_no) AGAINST ('anystring')) ORDER
BY 'item_no'

Is ORDER BY allowed with this type of query?

Please Help!!

Thanks,
-Mark




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Can a function be called as a default?

[Rich Duzenbury]

3.23.43

It would be handy to be able to call a mysql built-in as a column 
default.  The reason this would be handy is that I could then go to my 
umpteen tables and just add one column and suddenly I could know who is 
changing each record.  Otherwise, I have to go to my umpteen x umpteen 
insert & update queries and change each one to store one more column.

I don't think it works, because I can't get the table to create...but if 
you know how, please let me know.

create table test (
   a int(10) not null auto_increment primary key,
   revision_date timestamp(14),
   revision_user varchar(10) not null default USER()
);

The above errors out at USER().  Of course, if I surround USER() in quotes, 
it is inserted as a literal, and not evaluated.


Regards,
Rich


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: 64bit mysql and gcc

[Ian]

Here is the 2.8 package I just downloaded from one of your mirror sites.

[reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> ls mysqld
mysqld*
[reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> file mysqld
mysqld: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, stripped

IW.


On Dec 4 Sinisa Milivojevic was rumored to have written:

> Ian writes:
> > I would be more than happy to.  Could you point me in the direction
> > of the binaries?  The ones that I have found have been 32bit DBs.
> > 
> > IW.
> > 
> > 
> > 
> 
> What makes you think that our Solaris 2.8 binaries are 32bit ??
> 
> -- 
> Regards,
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
> /_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
><___/   www.mysql.com
> 





Ian Waters

[EMAIL PROTECTED]/interesting.net/geekninja.net/geekcoop.com

PGP Public Key: 
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xFF7EE368



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

innodb vs myisam optimizations

[Gurupartap Davis]

I'm converting a table to innodb from myisam in mysql 4.0 and I was
wondering why it takes sooo long to do a SELECT COUNT(*)

In the old MyISAM table, it's quick:
mysql> select count(*) from forecast;
+---+
| count(*)  |
+---+
| 194698187 |
+---+
1 row in set (0.00 sec)

In the Innodb table, which has far less rows (it is still in the process of
being loaded) it's much slower:
mysql> select count(*) from forecast_avn;
+--+
| count(*) |
+--+
|  4815579 |
+--+
1 row in set (2 min 12.63 sec)

running EXPLAIN on the innodb table gives me this:
mysql> explain select count(*) from forecast_avn;
+--+---+---+-+-+--+-
+-+
| table| type  | possible_keys | key | key_len | ref  | rows
| Extra   |
+--+---+---+-+-+--+-
+-+
| forecast_avn | index | NULL  | PRIMARY |   4 | NULL | 1789719
| Using index |
+--+---+---+-+-+--+-
+-+
1 row in set (0.00 sec)

wherease the myisam table gives me this:
mysql> explain select count(*) from forecast;
+--+
| Comment  |
+--+
| Select tables optimized away |
+--+
1 row in set (0.02 sec)

So it looks like myisam's got some optimizations that innodb doesn't have.
What's weird, though, is that the row count on the index in the EXPLAIN
query is way off...I could run 'myisamchk --analyze'  on the myisam
tables...are there any optimization tools for innodb available?  If you
noticed the result from the first query above, you'll see that recreating
the table periodically is not much of an option.

Thanks

Partap Davis
Syncrasy, LLC




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Fwd: Re: Problem with GROUP BY ... DESC

[AJ]

> > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
> >
> > The problem that has cropped up I have is that in all GROUP BY column DESC
> > statements, the DESC is now not being recognized, and the query is being
> > returned in ascending order.  If I use ORDER BY... DESC that works fine.
>
>I'm seeing the same bug on 3.23.45 (and maybe others but I can't remember
>all the versions I've played with recently).  It does the same thing where
>it accepts the syntax but does not respect it (and returns rows in the
>default ASC ordering).

The problem is apparently solved if you kluge with e.g.

 select field, count(field) from table group by field order by 
field desc

but it IS a kluge.

AJ 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Keeping track of database changes

[Philip Molter]

We've got a fairly critical database system that we're setting up
and we need to know if there's an easy way to track changes made
to the database (hopefully at a fairly low level).

In essence, what we want, is a log of what fields and values are
changed by the primary key on each table, including timestamps of
said changes.

* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem with GROUP BY ... DESC

[Dave Rolsky]

On Tue, 4 Dec 2001, AJ wrote:

> Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
>
> The problem that has cropped up I have is that in all GROUP BY column DESC
> statements, the DESC is now not being recognized, and the query is being
> returned in ascending order.  If I use ORDER BY... DESC that works fine.

I'm seeing the same bug on 3.23.45 (and maybe others but I can't remember
all the versions I've played with recently).  It does the same thing where
it accepts the syntax but does not respect it (and returns rows in the
default ASC ordering).


-dave

/*==
www.urth.org
We await the New Sun
==*/


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: BDB table handler crashing during select

[Sasha Pachev]

On Tuesday 04 December 2001 12:00 pm, [EMAIL PROTECTED] wrote:
> The concept of a transaction is important to my app because the number of 
> queries and the number of tables 
> to be modified during a particular transaction is not easy to calculate. It 
is 
> obtained from the result of
> the queries to the myISAM tables. If for some reason, one query cannot be 
> fulfilled, all queries of the transaction
> are undone by calling ROLLBACK. The transaction model makes my app much 
> simlper and more flexible.

For transaction support, the recommended table handler is InnoDB. For BDB, 
though, we will fix all bug for which we have a test case. Please send a full 
test case including your tables to [EMAIL PROTECTED] If your tables are 
reasonably large, upload them to ftp://support.mysql.com/pub/mysql/secret.

We do, however, recommend that you switch to InnoDB since there is currently 
no active development on the BDB handler.

-- 
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
   <___/  

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[OT] Re: compile problems on Solaris8

[Michael Stassen]

Matt,

According to Sun , gcc
2.95.3 is included on the "Solaris Software Companion CD" which is part of
Solaris 8, Update 07/01.  There are links there to download the entire CD
or individual packages from it.  I have not tried it, but I assume this is
what is meant by "SFW version of gcc that comes with Solaris
2.8".  (SFW=SunFreeWare?)

Personally, I am biased towards building from source.  As I said in my
previous message, I've had better luck since I used the sunfreeware gcc
2.95.3 binary to build (and install) gcc 2.95.3 from source.  YMMV.

Michael

On Tue, 4 Dec 2001, Matthew Dougherty wrote:

> I hate to show my ignorance but I am unfamiliar with "SFW version of
> gcc that comes with Solaris 2.8".
> 
> Could you clue me in?
> 
> By the way, it is correct that I am using gcc 2.95.3 from the
> sunfreeware binary distribution.  It's been a pain for several
> applications. (OpenSSH, etc).
> 
> Matt.
> 
> George Horvath wrote:
> 
> > Michael Widenius wrote:
> > >
> > > Hi!
> > >
> > > > "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes:
> > >
> > > 
> > >
> > > Michael>   * everyone who has reported this was using the precompiled binary of 
>gcc
> > > Michael>   (either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 
>8
> > > Michael>   sparc.
> > >
> > > Michael>   * No one has spoken up to report success with this combination.
> > >
> > > Michael>   * No one who built gcc from source has reported this problem.
> > >
> > > Michael> Unless a new piece of information comes in, it seems clear to me that
> > > Michael> configure doesn't like sunfreeware's pre-compiled copy of gcc for 
>Solaris
> > > Michael> 8 sparc.  It would be nice if someone from MySQL would tell us just what
> > > Michael> configure is doing when it declares sunfreeware's gcc a cross-compiler,
> > > Michael> and could confirm whether this is a configure problem or a gcc problem.
> > >
> > > I have now added a note about this in our online manual.
> > > (Sorry, I thought we already had done this).
> > >
> > > The bottom line seems to be that one should not use the gcc compiler
> > > from sunfreeware but instead use the SFW version of gcc that comes
> > > with Solaris 2.8 or download the gcc source and compile it.
> > >
> > > The reason configure declares sunfreeware a cross compiler is that
> > > gcc succeed in compiling a simple test program but the program would
> > > not run. Based on this configure concludes that the compiler doesn't
> > > generate a working binary for this architecture and must thus be a
> > > cross compiler to another architecture.
> >
> > Ok, I followed your advice and removed the soaris built gcc from sunfreeware and 
>downloaded the source instead.  How ever now
> > I am getting this message when I try to compile gcc:
> >
> > # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu
> > Configuring for a sparc-sun-solaris2.8 host.
> > Created "Makefile" in /usr/local/objdir using "mh-frag"
> > /usr/ucb/cc:  language optional software package not installed
> > *** The command '/usr/ucb/cc -o conftest -g   conftest.c' failed.
> > *** You must set the environment variable CC to a working compiler.
> >
> > How do I find out what package am I missing?  Can someone point to a site with a 
>good solaris 8 build of gcc I can use instead
> > of sunfreeware.  I really prefer not to spend time on debugging the Sun compiler.  
>Unless of course it's just a simple
> > addition of a package.
> >
> > Thanks,
> > George
> >
> > >
> > > Regards,
> > > Monty
> > >
> > > --
> > > For technical support contracts, goto https://order.mysql.com/
> > >__  ___ ___   __
> > >   /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]>
> > >  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
> > > /_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
> > ><___/   www.mysql.com
> >
> > --
> > George Horvath
> > Scotia Capital Markets
> > ISS - Technology Application Group
> > Tel: 416-945-4204
> > Fax: 416-945-4002
> > E-mail: [EMAIL PROTECTED]
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


-
Before posting, please check:
   http

Re: Problem making myodbc on Solaris 8

[Matthew Dougherty]

Can anyone make a suggestion of what the following lines are trying to do in
Makefile in the first place?

DEPS_MAGIC := $(shell mkdir .deps > /dev/null 2>&1 ||:)
-include $(DEP_FILES)

This does not appear to me to be appropriate syntax and it's probably independent
of the compiler or make program.  It may be that configure fails to succeed
because "Solaris 2.8" is not one of it's options?

Matt Dougherty
[EMAIL PROTECTED]

Matthew Dougherty wrote:

> The same error occurs with 2.50.39.
>
> Has anyone successfully made MyODBC on Solaris8 using gcc 2.95??
>
> Matt Dougherty
>
> Venu wrote:
>
> > Hi,
> >
> > > -Original Message-
> > > From: Matthew Dougherty [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, December 03, 2001 11:06 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: Problem making myodbc on Solaris 8
> > >
> > >
> > > make fails with mksh: Fatal error in reader:  = missing from replacement
> > >
> > > macro reference
> > >Current working directory
> > > /opt/perlModules/MyODBC-2.50.37
> > >
> > > I have ODBC working for SQL Server.
> > >
> > > If I do a make -V is leads me to a bad set of lines in Makefile:
> > >
> > > DEPS_MAGIC := $(shell mkdir .deps > /dev/null 2>&1 ||:)
> > >
> > > -include $(DEP_FILES)
> > >
> > > If I take out the colon on the :=, I don't get an error.
> > >
> > > Is the -include a typo?  I don't see a matching subroutine in
> > > Makefile.  If I change it to include $(DEP_FILES) it can't find the
> > > files.
> > >
> > > DEP_FILES is previously defined as a list of files in .deps.
> > >
> > >
> > > I am running as root using GCC 2.95.  I have a separate build of perl
> > > that I am using instead of /usr/bin/perl on Solaris 8.
> > >
> > > The PATH is set to
> > > /usr/local/bin:/usr/local/mysql/bin:/usr/bin:/usr/sbin:/usr/ccs/bin
> > > I am using the make in /usr/ccs/bin.
> > >
> > > The LD_LIBRARY_PATH is set to /usr/local/lib:/usr/local/mysq:/usr/lib
> > >
> > > The configure command is as follows:
> > >
> > > ./configure --with-odbc-ini=/etc/odbc.ini
> > > --with-iodbc-includes=/usr/local/openlink/w3configu/include
> > > --with-iodbc-libs=/usr/local/openlink/lib
> > > --with-mysql-dirs=/usr/local/mysql/lib/mysql
> > > --with-mysql-includes=/usr/local/mysql/include/mysql
> > >
> > >
> > Can you download and try the latest version 2.50.39(unix source)
> > from:
> > http://www.mysql.com/downloads/api-myodbc.html
> >
> > Regards, Venu
> > --
> > For technical support contracts, go to https://order.mysql.com
> >__  ___ ___   __
> >   /  |/  /_ __/ __/ __ \/ /   Mr. Venu <[EMAIL PROTECTED]>
> >  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
> > /_/  /_/\_, /___/\___\_\___/  California, USA
> ><___/  www.mysql.com
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem with ASP + mySQL

[Jimmy44 --]

Dear all,

I am having the following problem with ASP + mySQL
Actually, when executing the following Query:
SELECT Min(Col1), Col2 FROM Table1 GROUP BY Col2

I get an empty recordSet, while executing the following query doesn't return
an empty recordSet:
SELECT Col1,Col FROM Table1 GROUP BY Col1

I am connection using:
RS.Open SQLQuery, Connection

Can someone help?

Thanks,

Jimmy





__
Send a friend your Buddy Card and stay in contact always with Excite Messenger
http://messenger.excite.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[OT] Re: compile problems on Solaris8

[Michael Stassen]

On Tue, 4 Dec 2001, George Horvath wrote:

> Michael Widenius wrote:
> > 
> > Hi!
> > 
> > > "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes:
> > 
> > 
> > 
> > Michael>   * everyone who has reported this was using the precompiled binary of gcc
> > Michael>   (either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8
> > Michael>   sparc.
> > 
> > Michael>   * No one has spoken up to report success with this combination.
> > 
> > Michael>   * No one who built gcc from source has reported this problem.
> > 
> > Michael> Unless a new piece of information comes in, it seems clear to me that
> > Michael> configure doesn't like sunfreeware's pre-compiled copy of gcc for Solaris
> > Michael> 8 sparc.  It would be nice if someone from MySQL would tell us just what
> > Michael> configure is doing when it declares sunfreeware's gcc a cross-compiler,
> > Michael> and could confirm whether this is a configure problem or a gcc problem.
> > 
> > I have now added a note about this in our online manual.
> > (Sorry, I thought we already had done this).
> > 
> > The bottom line seems to be that one should not use the gcc compiler
> > from sunfreeware but instead use the SFW version of gcc that comes
> > with Solaris 2.8 or download the gcc source and compile it.
> > 
> > The reason configure declares sunfreeware a cross compiler is that
> > gcc succeed in compiling a simple test program but the program would
> > not run. Based on this configure concludes that the compiler doesn't
> > generate a working binary for this architecture and must thus be a
> > cross compiler to another architecture.
> 
> Ok, I followed your advice and removed the soaris built gcc from
> sunfreeware and downloaded the source instead.  How ever now I am
> getting this message when I try to compile gcc:
> 
> # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu
> Configuring for a sparc-sun-solaris2.8 host.
> Created "Makefile" in /usr/local/objdir using "mh-frag"
> /usr/ucb/cc:  language optional software package not installed
> *** The command '/usr/ucb/cc -o conftest -g   conftest.c' failed.
> *** You must set the environment variable CC to a working compiler.
> 
> How do I find out what package am I missing?  Can someone point to a
> site with a good solaris 8 build of gcc I can use instead of
> sunfreeware.  I really prefer not to spend time on debugging the Sun
> compiler.  Unless of course it's just a simple addition of a package.
> 
> 
> Thanks,
> George
> 

First, let me acknowledge that a couple of people have reported success
building mysql with sunfreeware's precompiled gcc 2.95.3 since I wrote
this.  That was news to me, but it would imply that there may be a way to
install it (precompiled gcc 2.95.3) that causes problems (perhaps it
expects something else which is missing), or perhaps a set of mysql
configure options which don't interact well with it.

Second, I'm afraid you've misunderstood me, which probably means I wasn't
clear.  Sorry.  /usr/ucb/cc is not a fully functional compiler and cannot
be used to build software.  Many people recommend removing /usr/ucb from
your PATH for this reason, though I find putting it last, after the
location of gcc, works just as well.  You need a functional c compiler to
build gcc.  The usual procedure is to download and install sunfreeware's
precompiled gcc 2.95.3, then use it to build gcc 2.95.3 from source.  You
can find directions at http://gcc.gnu.org/install/

Finally, I want to clarify that I don't claim that sunfreeware's
precompiled gcc is broken.  Many people use it without trouble.  
Personally, I found it quirky.  It worked for most things, but didn't
quite work for a few packages.  Once I built and installed gcc from source
using the binary, these quirks went away.  YMMV.

Michael



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Upgraded server, MySql Crashes with old databases

[Fredrik Lunde]

Need MySql 3.21 for Win2000

I have some old databases from MySql 3.21 and I want to move these to MySql 3.23, but 
the server just crashes.
I've tried to start the MySql with --old-protocol, but no changes.

My plan is to install MySql 3.21 on my PC to get the databases, but there is no 
download available. 

Is there a NT version of MySql 3.21?

Does anybody know where to get this?

Is there any other ways to read these databases?

Thanks
-
Fredrik Lunde  /Webutvikler/webdesigner
Norwegiandesigner.net
www.ndes.net
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Coredump when running scripts/mysql_install_db

[Michael Stassen]

A couple of others have reported this in the last month.  I reported what
I believe to be the same problem on Mon, 29 Oct 2001 with mysql 3.23.43
built from source with gcc 2.95.3 according to the instructions in the
manual.  I believe the problem is that enabling largefile support, as is
done in the official binaries, breaks getrlimit/setrlimit in HPUX 10.20,
at least for us.  It seems that when you enable largefiles (define
_FILE64), rlim_t changes from uint32_t to uint64_t, and something goes
horribly wrong.

Try this simple c program (based on set_maximum_open_files in mysqld.cc):
===
#include 
#include 
#include 

int main()
{
  struct rlimit rl;
  uint x;
  
  x = 100;
  if (!getrlimit(RLIMIT_NOFILE,&rl))
  {
printf("getrlimit: cur=%ld max=%ld\n", rl.rlim_cur, rl.rlim_max);
  }
  rl.rlim_cur = x;
  rl.rlim_max = x;
  printf("assign: cur=%ld max=%ld\n", rl.rlim_cur, rl.rlim_max);
  if (setrlimit(RLIMIT_NOFILE,&rl))
  {
printf("Err: errno=%ld cur=%ld max=%ld\n",errno,rl.rlim_cur,rl.rlim_max);
  }
  printf("setrlimit: cur=%ld max=%ld\n", rl.rlim_cur, rl.rlim_max);
  0;
}
===

I named this rlimtest.c.  Here's what I get:

$ gcc rlimtest.c 
$ ./a.out   
getrlimit: cur=60 max=1024
assign: cur=100 max=100
setrlimit: cur=100 max=100

but 

$ gcc -D_FILE64 rlimtest.c  
$ ./a.out   
getrlimit: cur=137119232 max=60
assign: cur=2063670312 max=100
setrlimit: cur=137119232 max=100

As you can see, I get nonsense with _FILE64.  

Strictly speaking, then, this is a bug in either HPUX or gcc (probably
HPUX), not in mysql.  On the other hand, those of us who have this problem
cannot use the precompiled binary.  

My workaround is to compile mysql from source, adding --disable-largefile
to the options recommended in the manual.  Perhaps there is a better way
-- maybe a fix for HPUX?

I also note that every post I could find on Google on the subject of
building mysql from source on HPUX 10.20 recommended --disable-largefile
(though none I saw actually said why).

Michael

On Tue, 4 Dec 2001, Hans-Joerg Puch wrote:

> Hello,
> I was trying a normal installation on a HP UX 10.20 based HP 9000/712.
> The log looks like this:
> ___
> Preparing db table
> Preparing host table
> Preparing user table
> Preparing func table
> Preparing tables_priv table
> Preparing columns_priv table
> Installing all prepared tables
> 011204 15:37:50  Warning: setrlimit couldn't increase number of open
> files to more than 60
> 011204 15:37:50  Warning: Changed limits: max_connections: 50
> table_cache: 64
> scripts/mysql_install_db[292]: 3477 Memory fault(coredump)
> Installation of grant tables failed!
> 
> Examine the logs in ./data for more information.
> You can also try to start the mysqld daemon with:
> ./bin/mysqld --skip-grant &
> You can use the command line tool
> ./bin/mysql to connect to the mysql
> database and look at the grant tables:
> 
> shell> ./bin/mysql -u root mysql
> mysql> show tables
> 
> Try 'mysqld --help' if you have problems with paths. Using --log
> gives you a log in ./data that may be helpful.
> 
> The latest information about MySQL is available on the web at
> http://www.mysql.com
> Please consult the MySQL manual section: 'Problems running
> mysql_install_db',
> and the manual section that describes problems on your OS.
> Another information source is the MySQL email archive.
> Please check all of the above before mailing us!
> And if you do mail us, you MUST use the ./bin/mysqlbug script!
> ___
> What's wrong?
> I did run ./bin/mysqldbug which created this:
> 
> SEND-PR: -*- send-pr -*-
> SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
> 
> SEND-PR: will all comments (text enclosed in `<' and `>').
> SEND-PR:
> From: root
> To: [EMAIL PROTECTED]
> Subject: [50 character or so descriptive subject here (for reference)]
> 
> >Description:
> 
> >How-To-Repeat:
>  lines)>
> >Fix:
>  lines)>
> 
> >Submitter-Id:  
> >Originator:
> >Organization:
>  
> >MySQL support: [none | licence | email support | extended email support
> ]
> >Synopsis:  
> >Severity:  <[ non-critical | serious | critical ] (one line)>
> >Priority:  <[ low | medium | high ] (one line)>
> >Category:  mysql
> >Class: <[ sw-bug | doc-bug | change-request | support ] (one
> line)>
> >Release:   mysql-3.23.46 (Official MySQL binary)
> 
> >Environment:
> 
> System: HP-UX galileo B.10.20 A 9000/712 2000839175 two-user license
> 
> 
> Some paths:  /usr/contrib/bin/perl /usr/bin/make /usr/bin/cc
> 
> Compilation info: CC='gcc'  CFLAGS='-DHPUX -I/opt/dce/include -O3'
> CXX='gcc'  C
> XXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions

RE: odbc driver

[Venu]

Hi,

> -Original Message-
> From: avital raz [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 12:56 PM
> To: [EMAIL PROTECTED]
> Subject: odbc driver
> 
> 
> hello
> i need help
> i have a database in mysql.
> i use an outside program that connect to the databas through odbc 
> (dsn) and make graphs.
> the program worked very good for months but at the last week 
> something disrupted.
> when i tried to make graph from one specific table, i receive an 
> error message.
> the message is:
> [microsoft][odbc drivermanager] driver does not support this 
> parameter ERR= -2147467259.
> the sql that i request is very simple - select of tree columns
> table.month, count(table.visits), table.year
> using group by 1,3.
> i must say that if i run that sql in oracle odbctest or directly in 
> mysql i got the recordsets proper with no problem.
> another importent fact - when i remove the table.year from the sql i 
> got the recordsets proper in my program to.
> all others graphs works well, and have the same structure of what i 
> writed here.
> so, if someone can give me an idea what to do i will thank him/her very much
> 
> 

Can you please send me the ODBC trace, so that it becomes easy 
to trace what is happening.

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  California, USA
   <___/  www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mailing list

[Colin Faber]

Hi folks, 

I was wondering if anyone has given any thought to doing a questions@
list and possibly a PR system much like the freebsd project does? So as
to lessen the amount of redundant information on this list?


ps
sql, select, database

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

maximum keyfile length significantly less than 8TB?

[Noah Friedman]

The mysql manual claims that MyISAM is essentially limited only by the
filesystem for how large tables can be.

Yesterday, inserts to one of my tables began failing with error 136
(keyfile full) although the file is only around 17 gigabytes.  There
appears to be some undocumented limitation that falls significantly short
of the 8TB limit advertised for MyISAM tables.

After running myisamchk -r, the keyspace seems to have been compacted by
about 3gb but this is just forestalling my running out of space again:

# myisamchk -d -v foo

MyISAM file: foo
Record format:   Fixed length
Character set:   latin1 (8)
File-version:1
Creation time:   2001-05-04 14:57:51
Recover time:2001-12-04  3:14:34
Status:  checked,analyzed,optimized keys
Data records:469005858  Deleted blocks: 0
Datafile parts:  469005858  Deleted data:   0
Datafile pointer (bytes):4  Keyfile pointer (bytes):3
Datafile length:9849123018  Keyfile length:   14849268736
Max datafile length:   90194313214  Max keyfile length:   17179868159
Recordlength:   21

table description:
Key Start Len Index   Type   Rec/key Root  Blocksize
1   6 3   multip. uint24   0   6256517120   1024
124   unsigned long0
102   unsigned short   0
2   6 3   multip. uint24   0  11026118656   1024
102   unsigned short   0
9 1   binary   0
3   2 4   multip. unsigned long0  14849267712   1024


Shouldn't the keyfile pointer size be at least as large as the datafile
pointer, since multiple indexes are possible (and, I'd wager, typical) for
any given datafile?  I have three non-unique indexes on this table, in
fact.

My main question though, is: how do I fix this?

I'm using MySQL 3.23.44 on Solaris 7; I believe tables were originally
created with 3.23.33.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

odbc driver

[avital raz]

hello
i need help
i have a database in mysql.
i use an outside program that connect to the databas through odbc (dsn) and make 
graphs.
the program worked very good for months but at the last week something disrupted.
when i tried to make graph from one specific table, i receive an error message.
the message is:
[microsoft][odbc drivermanager] driver does not support this parameter ERR= 
-2147467259.
the sql that i request is very simple - select of tree columns
table.month, count(table.visits), table.year
using group by 1,3.
i must say that if i run that sql in oracle odbctest or directly in mysql i got the 
recordsets proper with no problem.
another importent fact - when i remove the table.year from the sql i got the 
recordsets proper in my program to.
all others graphs works well, and have the same structure of what i writed here.
so, if someone can give me an idea what to do i will thank him/her very much

RE: Select with Left Joins

[Rick Emery]

This is operating as it should.  The order of the left joins sets the
precedence of the selection.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 10:55 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Select with Left Joins


Perhaps this is obvious, but I have a SELECT (with many LEFT JOINs) that I
would 
expect to return results, but it does not.  If I make one change in the
order 
in which tables are used, the SELECT works:

The SQL that doesn't work is:
---
SELECT T1.patentNumber, T1.title, T2.ipvMap, T3.claimCode, T2.numOfFC,
T2.numOfBC
FROM usptoDataTable AS T1
LEFT JOIN ipvDataTable AS T2 USING (patentNumber)
LEFT JOIN clientDataTable AS T3 USING (patentNumber)
LEFT JOIN iPlanetDataTable AS T4 USING (patentNumber)
WHERE T4.sunPatentNumber LIKE '%P%'
LIMIT 10
---

No rows are returned even though there are lots of rows in table T4 that fit
the criteria.
Changing the order of the LEFT JOIN of T3 and T4 returns 10 rows. The SQL
that works is:  
---
SELECT T1.patentNumber, T1.title, T2.ipvMap, T3.claimCode, T2.numOfFC,
T2.numOfBC
FROM usptoDataTable AS T1
LEFT JOIN ipvDataTable AS T2 USING (patentNumber)
LEFT JOIN iPlanetDataTable AS T4 USING (patentNumber)< order of
these two is swapped but alias name unchanged
LEFT JOIN clientDataTable AS T3 USING (patentNumber) < order of
these two is swapped but alias name unchanged
WHERE T4.sunPatentNumber LIKE '%P%'
LIMIT 10
---

Is this a bug or user error?
Paul Albrecht



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MyODBC and Accents

[Venu]

Hi,

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 12:05 PM
> To: [EMAIL PROTECTED]
> Subject: MyODBC and Accents
> 
> 
> I'm programmer of ASP, I'm initiating the use of the data base MySQL 
> with ASP, 
> but I noticed that driver MyOBDC 2.50.39 it correctly does not return the 
> accents from the words. 
>  
> Somebody can help me? 
>  
Can you be more specific on the problem, please ?

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  California, USA
   <___/  www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Access Denied Errors

[Kevin Martone]

Hi..

I'm using mySQL with Avantgo

For a while we kept getting an access denied error:

  access denied for user '@' to
database '' The avantgo support person told me
how to go into the mysql database and we looked at the
users table and saw that there was a password for
'root'. We had been using root with no password on an
old server before we moved to this new one and it had
always worked. Nevertheless he told me what it was and
I entered it in the DSN information. Then the error
changed to:

  access denied for user 'root@' 
(Using password:YES) which I understand from the mysql
documentation means that we are entering the wrong
password... so I kept looking on the documentation for
more clues… The mysql_install_db script to set
intitial privileges is always mentioned but I cannot
find this script on my server anywhere I also
tried setting the root password to what it should have
been with.

  INSERT INTO user (Host,User,Password)
VALUES('%','root',PASSWORD(''));

and the change seemed to go thru

but now the error message we get is 

  Either BOF or EOF is True, or the current record
has been deleted. Requested operation requires a
current record. 

Does anyone know what is going wrong? Any help would
be greatly appreciated. Also, if anyone can tell me
where to find the mysql_install_db script, that would
be helpful as well.

 

Thanks,

Leslie


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MyODBC and Accents

[webpp]

I'm programmer of ASP, I'm initiating the use of the data base MySQL with ASP, 
but I noticed that driver MyOBDC 2.50.39 it correctly does not return the 
accents from the words. 
 
Somebody can help me? 
 
Thanks!
 
Marcelo Busana
---
 WebDeveloper
 UNIDAVI

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: more than one possible column value

[Etienne Marcotte]

well I index both because it enables to pull data without even reading
on the table.It reads  only in the B-Tree index since it's both numeric.

There is a section on mySQl optimization in the mySQL guide on the
webpage.

If you want to find all files that have this or that extension, mySQL
will use the (typeID,fileID) index

if you are looking for the index of a particular file, it will use the
index (fileID, typeID). 
this is for speed!

HTH

Etienne

Erik Price wrote:
> 
> On Tuesday, December 4, 2001, at 01:23  PM, Etienne Marcotte wrote:
> 
> > CREATE TABLE filetypes (
> > fileID smallint unsigned not null,
> > typeID smallint unsigned not null,
> > unique index (fileID,typeID),
> > unique index (typeID,fileID)
> > )
> 
> One question, though.  Do I have to construct indexes in both
> directions?  I haven't used the UNIQUE INDEX command.  I still have much
> to learn -- I'm only partway through the DuBois book that I am using to
> learn MySQL.  The chapter on optimizing databases and indexing is next.
> 
> Well, no need to respond to that.  I will study further before asking
> any more questions.
> 
> Erik

-- 
Etienne Marcotte
Specifications Management - Quality Control
Imperial Tobacco Ltd. - Montreal (Qc) Canada
514.932.6161 x.4001

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: more than one possible column value

[Erik Price]

On Tuesday, December 4, 2001, at 01:23  PM, Etienne Marcotte wrote:

> CREATE TABLE filetypes (
> fileID smallint unsigned not null,
> typeID smallint unsigned not null,
> unique index (fileID,typeID),
> unique index (typeID,fileID)
> )

One question, though.  Do I have to construct indexes in both 
directions?  I haven't used the UNIQUE INDEX command.  I still have much 
to learn -- I'm only partway through the DuBois book that I am using to 
learn MySQL.  The chapter on optimizing databases and indexing is next.

Well, no need to respond to that.  I will study further before asking 
any more questions.





Erik


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: killed by SIGSEGV

[Ken Menzel]

Hi Matt,
  Thanks for the detailed response regrading the SIGSEGV.  I am
stumped,  the compiler and hardware sound fine.  The defaults on MySQL
are very stingy (A good thing).I think this is time for a linux
expert,  (I run FreeBSD).

My first suggestion would be to come up to a much more current version
currently 3.23.46.  There have been 15 releases since that version and
you may be running across a known bug that has been fixed.  Looking at
the back trace you provided though I am going to guess that there is a
threads problem in your particular Linux (Only a guess).

My only other suggestion as Sasha already suggested is to try the
MySQL statically compiled binary available from the web site and see
if it does the same for you.  That one is built with know good
libraries.   Hopefully someone more expert on linux will respond!

Good Luck!
Ken
- Original Message -
From: "matt" <[EMAIL PROTECTED]>
To: "Ken Menzel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, December 04, 2001 11:40 AM
Subject: Re: killed by SIGSEGV


> On Tue, 4 Dec 2001, Ken Menzel wrote:
> > Your platform: Linux?  What version?  your kernel?
>
> Sorry, I should have included this information in my first post.
>
> The hardware is a Dell 2550 poweredge with a 1GHz Intel 3, 500MB ECC
> RAM, 2 SCSI disks in RAID and some intel NICS.
>
> The OS is GNU/Linux 2.4.4 patched for Dell's RAID.  The distro is
> my own (based on LFS and Slackware).  Library info below.
>
> Here are some details from mysqlbug:
>
> >Release:   mysql-3.23.31 (Source distribution)
>
> System: Linux bertha 2.4.4 #2 SMP Thu Aug 23 15:43:39 BST 2001 i686
> unknown
> Architecture: i686
>
> Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from
> /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''
> LDFLAGS=''
> LIBC:
> lrwxrwxrwx   1 root root   13 Aug 17 12:14
/lib/libc.so.6
> -> libc-2.1.3.so
> -rwxr-xr-x   1 root root  4186643 May  3  2001
> /lib/libc-2.1.3.so
> -rw-r--r--   1 root root 20332328 May  3  2001
/usr/lib/libc.a
> -rw-r--r--   1 root root  178 May  3  2001
> /usr/lib/libc.so
> Configure command: ./configure  --prefix=/usr/local/mysql
>
> Here are the first 3 lines from /proc/meminfo:
>
> total:used:free:  shared: buffers:  cached:
> Mem:  525471744 508993536 164782080 10096640 361168896
> Swap: 304324608   131072 304193536
>
> Fractional usage of swap indicates that the machine isn't being
> pushed, and indeed the load is usually low.
>
> > What is your my.cnf?
>
> I don't have a my.cnf, so I assume its all defaults - do you know
> where I can find this out or would I be advised to work out my own
> custom config for this machine based on the my-medium.cnf or
> my-large.cnf files in share/mysql?
>
> > Many time a signal 11 indicates a Harware/memory problem are you
> > running ECC memory?
>
> I currently have 500MB ECC RAM, supplied by Dell. I used to get this
> problem on an old Linux box with some dodgy RAM. It would be fine
> until I compiled big programs. This box has been fine though, I've
> compiled the kernel no problem 10s of times.
>
> Hopefully thats covered everything,
>
> thanks again - Matt.
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: killed by SIGSEGV

[Brian Reichert]

On Tue, Dec 04, 2001 at 04:40:23PM +, matt wrote:
> Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from
> /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''

Something that was affecting me adversely in the past:  I _think_
MySQL is built with '-O6', as a compiler flag, and using anything
more that '-O2' with g++ can introduce buggy code.  Ater least, I
ran into this under FreeBSD 3.4, running gcc version 2.7.2.3.

-- 
Brian 'you Bastard' Reichert<[EMAIL PROTECTED]>
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Coredump when running scripts/mysql_install_db

[Hans-Joerg Puch]

Hello,
I was trying a normal installation on a HP UX 10.20 based HP 9000/712.
The log looks like this:
___
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
011204 15:37:50  Warning: setrlimit couldn't increase number of open
files to more than 60
011204 15:37:50  Warning: Changed limits: max_connections: 50
table_cache: 64
scripts/mysql_install_db[292]: 3477 Memory fault(coredump)
Installation of grant tables failed!

Examine the logs in ./data for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell> ./bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running
mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!
___
What's wrong?
I did run ./bin/mysqldbug which created this:

SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as

SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]

>Description:

>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:
>Organization:
 
>MySQL support: [none | licence | email support | extended email support
]
>Synopsis:  
>Severity:  <[ non-critical | serious | critical ] (one line)>
>Priority:  <[ low | medium | high ] (one line)>
>Category:  mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one
line)>
>Release:   mysql-3.23.46 (Official MySQL binary)

>Environment:

System: HP-UX galileo B.10.20 A 9000/712 2000839175 two-user license


Some paths:  /usr/contrib/bin/perl /usr/bin/make /usr/bin/cc

Compilation info: CC='gcc'  CFLAGS='-DHPUX -I/opt/dce/include -O3'
CXX='gcc'  C
XXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions
-fno-rtt
i -O3 '  LDFLAGS=''
LIBC:
-r-xr-xr-x   1 binbin1867776 May  2  2001 /lib/libc.1
-r--r--r--   1 binbin2456780 May  2  2001 /lib/libc.a
lrwxr-xr-x   1 root   sys 15 Jun 10  1996 /lib/libc.sl
-> /usr/l
ib/libc.1
-r-xr-xr-x   1 binbin1867776 May  2  2001
/usr/lib/libc.1
-r--r--r--   1 binbin2456780 May  2  2001
/usr/lib/libc.a
lrwxr-xr-x   1 root   sys 15 Jun 10  1996
/usr/lib/libc.sl -> /u
sr/lib/libc.1
Configure command: ./configure  --prefix=/usr/local/mysql
'--with-comment=Offici
al MySQL binary' --with-extra-charsets=complex --with-server-suffix=
--with-pthr
ead --with-named-thread-libs=-ldce --with-lib-ccflags=-fpic
--disable-shared
Perl: This is perl, version 4.0

Please help me with some instructions how to get mysql work om my
computer!
Yours,
Hans-Jörg Puch


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: porting mysql to ibm os/390 open edition

[esp5]

On Tue, Dec 04, 2001 at 03:08:11PM +0200, Sinisa Milivojevic wrote:
> Peschko, Edward writes:
> > hey,
> > 
> > I was wondering if you had any plans to port mysql to os-390, and the open
> > edition environment there. I think it would be 
> > a really cool idea, considering that most shops that have a IBM mainframe
> > are looking for ways to leverage it in the unix world without spending
> > mega-bucks on IBM proprietary solutions like DB2
> > 
> > Anyways, if you are interested in doing so, I'd be glad to help (with a
> > os390 machine available) if you gave me technical support in doing so
> > (pointers/what to change/how to test it/etc)
> > 
> > Thanks much,
> > 
> > Ed
> > 
> 
> It would be very difficult, if not impossible, to do what you suggest.
> 
> For the moment, there is a port of MySQL to Linux / S390.

Why?

Its a unix platform - perl builds there, as does apache, as does gcc, as does
msql (almost)... It has a libc, pthreading, quite a few things..

I think you are thinking of *MVS*, not *OMVS*. And like it or not, omvs has 
some advantages (right now) over linux on the mainframe, as a unix platform. 
For instance, OMVS is mainframe path aware, ie: you can say:

cp "'//PATH.TO.MAINFRAME.FILE'" FILE

and get access to the whole hierarchical file system on the mainframe. And 
hence, you could easily (if you wanted to) make a Mysql database out of 
existing mainframe files, with a lot less fuss...

Ed

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

BDB table handler crashing during select

[mfeitosa]

>Description:
I started using BDB tables in a php program with mysql-3.23.36 that comes with 
redhat7.1.
The php program uses a database of 3 myISAM tables to read the schema of the 
BDB tables and dynamicaly
generate select/update/insert queries on the BDB tables. The BDB tables form 
another database.

The concept of a transaction is important to my app because the number of 
queries and the number of tables 
to be modified during a particular transaction is not easy to calculate. It is 
obtained from the result of
the queries to the myISAM tables. If for some reason, one query cannot be 
fulfilled, all queries of the transaction
are undone by calling ROLLBACK. The transaction model makes my app much 
simlper and more flexible.

It is important to state that some data is inserted into the database without 
transactions. This occurs when
"humans" are populating the database by using graphical mysql clients 
(phpMyAdmin).

The app is finished but because of the problems experienced  has still not 
been put in the production environment.

What happens is that mysqld crashes ,almost  always bringing down the server 
when I was using 3.23.36 .
After I installed 3.23.42 and then 3.23.46 the server does not usually come 
down but mysql.log shows that
one of the mysqld threads crashed, prints a backtrace and then resumes 
operations. The problem was much more
frequent with 3.23.36 than it is with 3.23.42 and 3.23.46. In the newer 
versions it still happens once/twice every two days.

This does not usually happen when I am testing/programing the app and 
therefore gerating a lot
of transactions but during moments when other users are just browsing the app  
and therefore generating
mainly selects. I have dificulty reproducing the test because of this.

It is interesting to note that the query that usually crashes the server is of 
the form

select tblRelac.id as id from tblRelac  where  tblRelac.classL = 'page' and 
tblRelac.idL = '33' and tblRelac.prior > '0'  order by  tblRelac.prior

and I really cant remember it happening on a table diferent than tblRelac. THe 
app has some 20 tables. There is nothing special
about table relac expcept that it is used alot.

After restarting the server (3.23.36) or running [ mysqladmin shutdown ; 
service mysqld start ] (3.23.46) things start working again.

I have never experienced data corruption.

An interesting thing that happens is that the above query always fails after 
the crash but before the restart with the message
No Records Found
This is wrong, the query should at least return one row.

When I run

Select * from tblRelac ; 

the query returns correctly all the rows in the database correctly

After restarting , all is normal.

This suggests to me that the problem could be on an index for the table or on 
index code.
It also suggests that the problem is in memory, because after the restart, 
everything comes back normally.


I have put on the end of this email, tblRelac's schema alogn with the 
backtrace and other error messages.

It seems to me that the offending code is run in 
berkeley_cmp_packed_key__FP4__dbPC8__db_dbtT1 + 118

Thank you,

Miguel Feitosa


>How-To-Repeat:
 I dont know.
 I added --log to my server now.
>Fix:
 I dont know

>Submitter-Id:  
>Originator:root
>Organization:
VMN Consulting - Sao Paulo - Brasil
>MySQL support: none
>Synopsis:  mysqld crash with BDB
>Severity:  serious
>Priority:  high
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.36 (Source distribution)
>Server: /usr/bin/mysqladmin  Ver 8.18 Distrib 3.23.36, for redhat-linux-gnu 
on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.46
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 29 min 44 sec

Threads: 27  Questions: 52530  Slow queries: 0  Opens: 72  Flush tables: 1  
Open tables: 64 Queries per second avg: 29.445
>Environment:

System: Linux diadorim.vmn.com.br 2.4.9-12 #1 Tue Oct 30 18:33:49 EST 2001 
i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc 
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85)
Compilation info: CC='gcc'  CFLAGS='-O2 -march=i386 -mcpu=i686'  CXX='c++'  
CXXFLAGS='-O2 -march=i386 -mcpu=i686'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Nov 29 19:02 /lib/libc.so.6 -> 
libc-2.2.4.so
-rwxr-xr-x2 root root  1283580 Oct  3 15:10 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27314604 Oct  3 14:52 /usr/lib/libc.a
-rw-r--r--1 root root  178 Oct  3 14:52 /usr/lib/libc.so
Configure command: ./configure  i386-redhat-linux --prefix=/usr 

Re: more than one possible column value

[Erik Price]

I understand now.

There needs to be a table in between "files" and "types".  This allows 
me to assign two different rows in the "types" table (say, JPG and JPEG) 
to the same row in the "files" table, or two different rows in the 
"files" table to the same row in the "types" table.

This seems like quite an extra step.  I am prepared to do it if that is 
what must be done -- let me guess:  it's not that hard if you are 
careful to construct SELECT, INSERT, and UPDATE statements that JOIN the 
three tables together in the proper combination!

Okay, I will just have to be very careful about that (this project was 
much easier when the relationships were all one-to-one !!  :-)  .

Thank you very much for your help, Etienne.


-- Erik



On Tuesday, December 4, 2001, at 01:23  PM, Etienne Marcotte wrote:

> hum I have an hard time understanding, but if I'm right:
>
> CREATE TABLE files(
> fileID smallint unsigned auto_increment,
> filename varchar(36) not null,
> primary key (fileID)
> )
>
> CREATE TABLE types(
> typeID smallint unsigned auto_increment,
> typename varchar(36) not null,
> typeext char(4) not null unique,
> primary key (typeID)
> )
>
> You'll need a third table linking the two (because it will be a N:N
> relationship) A file may have many extensions and an extension may have
> many files.
>
> CREATE TABLE filetypes (
> fileID smallint unsigned not null,
> typeID smallint unsigned not null,
> unique index (fileID,typeID),
> unique index (typeID,fileID)
> )
>
> Now insert some dummies
>
> mysql> select * from files;
> ++--+
> | fileID | filename |
> ++--+
> |  1 | foo  |
> |  2 | bar  |
> |  3 | baz  |
> ++--+
> 3 rows in set (0.00 sec)
>
> mysql> select * from types;
> ++-+
> | typeID | typename|
> ++-+
> |  1 | photoshop image |
> |  2 | word document   |
> |  3 | excel sheet |
> |  4 | jpeg image  |
> |  5 | jpeg image  |
> ++-+
> 5 rows in set (0.00 sec)
>
> Now let's say you have an image that can have either jpeg or jpg:
>
> mysql> select * from filetypes;
> +++
> | fileID | typeID |
> +++
> |  3 |  1 |
> |  1 |  2 |
> |  2 |  4 |
> |  2 |  5 |
> +++
> 5 rows in set (0.00 sec)
>
> mysql> SELECT filename, typename, typeext FROM files, types, filetypes
> WHERE filetypes.fileID = files.fileID AND filetypes.typeID =
> types.typeID AND filename LIKE "bar";
> +--++-+
> | filename | typename   | typeext |
> +--++-+
> | bar  | jpeg image | jpg |
> | bar  | jpeg image | jpeg|
> +--++-+
> 5 rows in set (0.00 sec)
>
> I hope it's what you wanted
>
> Etienne
>
> btw, if you find any mailing list ont he web for general relational DB
> design issues, let me know. I searched and could not find any:(
>
> Erik Price wrote:
>>
>> Hello,
>>
>> I was looking for some advice on building my database.  If this is an
>> offtopic question, I apologize in advance!
>>
>> I'm building a database with several tables.  Only two of them pertain
>> to my question.  Also, as I have not yet built my tables (I'm planning
>> them), I can't include contents of a dump.
>>
>> One of the tables is called "files", the other is called "types".  Here
>> is a quick sketch of what "files" looks like (there is more but this is
>> really all that matters):
>>
>> +-+---+-+
>> | file_id | file_name | type_id |
>> +-+---+-+
>> | |   | |
>> | |   | |
>> | |   | |
>> | |   | |
>> +-+---+-+
>>
>> here is "types":
>>
>> +-+---+-+
>> | type_id | type_name | ext |
>> +-+---+-+
>> | |   | |
>> | |   | |
>> | |   | |
>> | |   | |
>> +-+---+-+
>>
>> You can probably figure out what I'm doing here.  file_id and type_id
>> are INTEGER-based primary keys which simply give me a nice reference
>> number to give each row. file_name and type_name are VARCHAR(36)
>> columns.  files.type_id is really the same as types.type_id, and
>> types.ext is a VARCHAR(5) column.  Queries will look like this:
>>
>> SELECT files.file_name
>> FROM files, types
>> WHERE types.ext LIKE "txt"
>> AND files.type_id = types.type_id ;
>>
>> So that a user can enter "txt" as a file's extension and all the files
>> that are .txt files will be returned.
>>
>> First of all, I hope I'm doing this right.
>>
>> Second of all -- some files types (file formats) have more than one
>> extension.  For instance, I write HTML files and use JPEGs.  But
>> sometimes I'll use a graphics program that automatically renames the
>> file "

Re: Optimizing date queries

[Gordan Bobic]

> > Does anyone have some optimization tips for this query:
> >
> > SELECT count(id) FROM tblTabel WHERE fieldName != '' AND
> > DATE_FORMAT(myDateField,'%Y%m%d') = 20011120;
> >
> > It does not use the index i have created, so it scans the entire table,
> > which is a bit to slow.
> >
> > The problem off course is, that MySQL has to do a calculation on the
> > myDateField before it can decide if the row matches. Any "workarounds"
> > for this?
>
> How about:
>
> SELECTcount(id)
> FROM  tblTabel
> WHERE fieldName != '' AND
>   (
>   myDateField >= 2001112000   AND
>   myDateField < 2001113000
>   );
>
> That will use indices, and yield the same results. It will also consume
> less CPU time because you don't have to play with string parsing for the
> date formatting.

Just thought of something else. I don't know if MySQL can do this, but here 
is something that PostgreSQL lets you do. I haven't tried it on MySQL, but 
here it is anyway.

Your query would use an index if the index was created on:

DATE_FORMAT(myDateField,'%Y%m%d')

as stated in your query.

So, you would want to do something like:

CREADE INDEX myDateField_Index
ON tblTabel
(
DATE_FORMAT(myDateField,'%Y%m%d')
);

This may or may not work, but it's worth a shot, if you prefer your query in 
the format it was in before.

Regards.

Gordan

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very large table load/index questions

[Sergei Golubchik]

Hi!

First: please reply to mysql-list and not directly to me.
Then:

On Dec 04, Barry Roomberg wrote:
> > Hi!
> Hi back.
> 
> > Why do you need RAID ? Are you using ext2fs ?
> > With 2.4.2 you can use reiserfs, which does not have 2GB file limit.
> 
> Using ext2fs right now.  Heard a lot of reiserfs horror stories,
> and don't need journalling (yet).  My external raid is a many
> disk RAID5 set, and except for load, this is a query only task.

I have not that much Linux experience (and FreeBSD's UFS
doesn't have 2GB file limit), but most of our developers
work in Linux and they definitely recommend reiserfs.

> > If you use LOAD DATA INFILE (which is recommended) into empty table,
> 
> Here's my command, once for each panel of data, running 2 at a time 
> at all times.
> 
> time mysqlimport bench tab/ind_1101.$1.tab 2>&1| tee -a log/ind.$1.log

Ok, mysqlimport uses LOAD DATA INFILE.

> > Yes, but they are simply convenient shortcuts to
> > myisamchk --keys-used=0 -rq
> > You can enable/disable keys from command line in 3.23.
> 
> Ok, what is the suggested usage?  
> create w/ index
> disable
> load
> enable
> 
> Or something else?

Just create without index, and then ALTER TABLE.
When ALTER TABLE is running check with SHOW PROCESSLIST
that it does 'repair by sorting', not 'repair with keycache'

DISABLE/ENABLE sequence is useful when one want to add data to non-empty
table.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: more than one possible column value

[Etienne Marcotte]

hum I have an hard time understanding, but if I'm right:

CREATE TABLE files(
fileID smallint unsigned auto_increment,
filename varchar(36) not null,
primary key (fileID)
)

CREATE TABLE types(
typeID smallint unsigned auto_increment,
typename varchar(36) not null,
typeext char(4) not null unique,
primary key (typeID)
)

You'll need a third table linking the two (because it will be a N:N
relationship) A file may have many extensions and an extension may have
many files.

CREATE TABLE filetypes (
fileID smallint unsigned not null,
typeID smallint unsigned not null,
unique index (fileID,typeID),
unique index (typeID,fileID)
)

Now insert some dummies

mysql> select * from files;
++--+
| fileID | filename |
++--+
|  1 | foo  |
|  2 | bar  |
|  3 | baz  |
++--+
3 rows in set (0.00 sec)

mysql> select * from types;
++-+
| typeID | typename|
++-+
|  1 | photoshop image |
|  2 | word document   |
|  3 | excel sheet |
|  4 | jpeg image  |
|  5 | jpeg image  |
++-+
5 rows in set (0.00 sec)

Now let's say you have an image that can have either jpeg or jpg:

mysql> select * from filetypes;
+++
| fileID | typeID |
+++
|  3 |  1 |
|  1 |  2 |
|  2 |  4 |
|  2 |  5 |
+++
5 rows in set (0.00 sec)

mysql> SELECT filename, typename, typeext FROM files, types, filetypes
WHERE filetypes.fileID = files.fileID AND filetypes.typeID =
types.typeID AND filename LIKE "bar";
+--++-+
| filename | typename   | typeext |
+--++-+
| bar  | jpeg image | jpg |
| bar  | jpeg image | jpeg|
+--++-+
5 rows in set (0.00 sec)

I hope it's what you wanted

Etienne

btw, if you find any mailing list ont he web for general relational DB
design issues, let me know. I searched and could not find any:(

Erik Price wrote:
> 
> Hello,
> 
> I was looking for some advice on building my database.  If this is an
> offtopic question, I apologize in advance!
> 
> I'm building a database with several tables.  Only two of them pertain
> to my question.  Also, as I have not yet built my tables (I'm planning
> them), I can't include contents of a dump.
> 
> One of the tables is called "files", the other is called "types".  Here
> is a quick sketch of what "files" looks like (there is more but this is
> really all that matters):
> 
> +-+---+-+
> | file_id | file_name | type_id |
> +-+---+-+
> | |   | |
> | |   | |
> | |   | |
> | |   | |
> +-+---+-+
> 
> here is "types":
> 
> +-+---+-+
> | type_id | type_name | ext |
> +-+---+-+
> | |   | |
> | |   | |
> | |   | |
> | |   | |
> +-+---+-+
> 
> You can probably figure out what I'm doing here.  file_id and type_id
> are INTEGER-based primary keys which simply give me a nice reference
> number to give each row. file_name and type_name are VARCHAR(36)
> columns.  files.type_id is really the same as types.type_id, and
> types.ext is a VARCHAR(5) column.  Queries will look like this:
> 
> SELECT files.file_name
> FROM files, types
> WHERE types.ext LIKE "txt"
> AND files.type_id = types.type_id ;
> 
> So that a user can enter "txt" as a file's extension and all the files
> that are .txt files will be returned.
> 
> First of all, I hope I'm doing this right.
> 
> Second of all -- some files types (file formats) have more than one
> extension.  For instance, I write HTML files and use JPEGs.  But
> sometimes I'll use a graphics program that automatically renames the
> file ".JPG" and I won't change it because it's too much of a pain.  Or
> someone I work with might have use Windows, and instead of writing a
> .html file, they may have their extension as .htm (the "l" is missing).
> 
> What is the best way to accommodate all of this?  I would like to make
> the "types" table a comprehensive list of all file formats with their
> associate extensions so that when a filename comes up, the user can
> easily see what format that file is in (and there would be other
> columns, such as "open_in" with the name of an application to open that
> file with; e.g.: Photoshop for ".psd" or Illustrator for ".ai").
> 
> Any advice?
> 
> Thank you,
> 
> Erik Price
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Tr

Re: Optimizing date queries

[Gordan Bobic]

On Tuesday 04 Dec 2001 14:58, Emil Rasmussen wrote:
> > SELECT count(id)
> > FROM tblTabel
> > WHERE fieldName != '' AND
> > (
> > myDateField >= 2001112000 AND
> > myDateField < 2001113000
> > );
>
> Thank you, that was defiantly part of the solution!
>
> I had created an index on both fieldName og myDateField, but MySQL did not
> use that. But creating an index only on myDateField did the trick.

If you don't search on the first field in the index, the index doesn't get 
used. In a majority of cases, what you want is a separate index for each 
field. There are exceptions, of course, for example when you want to create 
unique constraints on a table...

> Thanks for the help!

Any time.

Gordan

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Size of table's MYD file?

[Carl Troein]

Nissim Lugasy writes:

> Why is it that when I delete records from a table in the database, the size 
> of the table's MYD file does not get smaller. It's still the original size. 
> Do I have to flush the table to get the accurate size?

OPTIMIZE TABLE is what you want. But doing it after each and every
DELETE might be considered overkill, at least if you're not deleting
a majority of the rows.

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Size of table's MYD file?

[Mike(mickalo)Blezien]

On Tue, 04 Dec 2001 12:53:33 -0500, Nissim Lugasy <[EMAIL PROTECTED]>
wrote:

>>Why is it that when I delete records from a table in the database, the size 
>>of the table's MYD file does not get smaller. It's still the original size. 
>>Do I have to flush the table to get the accurate size?

run OPTIMIZE on the table. that usually corrects that.


Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqladmin reload not rebuilding GRANT information

[Carl Troein]

Sinisa Milivojevic writes:

> Yes, that is so.
> 
> But you do not have to restart MySQL. Just run:
> 
> FLUSH HOSTS

D'oh. I should've read the manual before posting. Sorry.
To those who hasn't seen it already, I wish to point out that
section 5.5.5 has some useful information about MySQL's host
cache. The only thing that seems to be missing is some way to
have entries live a fixed about of time, but since you can
FLUSH HOSTS every now and then, or turn off the caching completely
I don't think it's a real problem.

//C - learning

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Size of table's MYD file?

[Jon Gardiner]

Shrinking the database immediately would be too slow for most purposes.
When you delete a record the database flags it as ready to be recycled.
Inserts will always try to recycle a deleted slot where possible.  If you
delete a really big block of records and want to reclaim the disk space you
can run "optimize table your_table" to force mysql to rebuild the table.

Jon Gardiner.

> -Original Message-
> From: Nissim Lugasy [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 10:54 AM
> To: [EMAIL PROTECTED]
> Subject: Size of table's MYD file?
> 
> 
> Why is it that when I delete records from a table in the 
> database, the size 
> of the table's MYD file does not get smaller. It's still the 
> original size. 
> Do I have to flush the table to get the accurate size?
> 
> Thanks
> 
> 
> 
> 
> 
> Nissim Lugasy
> 216-433-2708
> [EMAIL PROTECTED]
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very large table load/index questions

[David Turner]

Thanks, but I'm looking at having this for all objects

drop table mytable retain metadata;

etc

Dave
On Tue, Dec 04, 2001 at 06:52:17PM +0100, Sergei Golubchik wrote:
> Hi!
> 
> On Dec 04, David Turner wrote:
> > I've always thought it would be great if there was a way to drop an object but
> > keep the meta data so I can recreate objects without having to store the ddl 
> > somewhere.
> > 
> > alter table drop index retain metadata
> > 
> > Would be helpful. 
> 
> That's what ALTER TABLE ... DISABLE KEYS is for
> 
> Regards,
> Sergei
> 
> -- 
> MySQL Development Team
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
> /_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
><___/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Size of table's MYD file?

[Nissim Lugasy]

Why is it that when I delete records from a table in the database, the size 
of the table's MYD file does not get smaller. It's still the original size. 
Do I have to flush the table to get the accurate size?

Thanks





Nissim Lugasy
216-433-2708
[EMAIL PROTECTED]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very large table load/index questions

[Sergei Golubchik]

Hi!

On Dec 04, David Turner wrote:
> I've always thought it would be great if there was a way to drop an object but
> keep the meta data so I can recreate objects without having to store the ddl 
> somewhere.
> 
> alter table drop index retain metadata
> 
> Would be helpful. 

That's what ALTER TABLE ... DISABLE KEYS is for

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: porting mysql to ibm os/390 open edition

[Sinisa Milivojevic]

Joshua J. Kugler writes:
> Not being familar with OS/390, could you explain (briefly) the difficulty?
> 
> j- k-
> 
> -- 
> Joshua Kugler, Information Services Director
> Associated Students of the University of Alaska Fairbanks
> [EMAIL PROTECTED], 907-474-7601
> 

POSIX compliancy on so many issues.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: compile problems on Solaris8

[Matthew Dougherty]

I hate to show my ignorance but I am unfamiliar with "SFW version of gcc that comes 
with Solaris 2.8".

Could you clue me in?

By the way, it is correct that I am using gcc 2.95.3 from the sunfreeware binary 
distribution.  It's been a pain for several
applications. (OpenSSH, etc).

Matt.

George Horvath wrote:

> Michael Widenius wrote:
> >
> > Hi!
> >
> > > "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes:
> >
> > 
> >
> > Michael>   * everyone who has reported this was using the precompiled binary of gcc
> > Michael>   (either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8
> > Michael>   sparc.
> >
> > Michael>   * No one has spoken up to report success with this combination.
> >
> > Michael>   * No one who built gcc from source has reported this problem.
> >
> > Michael> Unless a new piece of information comes in, it seems clear to me that
> > Michael> configure doesn't like sunfreeware's pre-compiled copy of gcc for Solaris
> > Michael> 8 sparc.  It would be nice if someone from MySQL would tell us just what
> > Michael> configure is doing when it declares sunfreeware's gcc a cross-compiler,
> > Michael> and could confirm whether this is a configure problem or a gcc problem.
> >
> > I have now added a note about this in our online manual.
> > (Sorry, I thought we already had done this).
> >
> > The bottom line seems to be that one should not use the gcc compiler
> > from sunfreeware but instead use the SFW version of gcc that comes
> > with Solaris 2.8 or download the gcc source and compile it.
> >
> > The reason configure declares sunfreeware a cross compiler is that
> > gcc succeed in compiling a simple test program but the program would
> > not run. Based on this configure concludes that the compiler doesn't
> > generate a working binary for this architecture and must thus be a
> > cross compiler to another architecture.
>
> Ok, I followed your advice and removed the soaris built gcc from sunfreeware and 
>downloaded the source instead.  How ever now
> I am getting this message when I try to compile gcc:
>
> # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu
> Configuring for a sparc-sun-solaris2.8 host.
> Created "Makefile" in /usr/local/objdir using "mh-frag"
> /usr/ucb/cc:  language optional software package not installed
> *** The command '/usr/ucb/cc -o conftest -g   conftest.c' failed.
> *** You must set the environment variable CC to a working compiler.
>
> How do I find out what package am I missing?  Can someone point to a site with a 
>good solaris 8 build of gcc I can use instead
> of sunfreeware.  I really prefer not to spend time on debugging the Sun compiler.  
>Unless of course it's just a simple
> addition of a package.
>
> Thanks,
> George
>
> >
> > Regards,
> > Monty
> >
> > --
> > For technical support contracts, goto https://order.mysql.com/
> >__  ___ ___   __
> >   /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]>
> >  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
> > /_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
> ><___/   www.mysql.com
>
> --
> George Horvath
> Scotia Capital Markets
> ISS - Technology Application Group
> Tel: 416-945-4204
> Fax: 416-945-4002
> E-mail: [EMAIL PROTECTED]
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem with GROUP BY ... DESC

[AJ]

Hello:

I'm new to the list and have a question.  I upgraded from version 3.22 to 
this version:

Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)

The problem that has cropped up I have is that in all GROUP BY column DESC 
statements, the DESC is now not being recognized, and the query is being 
returned in ascending order.  If I use ORDER BY... DESC that works fine.

For example, I have a database with about 25,000 records, and I get these 
results:

WORKING CORRECTLY.

select memberno from testpubl order by memberno desc limit 7

(0,0): 7395261 |
(1,0): 7395260 |
(2,0): 7395259 |
(3,0): 7395258 |
(4,0): 7395257 |
(5,0): 7395256 |
(6,0): 7395255 |

NOT WORKING...

select memberno from testpubl group by memberno desc limit 7

(0,0): 24754 |
(1,0): 24755 |
(2,0): 24805 |
(3,0): 24818 |
(4,0): 24853 |
(5,0): 24882 |
(6,0): 24961 |

(I know that in this example I could just use the ORDER BY statement, but I 
wanted to show what was going on.  I have other queries with COUNT() 
statements in them that need the GROUP BY statement and are having problems.)

It's hopefully implicit here that all these statements were working fine 
before the upgrade.  Any comments would be greatly appreciated.

AJ


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very large table load/index questions

[David Turner]

I've always thought it would be great if there was a way to drop an object but
keep the meta data so I can recreate objects without having to store the ddl 
somewhere.

alter table drop index retain metadata

Would be helpful. 

Dave
On Tue, Dec 04, 2001 at 11:19:43AM -0500, Robert Alexander wrote:
> Hi Barry,
> 
> It is, indeed, faster to load the data then create the indexes.
> 
> Instead of 'disable' and 'enable', you could try:
> - ALTER TABLE DROP index (or drop the table and create it without indexes.)
> - load your data
> - ALTER TABLE ADD index
> 
> HTH,
> 
> /Rob
> 
> 
> At 09:40 -0500 2001/12/04, Barry Roomberg wrote:
> >The actual load of a single table takes about 1/2 hour, but 
> >indexing takes DAYS.  I've recompiled '--with-raid' which allows
> >me to create a table big enough.
> 
> 
> 
> >According to the docs, it seems that the following 
> >sequence should be faster:
> >
> >Create WITH indexes defined.
> >Alter table disable indexes.
> >Load data.
> >Alter table enable indexes.
> >
> >The 'enable' and 'disable' seem to be strictly a MySQL 4.0
> >command, which I didn't initially DL, so I'm setting that
> >up now.
> ~
> Robert Alexander, Alpha Geek, Workmate.ca
> WWW Database Applications and Web Hosting
> http://www.workmate.ca   416-823-6599
> mailto:[EMAIL PROTECTED]
> 
> "Life's unfair - but root password helps!"
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Select with Left Joins

[pa]

Perhaps this is obvious, but I have a SELECT (with many LEFT JOINs) that I would 
expect to return results, but it does not.  If I make one change in the order 
in which tables are used, the SELECT works:

The SQL that doesn't work is:
---
SELECT T1.patentNumber, T1.title, T2.ipvMap, T3.claimCode, T2.numOfFC, T2.numOfBC
FROM usptoDataTable AS T1
LEFT JOIN ipvDataTable AS T2 USING (patentNumber)
LEFT JOIN clientDataTable AS T3 USING (patentNumber)
LEFT JOIN iPlanetDataTable AS T4 USING (patentNumber)
WHERE T4.sunPatentNumber LIKE '%P%'
LIMIT 10
---

No rows are returned even though there are lots of rows in table T4 that fit the 
criteria.
Changing the order of the LEFT JOIN of T3 and T4 returns 10 rows. The SQL that works 
is:  
---
SELECT T1.patentNumber, T1.title, T2.ipvMap, T3.claimCode, T2.numOfFC, T2.numOfBC
FROM usptoDataTable AS T1
LEFT JOIN ipvDataTable AS T2 USING (patentNumber)
LEFT JOIN iPlanetDataTable AS T4 USING (patentNumber)< order of these two is 
swapped but alias name unchanged
LEFT JOIN clientDataTable AS T3 USING (patentNumber) < order of these two is 
swapped but alias name unchanged
WHERE T4.sunPatentNumber LIKE '%P%'
LIMIT 10
---

Is this a bug or user error?
Paul Albrecht



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very large table load/index questions

[Robert Alexander]

Hi Barry,

It is, indeed, faster to load the data then create the indexes.

Instead of 'disable' and 'enable', you could try:
- ALTER TABLE DROP index (or drop the table and create it without indexes.)
- load your data
- ALTER TABLE ADD index

HTH,

/Rob


At 09:40 -0500 2001/12/04, Barry Roomberg wrote:
>The actual load of a single table takes about 1/2 hour, but 
>indexing takes DAYS.  I've recompiled '--with-raid' which allows
>me to create a table big enough.



>According to the docs, it seems that the following 
>sequence should be faster:
>
>Create WITH indexes defined.
>Alter table disable indexes.
>Load data.
>Alter table enable indexes.
>
>The 'enable' and 'disable' seem to be strictly a MySQL 4.0
>command, which I didn't initially DL, so I'm setting that
>up now.
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca   416-823-6599
mailto:[EMAIL PROTECTED]

"Life's unfair - but root password helps!"

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: killed by SIGSEGV

[matt]

On Tue, 4 Dec 2001, Ken Menzel wrote:
> Your platform: Linux?  What version?  your kernel?

Sorry, I should have included this information in my first post. 

The hardware is a Dell 2550 poweredge with a 1GHz Intel 3, 500MB ECC
RAM, 2 SCSI disks in RAID and some intel NICS.

The OS is GNU/Linux 2.4.4 patched for Dell's RAID.  The distro is
my own (based on LFS and Slackware).  Library info below.

Here are some details from mysqlbug:

>Release:   mysql-3.23.31 (Source distribution)

System: Linux bertha 2.4.4 #2 SMP Thu Aug 23 15:43:39 BST 2001 i686
unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from
/usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''
LDFLAGS=''
LIBC:
lrwxrwxrwx   1 root root   13 Aug 17 12:14 /lib/libc.so.6
-> libc-2.1.3.so
-rwxr-xr-x   1 root root  4186643 May  3  2001
/lib/libc-2.1.3.so
-rw-r--r--   1 root root 20332328 May  3  2001 /usr/lib/libc.a
-rw-r--r--   1 root root  178 May  3  2001
/usr/lib/libc.so
Configure command: ./configure  --prefix=/usr/local/mysql

Here are the first 3 lines from /proc/meminfo:

total:used:free:  shared: buffers:  cached:
Mem:  525471744 508993536 164782080 10096640 361168896
Swap: 304324608   131072 304193536

Fractional usage of swap indicates that the machine isn't being
pushed, and indeed the load is usually low.

> What is your my.cnf?  

I don't have a my.cnf, so I assume its all defaults - do you know
where I can find this out or would I be advised to work out my own
custom config for this machine based on the my-medium.cnf or
my-large.cnf files in share/mysql?
 
> Many time a signal 11 indicates a Harware/memory problem are you
> running ECC memory?

I currently have 500MB ECC RAM, supplied by Dell. I used to get this
problem on an old Linux box with some dodgy RAM. It would be fine
until I compiled big programs. This box has been fine though, I've
compiled the kernel no problem 10s of times.

Hopefully thats covered everything,

thanks again - Matt.

-- 
#!/usr/bin/perl
$A='A';while(print+($A.=(grep{($A=~/(...).{78}$/)[0]eq$_}"  A A A  "
=~m{(...)}g)?"A":" ")=~/([ A])$/){if(!(++$l%80)){print"\n";sleep 1}}



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Fixed MYSQL password problem!

[Richard S. Huntrods]

I fixed the problem I just posted with MySql new installs "not seeing"
my passwords.

I had simply forgotten to flush the permissions after I set the
password.

"mysqladmin -u root flush-privileges"

Cheers,

-Richard




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

conditional delete query

[Chris Newland]

Hi All,

I'm having trouble forming a delete query that removes rows from a table
based on a condition that requires joining 3 tables (including the table to
delete from).

The SELECT query that identifies the rows to delete is:

SELECT folder_items.folder_id, folder_items.item_id FROM folders,
folder_items, past_events WHERE past_events.event_id=folder_items.item_id
AND folders.folder_type='events' AND
folders.folder_id=folder_items.folder_id;

I've tried

DELETE FROM folder_items WHERE folder_item IN ( query that selects
folder_items) AND folder_id IN ( query that selects folders)

and I've also tried selecting the rows to delete into a temporary table and
then deleting based on rows in the temporary table but the statements just
produce SQL syntax errors.

I'm using MySQL 3.23.40 and I know the functionality I need is in 4.0 but I
wasn't planning on updating just yet.

I can solve this problem by copying the rows I want to keep into a new
table, dropping the old table, and renaming the new one but I'm not
confident about the synchronization when doing this on a live database.

Does anybody have any advice on conditional deletes?

Thanks a lot,

Best Regards,

Chris



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: compile problems on Solaris8

[George Horvath]

Michael Widenius wrote:
> 
> Hi!
> 
> > "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes:
> 
> 
> 
> Michael>   * everyone who has reported this was using the precompiled binary of gcc
> Michael>   (either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8
> Michael>   sparc.
> 
> Michael>   * No one has spoken up to report success with this combination.
> 
> Michael>   * No one who built gcc from source has reported this problem.
> 
> Michael> Unless a new piece of information comes in, it seems clear to me that
> Michael> configure doesn't like sunfreeware's pre-compiled copy of gcc for Solaris
> Michael> 8 sparc.  It would be nice if someone from MySQL would tell us just what
> Michael> configure is doing when it declares sunfreeware's gcc a cross-compiler,
> Michael> and could confirm whether this is a configure problem or a gcc problem.
> 
> I have now added a note about this in our online manual.
> (Sorry, I thought we already had done this).
> 
> The bottom line seems to be that one should not use the gcc compiler
> from sunfreeware but instead use the SFW version of gcc that comes
> with Solaris 2.8 or download the gcc source and compile it.
> 
> The reason configure declares sunfreeware a cross compiler is that
> gcc succeed in compiling a simple test program but the program would
> not run. Based on this configure concludes that the compiler doesn't
> generate a working binary for this architecture and must thus be a
> cross compiler to another architecture.

Ok, I followed your advice and removed the soaris built gcc from sunfreeware and 
downloaded the source instead.  How ever now
I am getting this message when I try to compile gcc:

# /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu
Configuring for a sparc-sun-solaris2.8 host.
Created "Makefile" in /usr/local/objdir using "mh-frag"
/usr/ucb/cc:  language optional software package not installed
*** The command '/usr/ucb/cc -o conftest -g   conftest.c' failed.
*** You must set the environment variable CC to a working compiler.

How do I find out what package am I missing?  Can someone point to a site with a good 
solaris 8 build of gcc I can use instead
of sunfreeware.  I really prefer not to spend time on debugging the Sun compiler.  
Unless of course it's just a simple
addition of a package.


Thanks,
George

> 
> Regards,
> Monty
> 
> --
> For technical support contracts, goto https://order.mysql.com/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
> /_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
><___/   www.mysql.com

-- 
George Horvath  
Scotia Capital Markets 
ISS - Technology Application Group
Tel: 416-945-4204
Fax: 416-945-4002
E-mail: [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Probably something very simple...

[Richard S. Huntrods]

Greetings!

I am having a real silly problem - probably something simple I've
forgotten.

I have been running mysql 3.23.39a on both Windows and Solaris for 5
months now, no problems.

I just upgraded the windows machine to mysql 4alpha, and had a problem
with passwords.  I have one key user database that is password protected
(the servlet login has a password on it).  If I didn't supply a password
to WinMysqlAdmin on the first start-up, then passwords appeared to be
disabled.  If I erase my.ini and supply a password, everything worked
OK.

Now to Solaris.  I am quite sure that for 3.23.39, I only had to unpack
the binary, run the initialization script, and set some permissions.  I
have done that, and mysql 4 alpha works fine - *except*, passwords seem
to be turned off.  The test account has a password, but if I supply it,
I cannot log in.  If I don't supply the password, I can log in. In my
3.23.39 version, I did not have a password on the root account.

How do you "turn on" passwords in the Unix (Solaris) version?

Thanks,

-Richard


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: killed by SIGSEGV

[Ken Menzel]

Matt it would help to know:
Your platform: Linux?  What version?  your kernel?
Which MySQL version?
Did you compile it your self?  Using what options?
What is your my.cnf?  Are you running low on resources?

Many time a signal 11 indicates a Harware/memory problem are you
running ECC memory?

You need to provide more info than just the error: also try using
mysqlbug to generate a bug report.

Ken
- Original Message -
From: "matt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 04, 2001 10:01 AM
Subject: killed by SIGSEGV


> Hello list,
>
> I've got a problem with mysql being killed by signal 11
(segmentation
> violation). It gets killed on average every 4 days, and on that day
it
> will on averate get killed 4 times. Sometimes it will be as many as
8
> times, sometimes only once (see below for log).
>
> I've read 'Debugging a MySQL server' in the manual, and have taken
the
> stacktrace (which is the same everytime it gets killed) and resolved
> it to get:
>
> 0x400645e2 _end + 937899586
> 0x40063bc2 _end + 937896994
> 0x80bcd6e create_new_thread__FP3THD + 638
> 0x80bd232 handle_connections_sockets__FPv + 1058
> 0x80bc8e5 main + 2625
> 0x400e89b7 _end + 938441239
> 0x8088821 _start + 33
>
> Unsurprisingly, this doesn't help me out much except that it looks
> like it happens when a new thread is created.
>
> As I said, I have read the online manual so I know that this may not
> help anyone else out either, but I have no idea how to get the fault
> to happen on demand - so this seems like a good enough way to start.
> If anyone can make any suggestions on tests/things to try then
> please do.
>
> Thanks, Matt
>
>
> This is what a typical log entry looks like:
> 
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tells you how to use a
> stack trace and/or the core file to produce a readable backtrace
that
> may
> help in finding out why mysqld died
> Attemping backtrace. You can use the following information to find
out
> where mysqld died.  If you see no messages after this, something
went
> terribly wrong
> Cannot determine thread, ebp=0xb484, backtrace may not be
correct
> stack range sanity check, ok, backtrace follows
> 0x400645e2
> 0x40063bc2
> 0x80bcd6e
> 0x80bd232
> 0x80bc8e5
> 0x400e89b7
> 0x8088821
> New value of ebp failed sanity check terminating backtrace
>
> Number of processes running now: 0
> 011129 12:16:57  mysqld restarted
> /usr/local/mysql/libexec/mysqld: ready for connections
>
> This is how often it gets killed (these are all caused by SIGSEGV)
> 
> $ grep -e 'mysqld restarted' bertha.err | uniq -w6 -c
> 1 010930 19:10:32  mysqld restarted
> 8 011001 09:40:39  mysqld restarted
> 2 011002 09:49:22  mysqld restarted
> 3 011020 09:16:26  mysqld restarted
> 3 011025 14:00:11  mysqld restarted
> 7 011026 13:46:05  mysqld restarted
> 1 011029 20:01:59  mysqld restarted
> 2 011031 12:29:03  mysqld restarted
> 1 011107 16:24:05  mysqld restarted
> 2 02 13:39:32  mysqld restarted
> 7 03 14:52:30  mysqld restarted
> 7 011120 15:04:52  mysqld restarted
> 4 011122 11:46:56  mysqld restarted
> 4 011126 09:45:53  mysqld restarted
> 6 011127 10:12:18  mysqld restarted
> 1 011129 12:16:57  mysqld restarted
>
> --
> #!/usr/bin/perl
> $A='A';while(print+($A.=(grep{($A=~/(...).{78}$/)[0]eq$_}"  A A A  "
> =~m{(...)}g)?"A":" ")=~/([ A])$/){if(!(++$l%80)){print"\n";sleep 1}}
>
>
> 
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very large table load/index questions

[Sergei Golubchik]

Hi!

On Dec 04, Barry Roomberg wrote:
> I'm trying to understand the most efficient load sequence 
> possible.
> 
> I've got 2 large tables. Each is about 50 million rows,
> taking about 20GB of disk space.
> 
> My system is a dual PIII 850, running Linux 2.4.2-2smp #1 SMP.
> Memory: 1GB.
> 
> The actual load of a single table takes about 1/2 hour, but 
> indexing takes DAYS.  I've recompiled '--with-raid' which allows
> me to create a table big enough.

Why do you need RAID ? Are you using ext2fs ?
With 2.4.2 you can use reiserfs, which does not have 2GB file limit.

Are you sure MySQL uses "repair by sorting" ?
SHOW PROCESSLIST can be used to verify (after first 1/2 hour that is,
when all the data are loaded).

Below, I assume it's "repair by sort"

> Here's my start MySQL command:
> nohup nice --10 /usr/local/libexec/mysqld \
> --basedir=/usr/local \
> --datadir=/var/lib/mysql \
> --user=mysql \
> --pid-file=/var/lib/mysql/ramius.xxx.com.pid \
> --skip-locking  \
> -O key_buffer=512M \

It's not that important for bulk loading.

> -O max_allowed_packet=1M \
> -O table_cache=256 \
> -O sort_buffer=64M \
> -O record_buffer=1M \
> -O myisam_sort_buffer_size=128M \

This one you'd like to increase to 512M or even more -
you can devote all your free memory to that.

> Here's the critical part of the table create script:
> 
> create table ind_1101 (
> FINDER_NUMBER_IND VARCHAR(10),
> FINDER_NUMBER_HH VARCHAR(10),
> DATE_ON_BASE DATE ,
> ...
> 100 fields later
> )
> TYPE=MyISAM
> RAID_TYPE=STRIPED
> RAID_CHUNKS=30
> RAID_CHUNKSIZE=1
> MIN_ROWS=6000
> MAX_ROWS=5

It's not all critical parts.
What indexes are in ?

> Create WITH indexes defined.
> Alter table disable indexes.
> Load data.
> Alter table enable indexes.

If you use LOAD DATA INFILE (which is recommended) into empty table,
then you need not ALTER TABLE. Having one INSERT per row is the most
inefficient approach.  INSERT ... VALUES (...),(...),(...)... is better,
but you cannot put all your 20GB in one INSERT - it's limited by packet
size.  LOAD DATA INFILE allows you to load all the 20GB in one statement.

> The 'enable' and 'disable' seem to be strictly a MySQL 4.0
> command, which I didn't initially DL, so I'm setting that
> up now.

Yes, but they are simply convenient shortcuts to

myisamchk --keys-used=0 -rq

You can enable/disable keys from command line in 3.23.

> Is there anything else I should be looking at?
> Is there a large table FAQ?

No. Only "Speed of `INSERT' Queries" section in the manual,
but you've read it already.

Note that myisam_bulk_insert_tree_size variable,
as mentioned in the 4.0 manual, does nothing for "repair-by-sort".

> Will I cut the time in 1/2 buy putting it on a 
> Dual 2GHZ Xeon (waiting for a test box right now)?

It depends. If the speed in CPU-bound (`top' shows 99% CPU load),
then adding some MHz to CPU will help. If CPU is mostly idle,
then ... you have to tune up mysqld variables :-)

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: killed by SIGSEGV

[Sasha Pachev]

On Tuesday 04 December 2001 07:57 am, matt wrote:
> I've got a problem with mysql being killed by signal 11 (segmentation
> violation). It gets killed on average every 4 days, and on that day it
> will on averate get killed 4 times. Sometimes it will be as many as 8
> times, sometimes only once (see below for log).

First make sure you are using our binary and that you have a stable kernel. 
Then double-check your hardware. Those two should solve this problem.

-- 
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
   <___/  

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

unicode & mysql?

[Dorin Ioan MARINCA]

Hi!

I want to keep unicode text strings as data in a SQL database and I
search for a proper free DBMS.
Of course unicode data can be stored as binary data but in a char,
varchar column?

I need to insert, get unicode strings into/from databases not
modified/altered by locale configs.
I need to create an index on this coloumn, maybe with a modifiable
sorting order. In fact, I need doing sorting on unicode strings, but not
a sort based on binary comparison of data strings.
I need at least one API (e.g. C, C++, python, php) which supports
unicode based request.

What is the mysql status in the unicode field?
If mysql cannot do these thinks, can I have some hints... 

Thanks,
Dorin

PS: Sorry for errors, I'm rather new to database world...

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Hacked Servers

[Robert Cross]

mysql at hotchilli.co.uk wrote:
>We have 2 Redhat 6.1 servers and MySQL 3.22.32 and both boxes
>appear to have been hacked on Friday last and MYSQL client just hangs
>when connecting to the localhost MYSQL server.
>MySQL is running on both boxes and suffer the same problems.
>We have Intrusion software but its very long winded trying to find how to
>fix it - and ultimately we will re-install.

I found a neat checklist on one of the official sites, (CERT, etc) and
their recommendations
were something along the lines of.

1.   Network isolate all infected machines.
2.   Get backups of user data, at least two, and verified if possible. Also
save any local
configuration files for the applications. Don't save any o/s
configurations, such as /etc/services,
unless absolutely necessary.
3.   Reformat disk on infected machine and reload o/s from known clean
source
4.   Add local configurations.
5.   Add o/s and application patches, concentrating especially on security
ones.
6.   Restore user data, being careful not to restore any user scripts or
more especially
executables until such time that they can be proven to be untampered with.

Personally I'd seriously think about upgrading from '6.1 to a 7.x distro so
you can get the
RedHat support.

Regards

Bob Cross.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
This message is confidential.  It may also be privileged or
protected by other legal rules.  It does not constitute an
offer or acceptance of an offer, nor shall it form any part
of a legally binding contract.  If you have received this
communication in error, please let us know by reply then
destroy it.  You should not use, print, copy the message or
disclose its contents to anyone.

E-mail is subject to possible data corruption, is not
secure, and its content does not necessarily represent the
opinion of this Company.  No representation or warranty is
made as to the accuracy or completeness of the information
and no liability can be accepted for any loss arising from
its use.

This e-mail and any attachments are not guaranteed to be
free from so-called computer viruses and it is recommended
that you check for such viruses before down-loading it to
your computer equipment.  This Company has no control over
other websites to which there may be hypertext links and no
liability can be accepted in relation to those sites.

Scottish & Newcastle plc
Registered in Scotland, Registered Number 16288
Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqladmin reload not rebuilding GRANT information

[Sinisa Milivojevic]

Carl Troein writes:
> 
> 
> Does this mean that mysqld keeps its own cache of hostnames,
> and that it never checks to see if it has gone stale? If so,
> one might have to shut down and restart the server at regular
> intervals (once an hour or whatever) if one relies on host
> names (maybe not a good idea unless you can control the DNS
> server and/or hosts file) for additional security. This, of
> course, assuming that the name<->address mapping isn't
> absolutely constant, but it rarely is.
> 
> //C
> 
> -- 
>  Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
>  [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
>  Amiga user since '89, and damned proud of it too.

Yes, that is so.

But you do not have to restart MySQL. Just run:

FLUSH HOSTS

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

unable to assign desired memory

[Richard Clarke]

Hi,
I have a box with 1gig ram which i am using as my mysql server. however
when i try to assig about 600megs to the innodb buffer pool it reports that,

InnoDB: Fatal error: cannot allocate 524304384 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 21180112 bytes. Operating system errno: 12
InnoDB: Cannot continue operation!
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
011204 15:09:49  mysqld ended

my ulimits are set to unlimited and top tells me,
Mem: 5468K Active, 11M Inact, 18M Wired, 10M Buf, 969M Free

Any ideas why it won't take the memory I assign it?

Rich


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

killed by SIGSEGV

[matt]

Hello list,

I've got a problem with mysql being killed by signal 11 (segmentation
violation). It gets killed on average every 4 days, and on that day it
will on averate get killed 4 times. Sometimes it will be as many as 8
times, sometimes only once (see below for log).

I've read 'Debugging a MySQL server' in the manual, and have taken the
stacktrace (which is the same everytime it gets killed) and resolved
it to get:

0x400645e2 _end + 937899586
0x40063bc2 _end + 937896994
0x80bcd6e create_new_thread__FP3THD + 638
0x80bd232 handle_connections_sockets__FPv + 1058
0x80bc8e5 main + 2625
0x400e89b7 _end + 938441239
0x8088821 _start + 33

Unsurprisingly, this doesn't help me out much except that it looks
like it happens when a new thread is created.

As I said, I have read the online manual so I know that this may not
help anyone else out either, but I have no idea how to get the fault
to happen on demand - so this seems like a good enough way to start.
If anyone can make any suggestions on tests/things to try then
please do.

Thanks, Matt


This is what a typical log entry looks like:

mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that
may
help in finding out why mysqld died
Attemping backtrace. You can use the following information to find out
where mysqld died.  If you see no messages after this, something went
terribly wrong
Cannot determine thread, ebp=0xb484, backtrace may not be correct
stack range sanity check, ok, backtrace follows
0x400645e2
0x40063bc2
0x80bcd6e
0x80bd232
0x80bc8e5
0x400e89b7
0x8088821
New value of ebp failed sanity check terminating backtrace

Number of processes running now: 0
011129 12:16:57  mysqld restarted
/usr/local/mysql/libexec/mysqld: ready for connections

This is how often it gets killed (these are all caused by SIGSEGV)

$ grep -e 'mysqld restarted' bertha.err | uniq -w6 -c 
1 010930 19:10:32  mysqld restarted
8 011001 09:40:39  mysqld restarted
2 011002 09:49:22  mysqld restarted
3 011020 09:16:26  mysqld restarted
3 011025 14:00:11  mysqld restarted
7 011026 13:46:05  mysqld restarted
1 011029 20:01:59  mysqld restarted
2 011031 12:29:03  mysqld restarted
1 011107 16:24:05  mysqld restarted
2 02 13:39:32  mysqld restarted
7 03 14:52:30  mysqld restarted
7 011120 15:04:52  mysqld restarted
4 011122 11:46:56  mysqld restarted
4 011126 09:45:53  mysqld restarted
6 011127 10:12:18  mysqld restarted
1 011129 12:16:57  mysqld restarted

-- 
#!/usr/bin/perl
$A='A';while(print+($A.=(grep{($A=~/(...).{78}$/)[0]eq$_}"  A A A  "
=~m{(...)}g)?"A":" ")=~/([ A])$/){if(!(++$l%80)){print"\n";sleep 1}}


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Optimizing date queries

[Emil Rasmussen]

> SELECT count(id)
> FROM tblTabel
> WHERE fieldName != '' AND
> (
> myDateField >= 2001112000 AND
> myDateField < 2001113000
> );

Thank you, that was defiantly part of the solution!

I had created an index on both fieldName og myDateField, but MySQL did not
use that. But creating an index only on myDateField did the trick.

Thanks for the help!

Mvh Emil
--
Emil Rasmussen
http://noget.net


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqladmin reload not rebuilding GRANT information

[Carl Troein]

Sinisa Milivojevic writes:

> > We found that, if you alter the permission tables (user) & /etc/hosts
> > (so that it can do IP-address-to-hostname mapping for the hosts named in
> > "user") & say "mysqladmin reload", mysql doesn't pick up the changes -
> > you have to shut it down totally & restart it.
> 
> mysqladmin reload only reloads info from MySQL privilege tables.

Does this mean that mysqld keeps its own cache of hostnames,
and that it never checks to see if it has gone stale? If so,
one might have to shut down and restart the server at regular
intervals (once an hour or whatever) if one relies on host
names (maybe not a good idea unless you can control the DNS
server and/or hosts file) for additional security. This, of
course, assuming that the name<->address mapping isn't
absolutely constant, but it rarely is.

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Load data infile

[Mike(mickalo)Blezien]

Thanks john,

After some further checking, the files that I was trying to load back into the
db where sent to me from a MAC, and had some strange C/R's in it, causing the
file be formatted improperly! After fixing that, all the files loaded into the
db fine! :)

thx's


>>On Tue, 4 Dec 2001 08:45:27 -0600, "john" <[EMAIL PROTECTED]>   wrote:

>>remove your line termination and it will not look for this non-existing data
>>and run through the whole file.
>>john
>>
>>-Original Message-
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, December 03, 2001 10:11 PM
>>To: [EMAIL PROTECTED]
>>Subject: Load data infile
>>
>>
>>Be struggling with this all day, try to figure out why when using the 'load
>>data
>>infile..' all it loads is the first line for the text file and that's it!
>>
>>Table structure:
>>CREATE TABLE `retailtag` (
>>  `prodid` smallint(4) NOT NULL default '0',
>>  `tagnumber` varchar(10) NOT NULL default '',
>>  `code` varchar(10) NOT NULL default '',
>>  UNIQUE KEY `tagnumber` (`tagnumber`,`code`),
>>  KEY `prodid` (`prodid`)
>>) TYPE=MyISAM;
>>
>>QUERY:
>>$mysql> load data local infile '/home/tracerta/tmp/retailtag.txt' into table
>>retailtag  fields terminated by '|' lines terminated by '\n';
>>
>>the text file is contructed as such:
>>
>>ID|NUM|CODE
>>ID|NUM|CODE
>>ID|NUM|CODE
>>etc
>>
>>approx., 1600 records
>>But it only grabs the file line, and stops. I've tried it with a CSV format,
>>and
>>TAB format, still the same thing, grabs the first line, and that's it??
>>
>>is the file in the wrong format??

Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Load data infile

[john]

remove your line termination and it will not look for this non-existing data
and run through the whole file.
john

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 10:11 PM
To: [EMAIL PROTECTED]
Subject: Load data infile


Be struggling with this all day, try to figure out why when using the 'load
data
infile..' all it loads is the first line for the text file and that's it!

Table structure:
CREATE TABLE `retailtag` (
  `prodid` smallint(4) NOT NULL default '0',
  `tagnumber` varchar(10) NOT NULL default '',
  `code` varchar(10) NOT NULL default '',
  UNIQUE KEY `tagnumber` (`tagnumber`,`code`),
  KEY `prodid` (`prodid`)
) TYPE=MyISAM;

QUERY:
$mysql> load data local infile '/home/tracerta/tmp/retailtag.txt' into table
retailtag  fields terminated by '|' lines terminated by '\n';

the text file is contructed as such:

ID|NUM|CODE
ID|NUM|CODE
ID|NUM|CODE
etc

approx., 1600 records
But it only grabs the file line, and stops. I've tried it with a CSV format,
and
TAB format, still the same thing, grabs the first line, and that's it??

is the file in the wrong format??

thx's

mysql database sql

Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem making myodbc on Solaris 8

[Matthew Dougherty]

The same error occurs with 2.50.39.

Has anyone successfully made MyODBC on Solaris8 using gcc 2.95??

Matt Dougherty

Venu wrote:

> Hi,
>
> > -Original Message-
> > From: Matthew Dougherty [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 03, 2001 11:06 AM
> > To: [EMAIL PROTECTED]
> > Subject: Problem making myodbc on Solaris 8
> >
> >
> > make fails with mksh: Fatal error in reader:  = missing from replacement
> >
> > macro reference
> >Current working directory
> > /opt/perlModules/MyODBC-2.50.37
> >
> > I have ODBC working for SQL Server.
> >
> > If I do a make -V is leads me to a bad set of lines in Makefile:
> >
> > DEPS_MAGIC := $(shell mkdir .deps > /dev/null 2>&1 ||:)
> >
> > -include $(DEP_FILES)
> >
> > If I take out the colon on the :=, I don't get an error.
> >
> > Is the -include a typo?  I don't see a matching subroutine in
> > Makefile.  If I change it to include $(DEP_FILES) it can't find the
> > files.
> >
> > DEP_FILES is previously defined as a list of files in .deps.
> >
> >
> > I am running as root using GCC 2.95.  I have a separate build of perl
> > that I am using instead of /usr/bin/perl on Solaris 8.
> >
> > The PATH is set to
> > /usr/local/bin:/usr/local/mysql/bin:/usr/bin:/usr/sbin:/usr/ccs/bin
> > I am using the make in /usr/ccs/bin.
> >
> > The LD_LIBRARY_PATH is set to /usr/local/lib:/usr/local/mysq:/usr/lib
> >
> > The configure command is as follows:
> >
> > ./configure --with-odbc-ini=/etc/odbc.ini
> > --with-iodbc-includes=/usr/local/openlink/w3configu/include
> > --with-iodbc-libs=/usr/local/openlink/lib
> > --with-mysql-dirs=/usr/local/mysql/lib/mysql
> > --with-mysql-includes=/usr/local/mysql/include/mysql
> >
> >
> Can you download and try the latest version 2.50.39(unix source)
> from:
> http://www.mysql.com/downloads/api-myodbc.html
>
> Regards, Venu
> --
> For technical support contracts, go to https://order.mysql.com
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /   Mr. Venu <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
> /_/  /_/\_, /___/\___\_\___/  California, USA
><___/  www.mysql.com
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Very large table load/index questions

[Barry Roomberg]

I'm trying to understand the most efficient load sequence 
possible.

I've got 2 large tables. Each is about 50 million rows,
taking about 20GB of disk space.  My disk is accessed
via fibre channel, and can read/write about 40 MB per
second.

My system is a dual PIII 850, running Linux 2.4.2-2smp #1 SMP.
Memory: 1GB.

I've "downgraded" my compiler to GCC 2.95-3, and can compile
MySQL.

The actual load of a single table takes about 1/2 hour, but 
indexing takes DAYS.  I've recompiled '--with-raid' which allows
me to create a table big enough.

The queries are very fast, which is why I am attempting this.  
I currently use Oracle, but would like to offload to MySQL as
much as possible.  Once I prove this out, I figure the support
contract is WAY cheaper than my Oracle licenses for new projects.
Total Oracle load, index, analyze for this data is about 1/2 a day.

Here's my start MySQL command:
nohup nice --10 /usr/local/libexec/mysqld \
--basedir=/usr/local \
--datadir=/var/lib/mysql \
--user=mysql \
--pid-file=/var/lib/mysql/ramius.xxx.com.pid \
--skip-locking  \
-O key_buffer=512M \
-O max_allowed_packet=1M \
-O table_cache=256 \
-O sort_buffer=64M \
-O record_buffer=1M \
-O myisam_sort_buffer_size=128M \
-O thread_cache=8 \
-O thread_concurrency=4\
--port=3306 \
--skip-networking \
--tmpdir=/xy/local/tmp/ \
--warnings  \
--log=/xy/local/tmp/mysql.log \
&

It eats about 512 MB.

Here's the critical part of the table create script:

create table ind_1101 (
FINDER_NUMBER_IND VARCHAR(10),
FINDER_NUMBER_HH VARCHAR(10),
DATE_ON_BASE DATE ,
...
100 fields later
)
TYPE=MyISAM
RAID_TYPE=STRIPED
RAID_CHUNKS=30
RAID_CHUNKSIZE=1
MIN_ROWS=6000
MAX_ROWS=5

I do the load of the data and then index via a single
alter statement rather than a series of creates, to avoid
many table copies.  Note:  I get my best load performance 
by allowing 2 source files to be loaded at the same time.
If I do 1, then I don't fill the pipeline, and if I do 3,
the disk seems to thrash and wait time goes up.  I never
use more than a single CPU during this process.

I've tried InnoDB, but it loads too slow.

According to the docs, it seems that the following 
sequence should be faster:

Create WITH indexes defined.
Alter table disable indexes.
Load data.
Alter table enable indexes.

The 'enable' and 'disable' seem to be strictly a MySQL 4.0
command, which I didn't initially DL, so I'm setting that
up now.

Is there anything else I should be looking at?
Is there a large table FAQ?
Will I cut the time in 1/2 buy putting it on a 
Dual 2GHZ Xeon (waiting for a test box right now)?

Thanks for reading this far.

Barry

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Some questions to the pre-sale technical support of MySQL

[Sinisa Milivojevic]

Hofhauser, Bela writes:
> Hi,
> 
> we already use Databases in our full distributed environment, but we are looking for 
>alternatives, especially for an SQL Database system with a fail-save synchronous 
>master - slave replication architecture. 
> I searched on the internet pages of  www.mysql.com, but could not decide the 
>functionality of  MySQL in this field. 
> On same places it is mentioned as a future feature of V4.0, in the documentation we 
>can read about replication in V3.23.15. 
> Is this a synchronous replication ? 
> What is the correct state of versions and replication functions ?
> Have you a road map for V4.x?
> Who can we contact for eventually pre-sale technical questions ? 
> 
> Thanks and 
> Best Regards
> 
> Béla Hofhauser
> Fujitsu-Siemens Computers
> RTP Team
> Tel.: +49 98 636-40793
> 

Hi!

MySQL 3.23 already has synchronous replication. It is in a widespread
use already.

MySQL 4.0 will have a replication agent for fail-safe replication,
which would make possible changing of roles between master / slave on
the run.  

You can send mails to me directly if you wish some additional info. 

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqladmin reload not rebuilding GRANT information

[Sinisa Milivojevic]

[EMAIL PROTECTED] writes:
> >Description:
> We found that, if you alter the permission tables (user) & /etc/hosts
> (so that it can do IP-address-to-hostname mapping for the hosts named in
> "user") & say "mysqladmin reload", mysql doesn't pick up the changes -
> you have to shut it down totally & restart it.
> 

The above is not a bug.

mysqladmin reload only reloads info from MySQL privilege tables.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Optimizing date queries

[Gordan Bobic]

On Tuesday 04 Dec 2001 13:49, Emil Rasmussen wrote:
> Hey
>
> Does anyone have some optimization tips for this query:
>
> SELECT count(id) FROM tblTabel WHERE fieldName != '' AND
> DATE_FORMAT(myDateField,'%Y%m%d') = 20011120;
>
> It does not use the index i have created, so it scans the entire table,
> which is a bit to slow.
>
> The problem off course is, that MySQL has to do a calculation on the
> myDateField before it can decide if the row matches. Any "workarounds" for
> this?

How about:

SELECT  count(id)
FROMtblTabel
WHERE   fieldName != '' AND
(
myDateField >= 2001112000   AND
myDateField < 2001113000
);

That will use indices, and yield the same results. It will also consume less 
CPU time because you don't have to play with string parsing for the date 
formatting.

HTH.

Gordan

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

access denied for user:

[josep]

(Debian Linux 2.2)

trying (logged in as the owner of the database):

mysql guestbook.sql   (database is palced in my home directory)

I get:

access denied for user: '@localhost' to database 'guestbook.sql'

What is going wrong?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL access denied from localhost

[mweb]

I know this is a probably a FAQ, and have read 
http://www.mysql.com/doc/A/c/Access_denied.html, but everything looks OK to 
me. If I look at the mysql db from the monitor I get all the privileges OK 
for user "testuser" (see below, and still (from PHP UnixOdbc on Apache) get 
thist message when I do $cnx = odbc_connect( 'domain' , 'testuser', '' );
I haven't run the mysql_install_db because I read somewhere it's part of the 
rpm
install on RH 7.2, but apart from that, I've done anything explained in the 
web page above. SUggestions?

mweb

mysql> select * from host;
+---+---+-+-+-+-+-+---++-+++
| Host  | Db| Select_priv | Insert_priv | Update_priv | 
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | 
Index_priv | Alter_priv |
+---+---+-+-+-+-+-+---++-+++
| localhost | domain| Y   | Y   | Y   | Y 
  | Y   | Y | Y  | Y   | Y  | Y   
   |
+---+---+-+-+-+-+-+---++-+++
1 row in set (0.00 sec)
mysql> select * from db;
+---+---+--+-+-+-+-+-+---++-+++
| Host  | Db| User | Select_priv | Insert_priv | Update_priv 
| Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | 
Index_priv | Alter_priv |
+---+---+--+-+-+-+-+-+---++-+++
| % | test  |  | Y   | Y   | Y   
| Y   | Y   | Y | N  | Y   | Y
  | Y  |
| % | test\_%   |  | Y   | Y   | Y   
| Y   | Y   | Y | N  | Y   | Y
  | Y  |
| localhost | domain| testuser | Y   | Y   | Y   
| Y   | Y   | Y | Y  | Y   | Y
  | Y  |
+---+---+--+-+-+-+-+-+---++-+++
3 rows in set (0.01 sec)
mysql> select * from user;
+---+--+--+-+-+-+-+-+---+-+---+--+---++-+++
| Host  | User | Password | Select_priv | Insert_priv | Update_priv | 
Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | 
Process_priv | File_priv | Grant_priv | References_priv | Index_priv | 
Alter_priv |
+---+--+--+-+-+-+-+-+---+-+---+--+---++-+++
| localhost | root |  | Y   | Y   | Y   | 
Y   | Y   | Y | Y   | Y | Y   
 | Y | Y  | Y   | Y  | Y  |
| polaris   | root |  | Y   | Y   | Y   | 
Y   | Y   | Y | Y   | Y | Y   
 | Y | Y  | Y   | Y  | Y  |
| localhost |  |  | N   | N   | N   | 
N   | N   | N | N   | N | N   
 | N | N  | N   | N  | N  |
| polaris   |  |  | N   | N   | N   | 
N   | N   | N | N   | N | N   
 | N | N  | N   | N  | N  |
| localhost | testuser |  | Y   | Y   | Y   | 
Y   | Y   | Y | Y   | Y | Y   
 | Y | Y  | Y   | Y  | Y  |
+---+--+--+-+-+-+-+-+---+-+---+--+---++-+++
5 rows in set (0.00 sec)

mysql> show tables;
+-+
| Tables_in_mysql |
+-+
| columns_priv|
| d

RE: auto increment

[Rick Emery]

You can't, except programmatically.  That is,

-Original Message-
From: Yamin Prabudy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 3:04 PM
To: [EMAIL PROTECTED]
Subject: auto increment


Hi there I have an auto increment table that starts with number 1,2,3, and
so 
on...but now it had reach 500  then for the 501 i like to have a new

format numer let say A1 (for 501) how can i do this ??
with out change the used number before (1,2.) 


thanks in advance

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: 64bit mysql and gcc

[Greg_Cope]

> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Sent: 04 December 2001 12:47
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: 64bit mysql and gcc
> 
> 
> PFIZER GLOBAL RESEARCH AND DEVELOPMENT
> 
> This message and any attachment has been virus checked by the 
> PGRD Sandwich Data Centre.
> 
> 
> Ian writes:
> > I would be more than happy to.  Could you point me in the direction
> > of the binaries?  The ones that I have found have been 32bit DBs.
> > 
> > IW.
> > 
> > 
> > 
> 
> What makes you think that our Solaris 2.8 binaries are 32bit ??
> 

>From a mysql mysql-3.23.43-sun-solaris2.8-sparc tar ball 

using file:

[13:09:58 copeg@lemur cache]$ file /WWW/servers/mysql/bin/mysqld
/WWW/servers/mysql/bin/mysqld:  ELF 32-bit MSB executable SPARC Version 1,
dynamically linked, stripped

vs a 64 bit perl:

[13:11:16 copeg@lemur cache]$ file /home/copeg/test-perl/bin/perl
/home/copeg/test-perl/bin/perl: ELF 64-bit MSB executable SPARCV9 Version 1,
dynamically linked, not stripped

Greg



PFIZER GLOBAL RESEARCH AND DEVELOPMENT

This message and any attachment has been virus checked by the 
PGRD Sandwich Data Centre.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SHOW TABLES; show nothing

[Benjamin Pflugmann]

Hi.

On Mon, Dec 03, 2001 at 08:20:44PM -0800, [EMAIL PROTECTED] wrote:
> Well, according to several subsequent messages, including
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:67549:ololjemolklapaobokil;
> 
> that does NOT appear to be the problem, as it also happens on other distros,
> with other environments and compilers...

Well, MySQL compiled with Red Hat compiler is a known issue. It very
well may be the reason. I am sorry, that I stopped reading the thread
after the RH issue was mentioned in the thread. That happened because
so often the solution is to simply try the binaries from www.mysql.com.

Btw, did you try them? And what distribution and MySQL are you using?
Do you compile MySQL yourself or use precompiled binaries? (I don't
remember seeing the info in the bug report)

This is no common problem, else the mailing list would get flooded
with this.

So I did some further mailing list digging...

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:67572:200103:gmbnbjggapiammollkem#b
suggests that it is a glibc problem (recompiling a working MySQL
version breaks things)

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:67679:200103:iognefcpicheogealmej#b
has not much to add, but for completeness...

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:65476:200102:fieefiplocfeeohppnok#b
also suggests that it is a glibc problem

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:84302:ekcmadjgfpddehoefhbb#b
suggests that there was a bug in 3.23.36 and the problem was solved by
upgrading to 3.23.41. On the other hand, I could not find in the
changes history the mention of any bug that sounds as if it could
cause this behaviour. On the other hand, the 3.23.36 version in this
thread seems to be a RH made binary, so that doesn't tell much, IMHO.

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:73746:khcijjakkgfameoghfhp#b
says that the problem occured with 3.23.38 when using a self-compiled
binary on RH, but was not reproducable with the official binary. It
also worked when compiled with an upgraded RH gcc.

Bye,

Benjamin.


> Any ideas from any MySQL developers listening?
> 
> -Original Message-
> From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 03, 2001 4:22 PM
> To: Quentin Bennett
> Cc: 'Gill, Vern'; [EMAIL PROTECTED]
> Subject: Re: SHOW TABLES; show nothing
> 
> 
> Hi.
> 
> I remember this beeing reported once before. The answer supposed that
> it was a problem with the compiler shipped with Red Hat. The mail is:
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:67476:ololjemolklapaobokil
> (and the next in thread).
> 
> If this is indeed the case, a simple fix is to use the binary provided
> on www.mysql.com.
> 
> Bye,
> 
>   Benjamin.
[...]

-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Optimizing date queries

[Emil Rasmussen]

Hey

Does anyone have some optimization tips for this query:

SELECT count(id) FROM tblTabel WHERE fieldName != '' AND
DATE_FORMAT(myDateField,'%Y%m%d') = 20011120;

It does not use the index i have created, so it scans the entire table,
which is a bit to slow.

The problem off course is, that MySQL has to do a calculation on the
myDateField before it can decide if the row matches. Any "workarounds" for
this?

Mvh Emil
--
Emil Rasmussen
http://noget.net


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Granting Access in MySQL

[Sinisa Milivojevic]

Demirchyan Oganes-AOD098 writes:
> Hello everyone,
> 
> I'm trying to grant rights to several user accessing my database.
> Right now I'm using their individual IP addresses to grant them privileges.  Which 
>works fine.
> This way I have to assign user name and password to each and everyone of them.
> 
> What I want is to enable everyone within my network to connect to my DB.  For that I 
>need a valid host name.
> I have tried %, which supposed to let everyone in, but no luck.  I also tried 
>something like 10.45.*.* or 10.45.%.%
> but no luck.  
> 
> 
> I'm stuck.  What else can I do?
> 
> Regards,
>  
> Oganes Demirchyan
> Motorola Life Science
> 757 S.Raymond
> Pasadena, CA  91105
> Tel: 626-584-5900
> email: [EMAIL PROTECTED]
> 

Try this:

grant select on *.* to user@"%" identified by "password"

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: SHOW TABLES; show nothing

[Gill, Vern]

These areI thinkpre-built
Dunno for sure.

# rpm -qa | grep -i glibc
compat-glibc-6.2-2.1.3.2
glibc-devel-2.2-5
glibc-common-2.2.4-13
glibc-2.2.4-13
# mysql --version
mysql  Ver 11.6 Distrib 3.23.28-gamma, for pc-linux-gnu (i586)
# rpm -qa | grep -i gcc
gcc-2.96-69
kgcc-1.1.2-40

Although I can't tell you if this was the case when it was built... It had
to have been a while ago. I have been trying to build a new mysql, however,
if you check the messages a few days ago, I am having compile problems. I.E;
# cd /usr/src/mysql-3.23.46/
# ./configure  --prefix=/usr/local/mysql
--with-unix-socket-path=/usr/local/mysql/lock/mysql.sock --enable-assembler
--with-libwrap --without-berkeley-db \
--with-ipv6 --without-bench --with-mysqld-ldflags=-all-static
--disable-shared --with-extra-charset=complex --without-mit-threads
--with-other-libc=/lib

make
...blah...
...blah...
Making all in client
make[2]: Entering directory `/src/mysql-3.23.46/client'
c++ -DUNDEF_THREADS_HACK -I./../include
-I../include -I./.. -I..-I..-O3
-DDBUG_OFF   -fno-implicit-templates -fno-exceptions -fno-rtti -fpermissive
-I/lib/include -c mysql.cc
cc1plus: Invalid option `-fpermissive'
In file included from client_priv.h:19,
 from mysql.cc:28:
../include/global.h:680: abstract declarator used as declaration
make[2]: *** [mysql.o] Error 1
make[2]: Leaving directory `/src/mysql-3.23.46/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/src/mysql-3.23.46'
make: *** [all-recursive-am] Error 2

Any help there?

-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 10:44 PM
To: Gill, Vern
Cc: [EMAIL PROTECTED]
Subject: Re: SHOW TABLES; show nothing


Hi.

On Mon, Dec 03, 2001 at 08:20:44PM -0800, [EMAIL PROTECTED] wrote:
> Well, according to several subsequent messages, including
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:67549:ololjemolklapaobokil;
> 
> that does NOT appear to be the problem, as it also happens on other
distros,
> with other environments and compilers...

Well, MySQL compiled with Red Hat compiler is a known issue. It very
well may be the reason. I am sorry, that I stopped reading the thread
after the RH issue was mentioned in the thread. That happened because
so often the solution is to simply try the binaries from www.mysql.com.

Btw, did you try them? And what distribution and MySQL are you using?
Do you compile MySQL yourself or use precompiled binaries? (I don't
remember seeing the info in the bug report)

This is no common problem, else the mailing list would get flooded
with this.

So I did some further mailing list digging...

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:67572:200103:gmbnbjggapiammoll
kem#b
suggests that it is a glibc problem (recompiling a working MySQL
version breaks things)

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:67679:200103:iognefcpicheogeal
mej#b
has not much to add, but for completeness...

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:65476:200102:fieefiplocfeeohpp
nok#b
also suggests that it is a glibc problem

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:84302:ekcmadjgfpddehoefhbb#b
suggests that there was a bug in 3.23.36 and the problem was solved by
upgrading to 3.23.41. On the other hand, I could not find in the
changes history the mention of any bug that sounds as if it could
cause this behaviour. On the other hand, the 3.23.36 version in this
thread seems to be a RH made binary, so that doesn't tell much, IMHO.

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:73746:khcijjakkgfameoghfhp#b
says that the problem occured with 3.23.38 when using a self-compiled
binary on RH, but was not reproducable with the official binary. It
also worked when compiled with an upgraded RH gcc.

Bye,

Benjamin.


> Any ideas from any MySQL developers listening?
> 
> -Original Message-
> From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 03, 2001 4:22 PM
> To: Quentin Bennett
> Cc: 'Gill, Vern'; [EMAIL PROTECTED]
> Subject: Re: SHOW TABLES; show nothing
> 
> 
> Hi.
> 
> I remember this beeing reported once before. The answer supposed that
> it was a problem with the compiler shipped with Red Hat. The mail is:
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:67476:ololjemolklapaobokil
> (and the next in thread).
> 
> If this is indeed the case, a simple fix is to use the binary provided
> on www.mysql.com.
> 
> Bye,
> 
>   Benjamin.
[...]

-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Connecting to mysql server in a remote site and using LOAD command

[Phillip M.(Mike) Bishop]

Make sure you have permissions to connect to the remote site from your
current server or host. Permissions need to be set for that user to connect
from your server host
- Original Message -
From: "Hamzat Kamal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 8:27 AM
Subject: Connecting to mysql server in a remote site and using LOAD command


> Dear All,
>
> I have Mysql server installed at remote site which i need to connect to.
>
> I have tried this from my local computer but didn't work;
>
> c:\mysql\bin>mysql -h myhost -u myusername -pmypassword
>
> I will also like to use LOAD command to load a text file from my local
> computer to the database on this mysql server at the remote site.
>
> I have been able to achieve both actions from my local machine.
>
> I am using win 98, Mysql 3.23
>
> All supports to get these done will be appreciated.
>
> Thanks to you all.
>
> kamal.
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Multilingual support in MYSQL

[Agarwal Hemant]

 Hi,
> 
> We have been initiating a project which requires development of
multilingual
> database. 
> 
> I need information on multilingual support of MySQL. Initial requirement
is
> of Hindi (India) Language.
> 
> Waiting for an early an dfavourable reply.
> 
> Warm Regards
> 
> Hemant K Agrawal
> Project Manager
> IT&T Limited,
> D-30, Sector 3, Noida - 201301, UP. India.
> PH : +91 1191 4442920
> FX : +91 1191 4442921
> HP : 9810265662

-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 6:50 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Multilingual support in MYSQL


Agarwal Hemant writes:
>
> 

Hi!
 Hi,
> 
> We have been initiating a project which requires development of
multilingual
> database. 
> 
> I need information on multilingual support of MySQL. Initial requirement
is
> of Hindi (India) Language.
> 
> Waiting for an early an dfavourable reply.
> 
> Warm Regards
> 
> Hemant K Agrawal
> Project Manager
> IT&T Limited,
> D-30, Sector 3, Noida - 201301, UP. India.
> PH : +91 1191 4442920
> FX : +91 1191 4442921
> HP : 9810265662
Your question has no connection to MySQL++, so please post your
question to [EMAIL PROTECTED] .


-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: start MySQL on RedHat problem

[Trong Phuc]

$mysqladmin [-u root] password [yr-pass]
or not, uninstall (rpm -e) it and install again :)
Trong Phuc

At 12:40 PM 12/4/01 +0800, Tri Tran wrote:
>I never run mySQL on this Linux box before and now it keep saying that
>
>error: 'Access denied for user: 'root@localhost' (Using password: YES)'
>
>when I try to run mysql or run mysqladmin, now to reset the password ?
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

THANKS for: Failing to connect to MySQL via unixODBC/PHP

[mweb]

Thanks to all who helped with this problem.
As it turns out, it was much stupider than one could suppose, just yet another
demonstration that nobody should code more than a very few hours in a row...

The odbc_connect statement is nested in the whole PHP code in
such a way (thanks to include, require, functions and such) that in the line 
where it is executed "odbc_connect($DSN )" the $DSN variable was
out of scope. Declaring it global brought me to this poinrt

Warning: SQL error: [unixODBC][TCX][MyODBC]Access denied for user: 
'@localhost' to database 'mbdb97', SQL state S1000 in SQLConnect in
/test.php line 87

so now I still have to work a lot, but at least all the pieces are in place, 
and do talk to each other.

Thank you again,

mweb

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Persistent Download Errors

[Matthew Speake]

Hi there,

I have tried to download mySQL 3.23.45 for Windows from several different
mirror sites, using MSIE6 and Netscape Navigator 4.  The downloaded .zip
file is always around 5.5 MB, not the required 11MB. When I try to unzip it
with WinZip I get the "not a valid archive" error message. Can you advise me
on how I can obtain this file please / recommend a reliable mirror site?

I have also tried "Save Target As..." but to no avail -  the download errors
are persistent.  I am using Win2k.


Thanks in advance,
Matthew

--- 
LATEST NEWS FROM VALTECH 
CRM - Delivering on expectations 
John Plumpton, Senior Business Consultant at Valtech, has written an article
for CommsDealer in which he outlines how a properly structured CRM solution
can provide much-needed competitive advantage. To read the article, please
visit the pressroom at http://www.valtech.co.uk 

DISCLAIMER: This e-mail contains Proprietary information some or all of
which may be legally privileged. It is for the intended recipient only.  
If an addressing or transmission error has misdirected this e-mail, 
please notify the author by replying to this e-mail. 
If you are not the intended recipient you must not disclose, distribute,
copy, print or rely on this e-mail. 
All information contained within this e-mail is subject to the Terms &
Conditions of Valtech Ltd. which are available upon request. 











-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php