RE: load data infile

[admin]

Hi Everyone,

Many of you suggested that, in regards to my problem with LOAD DATA
[LOCAL] INFILE ... , I may have permissions problems.  I checked with
the host and the reply was, "You have access to do all commands except
for the "grant" command."  So it would appear that I SHOULD be able to
load data from my laptop.  But as of yet I cannot.

To reply to some of your more specific questions:

Yes, the file is definitely located in the directory specified.  Using
\\ instead of a single \ in the path seems to be a good thing, but the
file is still not found.  I keep getting Errcode: 2 and using "perror"
only tells me that there's an error in my "Perror" code, so I have no
idea what Errcode 2 is (though it is likely something telling me it
could not find the file!)

"Was mysqld started with --local-infile=0?"  Uh, dunno.  The host
provides an interface which I started working with but I am wondering if
maybe there isn't a bug in it somewhere.  Probably best to write my own
query window, either way all that I can provide is my user name and
password, I have no control over the servers or application beyond
logging in and supposedly having all but "grant" permission.  

"...have you tried using the UNC path to the file?"  I'm technical
enough to know that UNC doesn't stand for University of North Carolina,
but that's about it.  I am going to assume that you are asking if I've
made sure the path is the actual path and not some pseudo-thingy that
windows does.  Indeed I believe I have.  If your question is in relation
to something else, I'm open to being educated :)

Thanks to Aaron Foster for the vote of confidence: " Give yourself full
rights - go on, you know you deserve it!"  I know I deserve it, but
those damn hoohas hosting my site just won't give it up!

And I certainly wouldn't insult toads -- they probably don't care which
version of MySQL my database is on, and they LIKE bugs!  I don't know
which version they are running, its not in their documentation.

So ... I am going to bypass the hosts administrative interface and find
my own way in, see if that works (yea, one more thing to do) and maybe
do a positive binary dance or some chanting.  If I don't make progress
on this in the next day I'm gonna brew up some damn strong coffee and
INSERT the data --- gotta have data!

Admin (aka chris)

BTW thanks for your willingness to help :)





-
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

Error 127 from table handler

[John P]

Hi All

I keep getting a problem with our MySQL database, I know what error 127 is
('Record-file is crashed / Network is down'), it keeps occuring on several
tables that are frequently accessed by our website.

I can fix the problem by running OPTIMIZE TABLE on the offending tables but
it seems to be becoming a regular occurence (every 48 hours or so). We
recently lost a load of data because many tables were down, and when these
one of the tables (the session ID table) crashes, our whole site can't be
accessed.

Nothing in the logs about it, disk space is OK and the disk passed a fsck
test ok. Only clue is from the output of isamchk:

---
Checking ISAM file: Failed.ISM
Data records:3089   Deleted blocks:   0
- check file-size
- check delete-chain
- check index reference
- check record links
isamchk: error: Wrong bytesec: 0-0-0 at linkstart: 399911
---

What can I do to stop this happening?

It is MySQL 3.22.32 running on Solaris. I plan on upgrading this soon but
want to get to the bottom of this problem first..

Thanks for any pointers,

Regards
John




-
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: can't use the table. What happen, please!!!!!!!!!!

[Chris Knipe]

THe PHP's prob still on the test database.

You can try mysql_select_db("databasename"); before you're query.


- Original Message -
From: "Cliff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 10, 2002 2:07 AM
Subject: Re: can't use the table. What happen, please!!


> That is a problem with a php script you are running, it is not passing the
> expected data as an argument.
>
> - Original Message -
> From: "Sandra" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, August 09, 2002 4:41 PM
> Subject: can't use the table. What happen, please!!
>
>
> > Hi all,
> >
> > I am getting the error when trying to connect server from my client:
> >
> >
> > Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
> > resource in .
> >
> > I had my tables in test database, but created a new database and passed
my
> > tables to there. Since then I receive that message when I execute my
.php
> > I used GRANT to assing the user privileges.
> >
> > any answer?
> >
> > thanks,
> >
> > Sandra
> >
> >
> > -
> > 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

Need a Web-based report writer

[Gina Han]

Can anyone recommend a Web-based report writer that works with MySQL?

Other conditions:
- free or low cost (we're a 501c3 nonprofit)
- basic:  no need for charts or graphics -- something formatted in columns
and can be exported for Excel would be great.  They'll be used internally
only -- not for public consumption.
- can connect locally to our MySQL database (we're using shared Web hosting
right now that doesn't allow remote access)
- want something written in PERL or PHP
- Web-based (all staff telecommute so we need to design & view reports
online)
- has a GUI as these reports will be designed & viewed by "marketing"
- not looking for a DBA-type tool (we're using PHPMyAdmin for that)
- we do not have an application server -- just a shared Web server

These reports range from the basic (e.g. showing lists of volunteers) to
reports with calculations (counts, averages, sorts) for certain periods of
time (daily, weekly, monthly).

Thanks very much,
Gina Han
www.sciencebuddies.org





-
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: can't use the table. What happen, please!!!!!!!!!!

[Cliff]

That is a problem with a php script you are running, it is not passing the
expected data as an argument.

- Original Message -
From: "Sandra" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 09, 2002 4:41 PM
Subject: can't use the table. What happen, please!!


> Hi all,
>
> I am getting the error when trying to connect server from my client:
>
>
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
> resource in .
>
> I had my tables in test database, but created a new database and passed my
> tables to there. Since then I receive that message when I execute my .php
> I used GRANT to assing the user privileges.
>
> any answer?
>
> thanks,
>
> Sandra
>
>
> -
> 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

Error thirteen

[Brian Loomis]

I'm running OS X anad have just installed mySQL 3.23.  I can log in and
modify tebles but anytime I try to create a new database I get error 13.

If I go to the information for my hard drive since the install I have no
write access, only read access to my hard drive.  I can however, access and
modify anything on my desktop  ( a subfolder of my user in OS X) I just
can't modify anything on the hard drive itself.

Is there a separate group for OS X users?

Brian Loomis-



-
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

lock row

[Alexander Burbello]

Hi,

how can I lock only one row in the table?

What table type I have to use to lock?


Regards


Alexander



sql, query

___
Yahoo! PageBuilder
O super editor para criação de sites: é grátis, fácil e rápido.
http://br.geocities.yahoo.com/v/pb.html

-
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 Locking Problems

[Mark Matthews]

- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Joe Shear" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, August 09, 2002 5:27 PM
Subject: Re: InnoDB Locking Problems


> On Fri, Aug 09, 2002 at 02:38:03PM -0700, Joe Shear wrote:
>
> [snip]
>
> > COMMIT
> > we are using the highest level of transactional security -- the term for
> > it eludes me at the moment.
>
> You mean the isolation level?  Are you running at SERIALIZABLE rather
> than READ-COMMITTED?  IF so, why?  You will have more lock contention at
> a higher isolation level.
>
> Jeremy

Yes, you can't have it both ways...If you use SERIALIZABLE on one
transaction, it will affect other transactions operating on the same data.
REPEATABLE_READ will not buy you much if it's working on the same data as
transactions running at the SERIALIZABLE isolation level.

Use SERIALIZABLE isolation levels with care, and only when you need
toand count on deadlocks...That's true with any database. Your
application logic (unless very carefully crafted) will be creating the
deadlocks, not the database itself.

-Mark
--
~__  ___ ___   __
~   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
~  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
~ /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL 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

RE: Count and group by problems

[David Kramer]

Im not sure I understand what it is that you are trying to do here???  Im
assuming your using PERL/SomeScriptingLang on something on NT to connect to
mysql using the ADO object...  Within your Count(*) Group by are you trying
to return a result set that contains a duplicate row count, i.e.
Column=Booger, Count(*)=2???  If you provide a little more info I might be
able to help here, if what I said above is true then maybe do something like
this

select foo, count(*) CNT from Table group by foo having CNT > 1;

Not sure on the syntax though, but something along those lines...

DK

-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 3:10 PM
To: [EMAIL PROTECTED]
Subject: Count and group by problems


Evening

I think I'm losing my mind. I have a very simple query that works fine in
MySQLFront but will not work when I connect using ADO:

select booger, count(*) from nose group by booger

If I try the above query with one record It works fine. Once I try it with
more records, nothing returns.

If I try:
select booger from nose group by booger
It returns results with one or more records.

Thanks for all of your help!

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

Re: SIGPROF problem in FreeBSD 4.6 (REPOST)

[Jeremy Zawodny]

On Fri, Aug 09, 2002 at 04:04:10PM -0500, Dan Nelson wrote:
> 
> A coredump of this state + gdb "thread apply all bt" might be interesting.
> 
> > > Hmm.  Looks like a problem we solve recently, but yours is a bit
> > > different.  We found that FreeBSD's not-so-thread-safe
> > > gethostbyname_r() causes problems for MySQL.  So it's best to use
> > > --skip-name-resolve when starting it up.  Maybe the same bug is
> > > somehow triggering this?  Seems unlikely, but ya never know...
> 
> FreeBSD doesn't even provide a gethostbyname_r(), so that can't be the
> problem :)

Right you are.  I mis-spoke.  It's MySQL's my_gethostbyname_r() that
calls gethostbyname() on FreeBSD.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.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: InnoDB Locking Problems

[Joe Shear]

yes, we are running at serializable, which also explains the locking
problems, especially since we just upgraded from .49.
thanks
joe

On Fri, 2002-08-09 at 15:27, Jeremy Zawodny wrote:
> On Fri, Aug 09, 2002 at 02:38:03PM -0700, Joe Shear wrote:
> 
> [snip]
> 
> > COMMIT
> > we are using the highest level of transactional security -- the term for
> > it eludes me at the moment.
> 
> You mean the isolation level?  Are you running at SERIALIZABLE rather
> than READ-COMMITTED?  IF so, why?  You will have more lock contention at
> a higher isolation level.
> 
> Jeremy
> -- 
> Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
> 
> MySQL 3.23.51: up 3 days, processed 82,315,348 queries (264/sec. avg)
> 
> -
> 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

can't use the table. What happen, please!!!!!!!!!!

[Sandra]

Hi all,

I am getting the error when trying to connect server from my client:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in .

I had my tables in test database, but created a new database and passed my
tables to there. Since then I receive that message when I execute my .php
I used GRANT to assing the user privileges.

any answer?

thanks,

Sandra


-
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 Locking Problems

[Jeremy Zawodny]

On Fri, Aug 09, 2002 at 02:38:03PM -0700, Joe Shear wrote:

[snip]

> COMMIT
> we are using the highest level of transactional security -- the term for
> it eludes me at the moment.

You mean the isolation level?  Are you running at SERIALIZABLE rather
than READ-COMMITTED?  IF so, why?  You will have more lock contention at
a higher isolation level.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 3 days, processed 82,315,348 queries (264/sec. avg)

-
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

Count and group by problems

[Menard, Inc. Information Systems]

Evening

I think I'm losing my mind. I have a very simple query that works fine in
MySQLFront but will not work when I connect using ADO:

select booger, count(*) from nose group by booger

If I try the above query with one record It works fine. Once I try it with
more records, nothing returns.

If I try:
select booger from nose group by booger
It returns results with one or more records.

Thanks for all of your help!

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

InnoDB Locking Problems

[Joe Shear]

I'm using mysql 3.23.51 w/ InnoDB tables, and am running into some
locking issues which I don't believe should occur.  There are 2
transactions that seem to interfere with each other.  The first
transaction is an update of one table followed by a select of another
table, ie:
BEGIN
UPDATE table1 set counter = counter + 1 where value = 'table2';
SELECT * from table2 where state = 2;

there is an index on state in table 2.

the second transaction is huge, with a ton of updates and inserts, this
transaction may take several minutes:
BEGIN
LOTS OF:
INSERT INTO table3 values(etc, etc.); 
UPDATE table2 set state = 2 where id = x and state = 1;

COMMIT
we are using the highest level of transactional security -- the term for
it eludes me at the moment.
so, what happens is that transaction 2 starts first, then transaction 1
starts and just freezes until the wait lock timeout occurs.  however, it
is my understanding that a select will not acquire any locks (from mysql
docs: * SELECT ... FROM ... : this is a consistent read, reading a
snapshot of the database and setting no locks.).  And that all the
updates made by the second transactions will not be accessible to the
first transaction until the second transaction commits.  So, my
interpretation of what is actually occurring is that the index is
getting changed by the second transaction before it commits, then the
first transaction is trying to read a record changed by the 2nd
transaction that the 2nd transaction still has a lock on, so it just
sits around and waits until it timeouts because the 2nd transaction
takes so long to execute.  It doesn't seem to me that innodb is behaving
correctly is this instance, but if I'm wrong, please let me know.  Does
anyone have any other ideas on what the problem could be?

thanks for you help,
joe


-
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

Replication Question

[OTR Comm]

Hello,

I am using mysql-3.23.39

I just got replication running between a Master and Slave.  I read about
log-slave-updates and chaining slaves together:

A -> B -> C -> A

Does this mean that if I add info to slave 'B' then slave 'A' is also
updated?  If so, how does the master get updated?

I read that the replication in MySQL is 'one-way', from master to slave,
how does this slave chaining work?

The main question here is, if I add data to a slave machine, is it
possible to update the master?  If so, how is this done?

I wanted to keep data between several machines synchronized, but each
machine will be updating the data. Can I do this by chaining hese
machines together as slaves?  If so, how do I do this?

Thanks,

Murrah Boswell

-
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: SIGPROF problem in FreeBSD 4.6 (REPOST)

[Dan Nelson]

In the last episode (Aug 09), David Miller said:
> On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
> > On Sat, Aug 03, 2002 at 11:59:56PM -0400, [EMAIL PROTECTED] wrote:
>
> I didn't think my server would be doing any name resolution,
> particularly while replace()ing millions of rows in a table.  That
> said, --skip-name-resolve *seems* to have helped.  It's definately
> still failing, and the ktrace is the same, so it's not two problems:
> 
>  88274 mysqld   PSIG  SIGPROF caught handler=0x812d58c mask=0x0 code=0x0
>  88274 mysqld   CALL  gettimeofday(0x81c634c,0)
>  88274 mysqld   RET   gettimeofday 0
>  88274 mysqld   CALL  sigprocmask(0x3,0x81c63d8,0)
>  88274 mysqld   RET   sigprocmask 0
>  88274 mysqld   CALL  sigaltstack(0x8203ca0,0)
>  88274 mysqld   RET   sigaltstack 0
>  88274 mysqld   CALL  poll(0x821c000,0xd,0)
>  88274 mysqld   RET   poll 0
>  88274 mysqld   CALL  sigreturn(0x2445b464)
>  88274 mysqld   RET   sigreturn JUSTRETURN
>  88274 mysqld   PSIG  SIGPROF caught handler=0x812d58c mask=0x0 code=0x0

This ktrace doesn't have anything really interesting in it.  FreeBSD's
threads library uses the profiling timer to allow for pre-emptive
thread switching, so you're going to see lots of them.  The poll call
looks a bit odd though.  It's polling 13 file descriptors (0xd == 13)
with no timeout in a tight loop.

> > > mysqld locks itself in a tight loop, consuming all available CPU
> > > cycles. a simple "kill" sometimes kills the daemon, other times a
> > > -9 is required. While in this state, any access to the daemon
> > > stops - mysql queries simply hang.

A coredump of this state + gdb "thread apply all bt" might be interesting.

> > Hmm.  Looks like a problem we solve recently, but yours is a bit
> > different.  We found that FreeBSD's not-so-thread-safe
> > gethostbyname_r() causes problems for MySQL.  So it's best to use
> > --skip-name-resolve when starting it up.  Maybe the same bug is
> > somehow triggering this?  Seems unlikely, but ya never know...

FreeBSD doesn't even provide a gethostbyname_r(), so that can't be the
problem :)

-- 
Dan Nelson
[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: RES: Aggregate + left outer join

[mmanickalal]

Eduardo,

Thanks for the reply, but I still get only one record for prj1. While prj2
does not show up with 0 hours.


CREATE TABLE PROJECT (
  ID_PROJECT int(11) NOT NULL auto_increment,
  NM_PROJECT varchar(255) NOT NULL default ''
  PRIMARY KEY  (ID_PROJECT)
) TYPE=MyISAM;

INSERT INTO PROJECT VALUES (100,'prj1');
INSERT INTO PROJECT VALUES (101,'prj2');

CREATE TABLE DAYLOG (
  ID_PROJECT int(11) NOT NULL default '0',
  DATE datetime NOT NULL default '-00-00 00:00:00',
  HOURS float NOT NULL default '0',
  PRIMARY KEY  (ID_PROJECT,DATE)
) TYPE=MyISAM;

INSERT INTO DAYLOG VALUES (100,'2002-08-17 00:00:00',8);
INSERT INTO DAYLOG VALUES (100,'2002-08-18 00:00:00',8);

Thanks,
-Manu





|+--->
||  Eduardo Stopa|
|| |
||   |
||  09-08-02 04:25 PM|
||   |
|+--->
  >---|
  |   |
  |   To: manu manickalal/PRTGROUP|
  |   cc: |
  |   Subject: RES: Aggregate + left outer join   |
  >---|






Hi,


Try the following query :


 SELECT
 p.id_project, p.nm_project, sum( dl.hours)
 FROM PROJECT p
 LEFT OUTER JOIN  DAYLOG dl ON (p.id_project = dl.id_project)
 WHERE
 (MONTH(dl.DATE) = 8 AND (YEAR(dl.DATE)  = 2002) or (dl.DATE is
 NULL)
 GROUP BY p.id_project





 Best Regards


 Eduardo






 - Mensagem original -
 De: [EMAIL PROTECTED]
 [SMTP:[EMAIL PROTECTED]]
 Enviada em: sexta-feira, 9 de agosto de 2002 17:13
 Para:   [EMAIL PROTECTED]
 Assunto:Aggregate + left outer join






 Hi,


 I am relatively new to MySQL.. I am having trouble getting an
 aggregate
 function and an outer join to work together.


 I have  two tables


 PROJECT (id_project, nm_project)
 100, prj1
 101, prj2


 DAYLOG (id_project, date, hours)
 100, 2002-08-17, 8
 100, 2002-08-18, 8


 DAYLOG table contains number of hours booked against a project for a
 date.


 I needed to list the total hours booked against each project for any
 given
 month.


 My query


 SELECT
 p.id_project, p.nm_project, sum( dl.hours)
 FROM PROJECT p
 LEFT OUTER JOIN  DAYLOG dl ON (p.id_project = dl.id_project)
 WHERE
 MONTH(dl.DATE) = 8
 AND YEAR(dl.DATE)  = 2002
 GROUP BY p.id_project


 ++++
 | id_project | nm_project | sum( dl.hours)  |
 ++++
 |100 | prj1 | 16 |
 ++++
 The problem with this result set is that it does not have projects
 with
 zero hours booked. ie. . if there are no records in DAYLOG, then that
 project is not displayed. I was expecting the left outer join to pick
 up
 records (prj2) from PROJECT even if there are no records in DAYLOG.


 So I tried another variation with the select
 SELECT p.id_project, p.nm_project, sum( dl.hours)+ IFNULL(dl.hours,0)


 added the IFNULL. Yet the query lists only projects which have records
 for
 the given month.


 Any insight, help, thoughts etc are greatly appreciated.


 Thanks,
 -Manu






 -
 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

Demande d'inscription à mysql-france

[Notification de Yahoo! Groupes]

Bonjour,

Vous avez récemment demandé à vous inscrire au groupe 
mysql-france.  Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.

Pour toute question sur l'envoi de messages à ce groupe, 
veuillez envoyer un e-mail à [EMAIL PROTECTED]


Cordialement,

L'équipe support Yahoo! Groupes 


L'utilisation du service Yahoo! Groupes est soumise à l'acceptation des 
Conditions d'utilisation et de la Charte sur la vie privée, disponibles 
respectivement sur http://fr.docs.yahoo.com/info/utos.html et
http://fr.docs.yahoo.com/info/privacy.html

 




-
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: SIGPROF problem in FreeBSD 4.6 (REPOST)

[David Miller]

On Sun, 4 Aug 2002, Jeremy Zawodny wrote:

Hi Jeremy;

I didn't think my server would be doing any name resolution, particularly
while replace()ing millions of rows in a table.  That said,
--skip-name-resolve *seems* to have helped.  It's definately still
failing, and the ktrace is the same, so it's not two problems:

88274 mysqld   PSIG  SIGPROF caught handler=0x812d58c mask=0x0 code=0x0
 88274 mysqld   CALL  gettimeofday(0x81c634c,0)
 88274 mysqld   RET   gettimeofday 0
 88274 mysqld   CALL  sigprocmask(0x3,0x81c63d8,0)
 88274 mysqld   RET   sigprocmask 0
 88274 mysqld   CALL  sigaltstack(0x8203ca0,0)
 88274 mysqld   RET   sigaltstack 0
 88274 mysqld   CALL  poll(0x821c000,0xd,0)
 88274 mysqld   RET   poll 0
 88274 mysqld   CALL  sigreturn(0x2445b464)
 88274 mysqld   RET   sigreturn JUSTRETURN
 88274 mysqld   PSIG  SIGPROF caught handler=0x812d58c mask=0x0 code=0x0
 88274 mysqld   CALL  gettimeofday(0x81c634c,0)
 88274 mysqld   RET   gettimeofday 0
 88274 mysqld   CALL  sigprocmask(0x3,0x81c63d8,0)
 88274 mysqld   RET   sigprocmask 0
 88274 mysqld   CALL  sigaltstack(0x8203ca0,0)
 88274 mysqld   RET   sigaltstack 0
 88274 mysqld   CALL  poll(0x821c000,0xd,0)
 88274 mysqld   RET   poll 0
 88274 mysqld   CALL  sigreturn(0x2445b464)
 88274 mysqld   RET   sigreturn JUSTRETURN
 88274 mysqld   PSIG  SIGPROF caught handler=0x812d58c mask=0x0 code=0x0


One new item I found was in the /usr/local/var/host.err file:

020809 16:07:15  /usr/local/libexec/mysqld: Normal shutdown

020809 16:07:16  /usr/local/libexec/mysqld: Forcing close of thread 199
user: 'dmiller'

020809 16:07:17  /usr/local/libexec/mysqld: Shutdown Complete



For the record: 3.23.51, configured with:

  $ ./configure --prefix=/usr/local --enable-assembler
--with-mit-threads=no --with-mysqld-ldflags=-all-static --with-raid
--without-readline

FreeBSD 4-STABLE


Pointers welcome.  Would alternate thread libraries be helpful?

--- David

> On Sat, Aug 03, 2002 at 11:59:56PM -0400, [EMAIL PROTECTED] wrote:
> > 
> > Symptoms:
> > 
> > mysqld locks itself in a tight loop, consuming all available CPU cycles.
> > a simple "kill" sometimes kills the daemon, other times a -9 is required.
> > While in this state, any access to the daemon stops - mysql queries simply
> > hang.
> 
> Hmm.  Looks like a problem we solve recently, but yours is a bit
> different.  We found that FreeBSD's not-so-thread-safe gethostbyname_r()
> causes problems for MySQL.  So it's best to use --skip-name-resolve when
> starting it up.  Maybe the same bug is somehow triggering this?  Seems
> unlikely, but ya never know...



-
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

Aggregate + left outer join

[mmanickalal]

Hi,

I am relatively new to MySQL.. I am having trouble getting an aggregate
function and an outer join to work together.

I have  two tables

PROJECT (id_project, nm_project)
100, prj1
101, prj2

DAYLOG (id_project, date, hours)
100, 2002-08-17, 8
100, 2002-08-18, 8

DAYLOG table contains number of hours booked against a project for a date.

I needed to list the total hours booked against each project for any given
month.

My query

SELECT
p.id_project, p.nm_project, sum( dl.hours)
FROM PROJECT p
LEFT OUTER JOIN  DAYLOG dl ON (p.id_project = dl.id_project)
WHERE
MONTH(dl.DATE) = 8
AND YEAR(dl.DATE)  = 2002
GROUP BY p.id_project

++++
| id_project | nm_project | sum( dl.hours)  |
++++
|100 | prj1 | 16 |
++++
The problem with this result set is that it does not have projects with
zero hours booked. ie. . if there are no records in DAYLOG, then that
project is not displayed. I was expecting the left outer join to pick up
records (prj2) from PROJECT even if there are no records in DAYLOG.

So I tried another variation with the select
SELECT p.id_project, p.nm_project, sum( dl.hours)+ IFNULL(dl.hours,0)

added the IFNULL. Yet the query lists only projects which have records for
the given month.

Any insight, help, thoughts etc are greatly appreciated.

Thanks,
-Manu



-
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

Transaction Support Configuration

[Bob Boden]

I have a managed dedicated server that was recently upgraded to MySQL
version
3.23.51 in order to take advantage of transaction processing. However, when
my script tries to turn off auto-commit, I receive this message...
"Transactions not supported by database". Are there any configuration
settings that need to be defined for transaction processing to function?


-
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 problem...maybe...?

[dane richard]

My phpBB forums, say if i make a post, then it goes to the post, but 
nothings there, so i have to go to index.php for it to show (and it will log 
me out) is this a bug in 4.0.1 im pretty sure its mysql..usually it 
would show the posta nd if i chnaged something (ex. colors) i would have to 
TOTALY reload the page, not just refresh like its supposed to do...what do i 
do?



_
Send and receive Hotmail on your mobile device: http://mobile.msn.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: How stable is v4? (was: Re: InnoDB vs. MyISAM on large number of tables?)

[Jeremy Zawodny]

On Fri, Aug 09, 2002 at 09:21:13PM +0200, Thomas Seifert wrote:
> On Thu, 8 Aug 2002 03:02:40 -0700
> Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> 
> > Excellent.  MySQL 4.0.{2,3} is working well for us too.
> 
> Is there 4.0.3 already somewhere to download?

Not yet.  I believe there will be a 4.0.3 beta release soon, though.
I've been building my own from the source tree.

> At all, how stable is 4.0.x already? afaik its labelled alpha on the website but I 
>heard
> some talking about beta-quality.
> Is there an official bug-list for v4? 
> 
> I would like to give it a shot on a production-system 'cause of that fantastic speed 
>increase.

Well, I'm running 4 production servers with various builds of 4.0.2 and
pre-4.0.3 (they're all slaves).  Our master is 3.23.51.  I hope to
upgrade it to 4.0.3 after the release (and I get a chance to prove it on
the slaves).

I'm not using all the fancy new 4.x features.  Replication and InnoDB,
yes.  No UNIONs, full-text search, or query cache.

My advice is to try it out if you can.  Test carefully and keep and eye
on it for a few days.  But I've had very good luck so far.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 3 days, processed 79,775,387 queries (264/sec. avg)

-
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 stable is v4? (was: Re: InnoDB vs. MyISAM on large number of tables?)

[Thomas Seifert]

On Thu, 8 Aug 2002 03:02:40 -0700
Jeremy Zawodny <[EMAIL PROTECTED]> wrote:


> > btw:
> > I did a quick benchmark with mysql4 and its query caching running with
> > innodb.
> > Quite impressive, the app run with double the number of pages per second as
> > before.
> 
> Excellent.  MySQL 4.0.{2,3} is working well for us too.


Is there 4.0.3 already somewhere to download?

At all, how stable is 4.0.x already? afaik its labelled alpha on the website but I 
heard
some talking about beta-quality.
Is there an official bug-list for v4? 

I would like to give it a shot on a production-system 'cause of that fantastic speed 
increase.


Thomas

-
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: 4.0.2 mysqld.sym.gz is empty

[Jeremy Zawodny]

On Fri, Aug 09, 2002 at 10:36:09AM -0700, Steven Roussey wrote:
> I can't look up a MySQL 4.0.2 crash since the mysqld.sym.gz is empty!
> Can someone at MySQL email me the file, please. Pretty please. Thanks! 

Ugh, that happened with 3.23.49 too, I think. :-(

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 3 days, processed 78,559,543 queries (262/sec. avg)

-
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: Storing SSN's in MySQL

[Joe Shear]

It depends on your needs.  ENCRYPT, MD5, SHA1 are all hash functions,
which means they are one-way and the SSN can't be recovered.  This means
that you can't read their SSN back once they give it to you, you can
only compare something they give you and see if it is the same as the
SSN.  This is how passwords should be stored.  The difference between
the three hashes is in their strength, and whether or not they are
salted.  Preferably, you would use SHA1 w/ a salt, because it provides
the strongest protection.  (The salt seeds the hash algorithm, so that
the same value won't hash to the same value.  So, ideally this salt
should be based on some other value of the user.)
DES is an encryption algorithm, which means that the SSN can be
recovered by you (ie: encryption key will also allow decryption), but it
also means that if someone else gets your encryption key, they will be
able to decrypt it easily, or if you lose your key, you won't be able to
recover the SSNs.  If you need to encrypt your data, it would probably
be better to go with AES or one of the stronger DES variants (3-DES),
since normal DES can be broken relatively fast.

joe

On Fri, 2002-08-09 at 07:56, John Fulton wrote:
> 
> I need to store SSN's in a MySQL DB.  I see a variety of encyption functions:
> ENCRYPT(), MD5(), SHA1(), DES_ENCRYPT() and have read the basiscs of how they
> work.  Is there are "standard way" of storing SSN's in MySQL.
> 
> thanks,
>   John
> 
> 
> 
> -
> 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

Some joins stop working when table_map extended to ulonglong

[yuri]

>Description:
I needed more than 15 joins for one statement so I changed table_map type
to ulonglong. First everything worked fine for 3-5 hours. But later some
left joins sttopped working. With one particular table.

Since this is not an official way to go this may be considered not a bug.
But it obviously indicates the problem in the code. It's not type-clean
somewhere.

>How-To-Repeat:
Don't have the exact recipie. But set this variable to ulonglong and run
lots of complex statements. Some of them may stop working after a while.
>Fix:
N/A

>Submitter-Id:  
>Originator:Yuri Victorovich
>Organization:
Optima Inc.
 
>MySQL support: none
>Synopsis:  option of 31 joins per statement doen't work cleanly
>Severity:  non-critical
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.51 (FreeBSD port: mysql-server-3.23.51)
>Server: /usr/local/bin/mysqladmin  Ver 8.23 Distrib 3.23.51, for portbld-freebsd4.5 
>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.51
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 hour 50 min 6 sec

Threads: 3  Questions: 578  Slow queries: 0  Opens: 197  Flush tables: 1  Open tables: 
64 Queries per second avg: 0.087
>Environment:

System: FreeBSD s1.optima-inc.us 4.6-STABLE FreeBSD 4.6-STABLE #1: Mon Jul 29 17:53:48 
EDT 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC  i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.4 20020320 [FreeBSD]
Compilation info: CC='cc'  CFLAGS='-O -pipe '  CXX='cc'  CXXFLAGS='-O -pipe  
-felide-constructors -fno-rtti -fno-exceptions'  LDFLAGS=''
LIBC: 
-r--r--r--  1 root  wheel  1219086 Jul 29 16:21 /usr/lib/libc.a
lrwxr-xr-x  1 root  wheel  9 Jul 29 16:21 /usr/lib/libc.so -> libc.so.4
-r--r--r--  1 root  wheel  575632 Jul 29 16:21 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl 
--without-debug --without-readline --without-bench --with-mit-threads=no 
--with-libwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.51' 
--program-prefix= --enable-assembler --with-berkeley-db --with-innodb 
--prefix=/usr/local i386-portbld-freebsd4.6 'CFLAGS=-O -pipe ' CXX=cc 
host_alias=i386-portbld-freebsd4.6 build_alias=i386-portbld-freebsd4.6 
target_alias=i386-portbld-freebsd4.6 CC=cc 'CXXFLAGS=-O -pipe  -felide-constructors 
-fno-rtti -fno-exceptions'
Perl: This is perl, version 5.005_03 built for i386-freebsd

-
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: FULLTEXT out of slow query log

[Paul DuBois]

At 10:53 -0700 8/9/02, Steven Roussey wrote:
>Is there a way to not have mysql put fulltext searches in the slow query
>log?

Not FULLTEXT queries specifically.  You can bump up long_query_time, but
that applies to all queries.

>
>Sincerely,
>Steven Roussey
>http://Network54.com/?pp=e


-
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

Apparent bug retrieving Last Insert ID using mm.mysql

[Alec . Cawley]

This bug is found using Java and the MM.MySQL driver, but I do not think it
is actually caused by the JDBC driver but rather comes from the MySQL
daemon. However, I am sending to both lists in case it is a driver problem.

The Last Insert ID can, of course,  be retrieved by executing the query
SELECT LAST_INSERT_ID(). However, MM.MySQL also offers the shortcut
Statement.getLastInsertID(), which I prefer to use believing it to be
quicker. This normally works. However, it seems to fail after executing a
command of the form
  INSERT INTO table VALUES (...), (...), ..., (...)
After executing this command, getLastInsertID() returns a value of 0,
whereas SELECT LAST INSERT_ID returns the correct value.

I attach a Java test program which demonstrates the fault. It should be
compiled then run using
  java AITest{}

(See attached file: AITest.java)

OS: Windows 2000
MySQL: 4.0.2-alpha-max-nt, binary download
MM.MySQL: 1-14
Java: j2sdk 1.4.0_01

  Alec Cawley

mysql, query




-
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 3.23 has index crashes with DELAY_KEY_WRITE=1

[Iain Wade]

>Description:

I'm running MySQL-3.23.51 stable RPMS on the master for a replicated database here.
It is processing a large quantity (9,000,000 rows/table/day) of usage records in a 
pretty much constant flow of inserts.
The raw usage tables consume roughly 400MB/table/day in .MYD and about the same in 
indices.
For performance reasons I aggregate the inserts using the bulk "INSERT INTO table 
VALUES (..), (..), (..)" statements.
There are typically between 2 and 3000 records batched together in this manner.
For performance reasons I have opted to not write the indices to disk 
(DELAY_KEY_WRITE=1 on the MyISAM tables). This is a *big* win.
Every hour/day the previous hour/days records are "summarised" up a level. (REPLACE 
INTO summary_table SELECT foo FROM raw_usage_table GROUP BY bar)
I'm replicating from a MySQL 3.23 master to a number of 4.01a slaves.

>How-To-Repeat:

After the days' usage table has accumulated a large number of records, it seems to 
crash the index regularly when the summarise batch job runs.
i.e. between 10pm and midnight INSERT statements running in parallel to the summarise 
action crashes the indices with the following error message:

"Incorrect key file for table: 'tablename'. Try to repair it"

The resolved stack traces from a number of the incidents are attached inline at the 
bottom of this mail.

Interestingly the slave machines have never once crashed, processing exactly the same 
modify operations ?
I am very tempted to switch to 4.01 on the master as it seems more robust.

>Fix:

No idea how to workaround, I've tried increasing and decreases all manner of 
memory/cache sizes to no avail.

The system is currently doing a REPAIR TABLE foo QUICK every time the application 
restarts :(

The other option was to disable the DELAY_KEY_WRITE feature, but it took a very large 
performance hit and was less desirable.

>Submitter-Id:  
>Originator:root
>Organization:
 
>MySQL support: none
>Synopsis:  MySQL 3.23 has index crashes with DELAY_KEY_WRITE=1
>Severity:  serious
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.51 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin  Ver 8.23 Distrib 3.23.51, for pc-linux-gnu on i686
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.51-Max-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 4 hours 58 min 0 sec

Threads: 6  Questions: 312397  Slow queries: 95  Opens: 56  Flush tables: 1  Open 
tables: 23 Queries per second avg: 17.472
>Environment:

Intel PIII, 1GB RAM, Redhat-6.2 base, official mysql.com RPMS.

System: Linux machine1 2.2.19-6.2.16enterprise #1 SMP Wed Mar 13 13:46:30 EST 2002 
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/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc'  CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'  CXX='gcc'  
CXXFLAGS='-O6 -fno-omit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 May 22  2001 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x1 root root  4105868 Dec  9  2001 /lib/libc-2.1.3.so
-rw-r--r--1 root root 20299228 Dec  9  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 Dec  9  2001 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc 
--without-berkeley-db --without-innodb --enable-assembler --enable-local-infile 
--with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ 
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin 
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql 
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man 
'--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer 
-mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium' CXX=gcc
Perl: This is perl, version 5.005_03 built for i386-linux


STACK TRACES:


0x806eeb4 init_signals__Fv + 16
0x82be908 _end + 315308
0x82e _end + 482843
0x82e7503 _end + 482215
0x82a6186 _end + 215082
0x834a3e2 _end + 887430
0x8068abf send_data__11select_sendRt4List1Z4Item + 39
0x806eb94 end_thread__FP3THDb + 256
0x8074461 mysql_table_dump__FP3THDPcT1i + 1

0x806eeb4 init_signals__Fv + 16
0x82be908 _end + 315308
0x82e7669 _end + 482573
0x82e7503 _end + 482215
0x82a6186 _end + 215082
0x8294d37 _end + 144347

RE: Foreign keys vont delete on cascade

[Alexandre Zglav]

OK IT WORKED FINE :)) !!!

I am finally going to be able to work correctly :))

Here is a log of what i did to test :


mysql> create database fam2
-> ;
Query OK, 1 row affected (0.00 sec)

mysql> use fam2
Database changed
mysql> create table CREATE TABLE parent (id INT NOT NULL, nom CHAR(10),
PRIMARY KEY (id)) TYPE=INNODB;
ERROR 1064: You have an error in your SQL syntax near 'CREATE TABLE parent
(id INT NOT NULL, nom CHAR(10), PRIMARY KEY (id))
TYPE=INNOD' at line 1
mysql> CREATE TABLE parent (id INT NOT NULL, nom CHAR(10), PRIMARY KEY (id))
TYPE=INNODB;
Query OK, 0 rows affected (0.08 sec)

mysql> CREATE TABLE enfant (id INT, parent_id INT, INDEX par_id (parent_id),
FOREIGN KEY (parent_id) REFERENCES parent(id) ON

->  DELETE CASCADE) TYPE=INNODB;
Query OK, 0 rows affected (0.03 sec)

mysql> INSERT INTO parent (id , nom) VALUES (1, 'alex');
Query OK, 1 row affected (0.03 sec)

mysql> INSERT INTO parent (id , nom) VALUES (3, 'tonio');
Query OK, 1 row affected (0.03 sec)

mysql> INSERT INTO parent (id , nom) VALUES (24, 'poulaga');
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO parent (id , nom) VALUES (22, 'hellscream');
Query OK, 1 row affected (0.03 sec)

mysql> select * from parent;
+++
| id | nom|
+++
|  1 | alex   |
|  3 | tonio  |
| 22 | hellscream |
| 24 | poulaga|
+++
4 rows in set (0.02 sec)

mysql> insert into enfant ( id, parent_id) VALUES (14, 3);
Query OK, 1 row affected (0.01 sec)

mysql> insert into enfant ( id, parent_id) VALUES (14, 546);
ERROR 1216: Cannot add a child row: a foreign key constraint fails
mysql> insert into enfant ( id, parent_id) VALUES (234,22);
Query OK, 1 row affected (0.03 sec)

mysql> insert into enfant ( id, parent_id) VALUES (24,22);
Query OK, 1 row affected (0.40 sec)

mysql> insert into enfant ( id, parent_id) VALUES (25,22);
Query OK, 1 row affected (0.01 sec)

mysql> insert into enfant ( id, parent_id) VALUES (1234,22);
Query OK, 1 row affected (0.02 sec)

mysql> insert into enfant ( id, parent_id) VALUES (1234,24);
Query OK, 1 row affected (0.02 sec)

mysql> insert into enfant ( id, parent_id) VALUES (123444,24);
Query OK, 1 row affected (0.02 sec)

mysql> insert into enfant ( id, parent_id) VALUES (1232323,24);
Query OK, 1 row affected (0.03 sec)

mysql> insert into enfant ( id, parent_id) VALUES (122,24);
Query OK, 1 row affected (0.02 sec)

mysql> SELECT * FROM ENFANT;
+-+---+
| id  | parent_id |
+-+---+
|  14 | 3 |
| 234 |22 |
|  24 |22 |
|  25 |22 |
|1234 |22 |
|1234 |24 |
|  123444 |24 |
| 1232323 |24 |
| 122 |24 |
+-+---+
9 rows in set (0.01 sec)

mysql> DELETE FROM PARENT WHERE id=22;
Query OK, 1 row affected (0.07 sec)

mysql> SELECT * FROM ENFANT;
+-+---+
| id  | parent_id |
+-+---+
|  14 | 3 |
|1234 |24 |
|  123444 |24 |
| 1232323 |24 |
| 122 |24 |
+-+---+
5 rows in set (0.00 sec)

mysql>

On cascade delete was processed correctly .

Thats perfect.

Thanks again !






-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi, 9. août 2002 19:53
À : Heikki Tuuri; [EMAIL PROTECTED]
Objet : RE: Foreign keys vont delete on cascade



OK thanks a lot for your help ! :)

I just downloaded the latest version ( 4.0.2) and installed it .

I hoped I could keep the settings of my ini file ( my.ini) but I got the
following error when trying to start in standalone console :


Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>cd mysql

C:\mysql>cd bin

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_buffer_pool_size = 150M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_buffer_pool_size = 150M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_additional_mem_pool_size = 25M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_log_files_in_group = 3'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_log_file_size = 20M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_log_buffer_size = 15M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_file_io_threads = 4'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_lock_wait_timeout = 50'

C:\mysql\bin>mysqld-max --standalone --console
InnoDB: Error: log file c:\mysql\ibdata\iblogs\ib_logfile0 is of different
size
InnoDB: than specified in the .cnf file!
020809 19:46:16  Can't init databases

C:\mysql\bin>mysqld-max --standalone --console
InnoDB: The first specified data 

FULLTEXT out of slow query log

[Steven Roussey]

Is there a way to not have mysql put fulltext searches in the slow query
log?

Sincerely,
Steven Roussey
http://Network54.com/?pp=e 




-
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: select problem

[Mary Stickney]

select * from forms_data_recs
where fdr_form_id='37' and ( fdr_ff_id ='190' and ( fdr_value like
'%keith%' ))
OR ( fdr_ff_id = '192' and (fdr_value like '%public%' ))
order by fdr_date,fdr_id



-Original Message-
From: Keith Clay [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: select problem


Here is my table on which I am doing sql query:

++--+-+---+-
-+-+
| fdr_id | fdr_uid  | fdr_form_id | fdr_ff_id | fdr_value
   | fdr_date|
++--+-+---+-
-+-+
| 63 | Fmct560CMs9m8m6K |  37 |   193 | goodbye
   | 2002-07-08 11:44:35 |
| 62 | Fmct560CMs9m8m6K |  37 |   192 | Clay
   | 2002-07-08 11:44:35 |
| 61 | Fmct560CMs9m8m6K |  37 |   191 | A
   | 2002-07-08 11:44:35 |
| 60 | Fmct560CMs9m8m6K |  37 |   190 | Keith
   | 2002-07-08 11:44:35 |
| 64 | Fmct560CMs9m8m6K |  37 |   194 | test01
   | 2002-07-08 11:44:35 |
| 65 | Jowl587FHe3m4y8U |  37 |   190 | John
   | 2002-07-08 11:45:10 |
| 66 | Jowl587FHe3m4y8U |  37 |   191 | Q
   | 2002-07-08 11:45:10 |
| 67 | Jowl587FHe3m4y8U |  37 |   192 | Public
   | 2002-07-08 11:45:10 |
| 68 | Jowl587FHe3m4y8U |  37 |   193 | hello
   | 2002-07-08 11:45:10 |
| 69 | Jowl587FHe3m4y8U |  37 |   194 | test02 test03
test04 | 2002-07-08 11:45:10 |
| 70 | Nfal733ELh6y6z1M |  37 |   190 | Keith
   | 2002-07-09 11:56:24 |
| 71 | Nfal733ELh6y6z1M |  37 |   191 | G
   | 2002-07-09 11:56:24 |
| 72 | Nfal733ELh6y6z1M |  37 |   192 | Public
   | 2002-07-09 11:56:24 |
| 73 | Nfal733ELh6y6z1M |  37 |   193 | hello
   | 2002-07-09 11:56:24 |
| 74 | Nfal733ELh6y6z1M |  37 |   194 | yes
   | 2002-07-09 11:56:24 |
++--+-+---+-
-+-+

This is the output of a submitted form so that anything with the same
fdr_uid is from the same submitted form and every thing with fdr_form_id
the same is from the form( there are multiple submitted forms for each
form which is basically the template) and fdr_ff_id is the question on
the form.  I am trying to search for entries on fdr_form_id='37' and I
want entries where fdr_ff_id='190' and contains keith and
fdr_ff_id='192' and contains public.  This select is dynamically generated.

select * from forms_data_recs where fdr_form_id='37' and ( fdr_ff_id =
'190' and ( fdr_value like '%keith%' )) and ( fdr_ff_id = '192' and (
fdr_value like '%public%' )) order by fdr_date,fdr_id

I get no records.  What am I doing wrong if anything?  What can I do to
get the select to work?

keith
--
-
Keith Clay, [EMAIL PROTECTED]
Lead Programmer, Web Integration and Programming
286 Adams Center for Teaching Excellence
Abilene Christian University
Abilene, TX 79699
(915) 674-2187
(915) 674-2834
-


-
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: Foreign keys vont delete on cascade

[Alexandre Zglav]

OK thanks a lot for your help ! :)

I just downloaded the latest version ( 4.0.2) and installed it .

I hoped I could keep the settings of my ini file ( my.ini) but I got the
following error when trying to start in standalone console :


Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>cd mysql

C:\mysql>cd bin

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_buffer_pool_size = 150M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_buffer_pool_size = 150M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_additional_mem_pool_size = 25M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_log_files_in_group = 3'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_log_file_size = 20M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_log_buffer_size = 15M'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_file_io_threads = 4'

C:\mysql\bin>mysqld-max --standalone --console
mysqld-max: ERROR: unknown variable 'innodb_lock_wait_timeout = 50'

C:\mysql\bin>mysqld-max --standalone --console
InnoDB: Error: log file c:\mysql\ibdata\iblogs\ib_logfile0 is of different
size
InnoDB: than specified in the .cnf file!
020809 19:46:16  Can't init databases

C:\mysql\bin>mysqld-max --standalone --console
InnoDB: The first specified data file C:\mysql\ibdata\ibdata1 did not exist:
InnoDB: a new database to be created!
020809 19:46:53  InnoDB: Setting file C:\mysql\ibdata\ibdata1 size to 100 MB
InnoDB: Database physically writes the file full: wait...
020809 19:47:12  InnoDB: Log file c:\mysql\ibdata\iblogs\ib_logfile0 did not
exist: new to be created
InnoDB: Setting log file c:\mysql\ibdata\iblogs\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
020809 19:47:13  InnoDB: Log file c:\mysql\ibdata\iblogs\ib_logfile1 did not
exist: new to be created
InnoDB: Setting log file c:\mysql\ibdata\iblogs\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
020809 19:47:16  InnoDB: Started
mysqld-max: ready for connections



OK FINALLY :)) After deleting my old ibdata files and logs its ok but a lot
of settings had to be placed as commentary .

Here is the my.ini file I use now .
My question is just :
Why did so much settings ( variables ) wern't recognised ??

Here is the ini file

#This File was made using the WinMySQLAdmin 1.4 Tool
#07.03.2002 23:24:07

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:\mysql
#bind-address=192.168.0.1
datadir=C:\mysql\data

innodb_data_home_dir = C:\mysql\ibdata

#language=C:\mysql\share\your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer = 16M


#   INNODB PARAMETER DEFINITION
#Data files must be able to
#hold your data and indexes

innodb_data_file_path =ibdata1:100M


#Set buffer pool size to 50 - 80
%
#of your computer's memory


#set-variable = innodb_buffer_pool_size = 150M
#set-variable = innodb_additional_mem_pool_size = 25M
innodb_log_group_home_dir = c:\mysql\ibdata\iblogs

#.._log_arch_dir must be the
same
#as .._log_group_home_dir

innodb_log_arch_dir = c:\mysql\ibdata\iblogs
innodb_log_archive = 0
#set-variable = innodb_log_files_in_group = 3

#Set the log file size to about
#15 % of the buffer pool size
#set-variable = innodb_log_file_size = 20M
#set-variable = innodb_log_buffer_size = 15M

#   Set ..flush_log_at_trx_commit
to
#   0 if you can afford losing
#   a few last transactions
#   N.B. Default is 0 Normally this
#   is set to 1, meaning that at a
#   transaction commit the log is flushed
#to disk, and the modifications made
#   by the transaction become permanent,
#and survive a database crash. If you
#   

select problem

[Keith Clay]

Here is my table on which I am doing sql query:

++--+-+---+--+-+
| fdr_id | fdr_uid  | fdr_form_id | fdr_ff_id | fdr_value
   | fdr_date|
++--+-+---+--+-+
| 63 | Fmct560CMs9m8m6K |  37 |   193 | goodbye
   | 2002-07-08 11:44:35 |
| 62 | Fmct560CMs9m8m6K |  37 |   192 | Clay
   | 2002-07-08 11:44:35 |
| 61 | Fmct560CMs9m8m6K |  37 |   191 | A
   | 2002-07-08 11:44:35 |
| 60 | Fmct560CMs9m8m6K |  37 |   190 | Keith
   | 2002-07-08 11:44:35 |
| 64 | Fmct560CMs9m8m6K |  37 |   194 | test01
   | 2002-07-08 11:44:35 |
| 65 | Jowl587FHe3m4y8U |  37 |   190 | John
   | 2002-07-08 11:45:10 |
| 66 | Jowl587FHe3m4y8U |  37 |   191 | Q
   | 2002-07-08 11:45:10 |
| 67 | Jowl587FHe3m4y8U |  37 |   192 | Public
   | 2002-07-08 11:45:10 |
| 68 | Jowl587FHe3m4y8U |  37 |   193 | hello
   | 2002-07-08 11:45:10 |
| 69 | Jowl587FHe3m4y8U |  37 |   194 | test02 test03
test04 | 2002-07-08 11:45:10 |
| 70 | Nfal733ELh6y6z1M |  37 |   190 | Keith
   | 2002-07-09 11:56:24 |
| 71 | Nfal733ELh6y6z1M |  37 |   191 | G
   | 2002-07-09 11:56:24 |
| 72 | Nfal733ELh6y6z1M |  37 |   192 | Public
   | 2002-07-09 11:56:24 |
| 73 | Nfal733ELh6y6z1M |  37 |   193 | hello
   | 2002-07-09 11:56:24 |
| 74 | Nfal733ELh6y6z1M |  37 |   194 | yes
   | 2002-07-09 11:56:24 |
++--+-+---+--+-+

This is the output of a submitted form so that anything with the same
fdr_uid is from the same submitted form and every thing with fdr_form_id
the same is from the form( there are multiple submitted forms for each
form which is basically the template) and fdr_ff_id is the question on
the form.  I am trying to search for entries on fdr_form_id='37' and I
want entries where fdr_ff_id='190' and contains keith and
fdr_ff_id='192' and contains public.  This select is dynamically generated.

select * from forms_data_recs where fdr_form_id='37' and ( fdr_ff_id =
'190' and ( fdr_value like '%keith%' )) and ( fdr_ff_id = '192' and (
fdr_value like '%public%' )) order by fdr_date,fdr_id

I get no records.  What am I doing wrong if anything?  What can I do to
get the select to work?

keith
-- 
-
Keith Clay, [EMAIL PROTECTED]
Lead Programmer, Web Integration and Programming
286 Adams Center for Teaching Excellence
Abilene Christian University
Abilene, TX 79699
(915) 674-2187
(915) 674-2834
-


-
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

4.0.2 mysqld.sym.gz is empty

[Steven Roussey]

I can't look up a MySQL 4.0.2 crash since the mysqld.sym.gz is empty!
Can someone at MySQL email me the file, please. Pretty please. Thanks! 

Sincerely,
Steven Roussey
http://Network54.com/?pp=e 

query



-
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

socks

[Yannick De Caluwé]

Hi,
when I visit my php pages they give an error:

Warning: MySQL connection Failed: Can't connect to local MySQL server 
trhough socket /var/lib/mysql/mysql.sock (111) in /var/www/html/index.php

the file 'mysql.sock is in the right dir (/var/lib/mysql/)

Someone told me that Apache don't get access to the mysql db, if that is the 
problem, how can I solve it??

conf: Linux :RedHat 7.1 , apache webserver, mysql server

thanks in advance

Yannick

_
Meld je aan bij de grootste e-mailservice ter wereld met MSN Hotmail: 
http://www.hotmail.com/nl


-
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

Login command hanging - mysql 3.23.49

[Reid Sutherland (mysql)]

Hi,

I'm using a program that makes many mysql connections.  Now sometimes it 
leaves a hung mysql process.  When I run mysqladmin processlist, the 
process looks like this.

(used my own formatting)

pid,user,host,db,command,time,state,info

28285,sqlusername,localhost,EMPTY,Connect,EMPTY,login,EMPTY

This processes do not listen to SIGTERM, only SIGKILL.

Is there anything I can do to prevent these type of connections other 
then going into battle with the software that causes them?  And yes, 
I've specified all the timeout related commands to resonable limits. 
But they have no effect and these 'connect' processes can last for 
days/weeks until KILLed.

Any ideas?

-reid

__
mysql-3.23.49
interactive_timeout=28800
slave_net_timeout=3600
wait_timeout=28800


-
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

upgrade error

[Rahadul Kabir]

hi all,
I was trying to upgrade mysql from 3.22.21 to 3.23.51 on my RaQ2 system.

after removing the older version when I trid to install this new version

(rpm pkgs) I got the follwoing error. anyone has any idea or can pelase
tell me what should I do at this point. thanks in advance.

rahad

[root tomcat]# rpm -Uvh MySQL-*
package MySQL-3.23.51-1 is for a different architecture
error: MySQL-3.23.51-1.i386.rpm cannot be installed
package MySQL-client-3.23.51-1 is for a different architecture
error: MySQL-client-3.23.51-1.i386.rpm cannot be installed
package MySQL-devel-3.23.51-1 is for a different architecture
error: MySQL-devel-3.23.51-1.i386.rpm cannot be installed




-
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 and MIPS

[Rahadul Kabir]

where can I find a mysql 3.23.51 to download for MIPS architecture???
thanks




-
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

Need to change MySQL results to numbers

[Gloria L. McMillan]

sql, query

[EMAIL PROTECTED] wrote:

> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text of it in the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. Just typing the word MySQL once will be sufficient, for example.
>
> You have written the following:
>
> Hi, all!
>
> I am Gloria McMillan, a poor benighted English instructor, who is trying
> to collect data
> in a database on adjunct faculty.
>
> Well, I set my table up withalphnumeric codes and most stats software
> want those mutliple choices as numbers.
>
> So I need to change the things already answered and placed into MyCC to
> numeric data:
>
> Q1:  Your region?
>
> NE
> NW
> MW
> SE
> SW  ->   TO
>
> 1
> 2
> 3
> 4
> 5
>
> I have 31 such questions.
> 21 replies so far.
>
> Do you know the MyCC commands to make the changes?
>
> Would it be easier to download the whole file and import it it from text
> editor
> with the chnages all made?
>
> But there's a header on the export.  I don't want to import back and
> erase everything...
>
> I can send anyone the first export on which we can experiment.
>
> Please help on this since it is for a worthwile purpose,
>
> Thanks!
>
> Gloria McMillan


-
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 UPGRADE ERROR

[Rahadul Kabir]

hi all,
I was trying to upgrade mysql from 3.22.21 to 3.23.51 on my RaQ2 system.
after removing the older version when I trid to install this new version
(rpm pkgs) I got the follwoing error. anyone has any idea or can pelase
tell me what should I do at this point. thanks in advance.

rahad

[root tomcat]# rpm -Uvh MySQL-*
package MySQL-3.23.51-1 is for a different architecture
error: MySQL-3.23.51-1.i386.rpm cannot be installed
package MySQL-client-3.23.51-1 is for a different architecture
error: MySQL-client-3.23.51-1.i386.rpm cannot be installed
package MySQL-devel-3.23.51-1 is for a different architecture
error: MySQL-devel-3.23.51-1.i386.rpm cannot be installed


-
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

Storing SSN's in MySQL

[John Fulton]

I need to store SSN's in a MySQL DB.  I see a variety of encyption functions:
ENCRYPT(), MD5(), SHA1(), DES_ENCRYPT() and have read the basiscs of how they
work.  Is there are "standard way" of storing SSN's in MySQL.

thanks,
  John



-
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: voting algorithm for mysql

[Alec . Cawley]

> I read on the mysql website about a voting algorithm
> for mysql to automtically switch one of the slave
> servers to master in the event something happens to
> the original master server.  Can anyone tell me where
> I can find the documentation on how to set this up.
> Thank you.

Unfortunately, if you read carefully, you will find that is a planned
future enhancement, not a current feature. I recently asked MySQL AB when
this was expected, and if I could pay to speed it up, and they said that it
was too far away to give any estimate at all  I am afraid that you will
have to do it by hand, as I am doing.

  Alec Cawley



-
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

QUESTION----- EXCESSIVE RUN TIME

[Mary Stickney]

I have a program with several quries  that join 3 tables

the one that isproblematic has is as follows:

adminhierarchy has 4.5 million records
admincoverage  has 1.5 million records
adminproducer has quite a few (i cant remember right now)

I am trying to select off 3 years worth of data , currently it is LOOPING
thru by taxid
and has been running for 2 DAYS and is only half done. Note there is other
processing then just this query.
But this query takes a very long time.


sSql = "SELECT AdminHierarchy.WritingAgentID,
AdminHierarchy.WritingAgentSlot, " & _
"AdminHierarchy.ProducerID, TaxID, " & _
"(ModalPremium * BillModeID * (PercentOfCase / 100)) AS TotalPaidPremium, "
& _
"AdminCoverage.CoverageID, AdminCoverage.CoverageIDSbc, " & _
"AdminHierarchy.RegionCode, AdminProduct.LobId, " & _
"AdminCoverage.StatusID, AdminCoverage.StatusDate, " & _
"AdminCoverage.InitialPremiumDate, AdminCoverage.PaidToDate, GROUPID " & _
" FROM AdminHierarchy " & _
" INNER JOIN AdminCoverage ON
AdminHierarchy.CoverageID=AdminCoverage.CoverageID AND
AdminHierarchy.CoverageIDSbc=AdminCoverage.CoverageIDSbc" & _
" LEFT JOIN AdminProducer ON
AdminProducer.ProducerID=AdminHierarchy.WritingAgentID" & _
" LEFT JOIN AdminProduct ON AdminCoverage.ProductID=AdminProduct.ProductID"
& _
" WHERE AdminCoverage.InitialPremiumDate >= " & sFromDate & _
" AND AdminCoverage.InitialPremiumDate <= " & sThruDate & _
" AND TaxID='" & FixSQLString(rs!taxid) & "'" & _
" ORDER BY AdminHierarchy.WritingAgentSlot,AdminCoverage.CoverageId," & _
" AdminCoverage.CoverageIdSbc,AdminHierarchy.ProducerID"
Call SendToDwDb(sSql, rs3)






Mary Stickney
TAG-TMI
Data Warehouse / Imaging
402-474-7612 x 3099
[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: Character set

[yýldýz]

  Hii Sinisa, 

  I have already writen 
--default-character-set=..
  sorry about that i just wrote it wrongly in my  
  message.

   If i write 
mysqld --default-character-set Latin5
   it gives the error message:
   "Character set Latin5 is not an compiled character
set, and is not specified in
'usr/share/mysql/shareset/Index'" 

   else
If i write 
mysqld --default-character-set latin5
   it gives the error message:
   " Can't start server: Bind on TCP/IP port:Adress
already in use."

   And i have also tried
  mysql> set Character Set latin5 ;
  then it gives the error message 
  " Unknown character set..." But it is in the shared 
  folder.

   





__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.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: Adding super user

[nick gatsis]

Try this:
Use mysql tables, change or add record in user table.
If you add password (and you must) use
password('password'). Then flush-previleges from
mysqladmin.
Also, you must change host and db tables.

Go to www.devshed.com and read "access granted"
article.
Cheers

 --- Marius Pana <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > I have
installed SuSE Linux 7.3 with Apache, MySQL
> and php. Everything is running fine but how come
> when I run mysql at the command line it doesnt ask
> me for a password? How do I set up a super user?



Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr; http://www.otenet.gr

-
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: How to separate different domains on an e-mail database

[nick gatsis]

You must create an extra field in your database to
store the domain.
Use the explode() to seperate the domain from ...@

(array explode (string separator, string string [, int
limit])
Returns an array of strings, each of which is a
substring of string formed by splitting it on
boundaries
formed by the string separator. If limit is set, the
returned array will contain a maximum of
limit elements with the last element containing the
whole rest of string. If an empty string ("") is
used as the separator argument, then explode() will
return FALSE. If separator contains a value
that is not contained in the string argument,
thenexplode() will return the string argument.
Note: The limit parameter was added in PHP 4.0.1
Example 1. explode() example
$pizza = "piece1 piece2 piece3 piece4 piece5 piece6";
$pieces = explode(" ", $pizza);
)Form PHP manual
Cheers


 --- Carlos Fernando Scheidecker Antunes
<[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hello all,
> 
> I've got an e-mail database of our subscribers and I
> would like to have a
> SQL statement do select DISTINCT domains.
> 
> Meaning, I want to know all domains. I whish I could
> query it so that it
> would show me just once each domain, or everything
> that is after the @ sign.
> 
> Does anyone knows how to query it?
> 
> The e-mail field has 50 chars long. Each user
> (whatever is before the @) has
> a different lenght off course. So I need to list
> just once each domain.
> 
> Any ideas or suggestions?
> 
> Thank you in advance,
> 
> C.F.


Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr; http://www.otenet.gr

-
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

Another pattern matching question

[Obiajulu Odu]

Hello,

  I have  the following values in my db table:
Id.    regdate
001040-1467
011910-2002
021700-1789
031550-2002
041600-1700
051900-2000
...
How can I use  mysql RegEx to the query parameter: 1445-1600: That is to 
extract those values that fall between 1445 to 1600:

This example result will be
Id.    regdate
001040-1467
031550-2002
041600-1700

Thanks in advance.

OO




-
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: myisamchk: Can't unlock file (Errcode: 11)

[Gerald Clark]

DO NOT run myisamchk while the server is running.

lorenzo.kh wrote:

>Hi,
>I am using mysql 4.0.0-aplha on win 2000 professional.
>I install mysql in c:\mysql.
>I write a script ( customerscript.txt) and i save this script in
>c:\mysql\bin.
>The contents of customerscript.txt I will paste at the bottom of this mail.
>Then,I run my script at the command prompt.
>
>C:\mysql\bin>mysql < customerscript.txt
>
>And later on I try to check the table using the command below.
>And I get the error and warning.
>
>C:\mysql\bin>myisamchk ../data/test/customer
>Checking MyISAM file: ../data/test/customer
>Data records:   1   Deleted blocks:   0
>myisamchk: warning: 1 clients is using or hasn't closed the table properly
>- check file-size
>- check key delete-chain
>- check record delete-chain
>- check index reference
>- check data record references index: 1
>myisamchk: Can't unlock file (Errcode: 11)
>- check record links
>myisamchk: error:  11 when locking indexfile '../data/test/customer'
>
>Can anybody tell me what actually is this error?
>
>**
>customerscript.txt
>**
>use test;
>
>create table customer(
>id integer not null auto_increment primary key,
>name varchar(20),
>address varchar(150)
>);
>
>insert into customer (id,name,address) values
>(null,'Good customer','Good customer address');
>
>quit
>
>**
>
>-
>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

voting algorithm for mysql

[Zachary Denison]

Hi,

I read on the mysql website about a voting algorithm
for mysql to automtically switch one of the slave
servers to master in the event something happens to
the original master server.  Can anyone tell me where
I can find the documentation on how to set this up. 
Thank you.

Zach.

__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.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

OLEDB

[LKnaepkens]

L.s.,

I think I have found a bug in the OLEDB driver for MySQL, it was caused
under 3.23 stable release.

I Use Win2000 Professional Englisch Version of Operating Systems, and do
developping using Delphi 5.02 Enterprise.

If I use Textfields or Blobs, the OLEDB Drivers says if I try to open a
certain Table "Table does not exist". The Gettablenames does prompt for the
Table, but opening causes Errors. Could it be the OLEDB driver doesnt
support Text/Blob fields?

Regards,

Luc Knaepkens-Düllberg


-
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: source command

[Egor Egorov]

Jim,
Friday, August 09, 2002, 7:21:48 AM, you wrote:

JB> At the prompt mysql> I type a command : SOURCE  SCRIPTS\MT_INV_TBL.TXT.
JB> The command returns the following error message:
JB> Failed to open file [FileName] Error 2.

JB> So what is this error 2. What does it mean?

$ perror 2
Error code   2:  No such file or directory





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   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: myslq et mysqlmax?

[Victoria Reznichenko]

Florian,
Friday, August 09, 2002, 1:00:38 PM, you wrote:

FL> What is the difference between myslq and mysqlmax?

Do you mean "mysqld"?

mysqld is a SQL daemon, MySQL server.
mysqld-max is a MySQL server that configured with options:
--with-innodb, --with-bdb, --with-server-suffix=-max and CFLAGS=-DUSE_SYMDIR




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   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: Using unix mysql db files under windows mysql

[Victoria Reznichenko]

Kevin,
Thursday, August 08, 2002, 7:41:30 PM, you wrote:

KB>  I have access to the database files themselves from a linux
KB> installation of mysql, but not the root login priveleges under mysql
KB> itself. I know that if I could connect via mysql itself I could just
KB> copy the databases from one server to another but I cant. I copied the
KB> db files over via ftp onto a windows server running mysql and it sees
KB> the 2 databases but if I try to actually access the colums, etc. I get
KB> errors. I also noticed the file extensions on the unix files are
KB> different, except for the .frm files. Is there an import tool or
KB> something else I can run to import these files into the windows version
KB> of mysql so that I can start using them again? The web site these are
KB> used for is being migrated off unix onto windows. TIA!

You don't need all privileges to make a dump. SELECT_priv on the
database that you want to move is enough.




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   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

make my own installer, what needs to be included

[Tobias Eriksson]

Hi 
 I am about to either create my own installer for MySQL or use the
allready made one. 
Reason is that I would like to have an unattended installation of the
database, which can be sent as an SMS package (MSI).
 
I need to know the following;
 
1) What is the bare minimum to include for an installation of MySQL ?
I would imagine; 1) the data dir, 2) the bin dir, 3) the lib dir.
So far there does not seem to be any windows registry entries
(actually) beeing used. The ones that does exist, does not seem to have
any meaning... 
 
2) Can I specify another name of the MySQL service on Windows through
the command line; mysqld-nt --install ...
or do I have to make my own service installer, the thing is that I
would like all exe's included work with the service installed even if it
has another name.
 
3) Has anyone made an installer, based on MSI, that one could get from
somewhere.
 
4) Has anyone made an installer which is unattended.
 
Regards
 Tobias
 
Tobias Eriksson
ComOpt AB
Michael Löfmans gata 6
254 38  Helsingborg, Sweden
Direct: +46 42 389918
Phone: +46 42 389900
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

Autoincrement question

[Alec . Cawley]

If I insert a number, say X, of records using a single statement of the
form
  INSERT INTO table VALUES (...), (...), ..., (...)
then retrieve the LAST_INSERT_ID, say Y, is it reasonable to assume that
the records will be numbered contiguously from Y-X+1 to Y, even in a
multi-user environment? And if not so, would it be reasonable if I LOCK the
table round the insert?

  Thanks for any help

Alec Cawley

mysql, query



-
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

myslq et mysqlmax?

[Florian Litot]

Hi
What is the difference between myslq and mysqlmax?
Thanks


-
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: fulltext phrase search

[Sergei Golubchik]

Hi!

On Aug 08, Dan Nelson wrote:
> In the last episode (Aug 08), Christopher Book said:
> > Using mysql 4.0.2 I get the following behaviour (phrase searching):
> > 
> > match (field) against ('"pack of"' in boolean mode)   
> > 
> > gives me all results with 'pack of', not just 'pack'.  So MySQL isn't
> > ignoring 'of' even though the word is too short to normally be
> > considered.
> >
> > However if I use: match(field) against ('"of the'" in boolean mode)
> > 
> > then the whole query is ignored.
> > 
> > It this working as designed?  Should the short words be "sometimes"
> > ignored?
> 
> If mysql internally does phrase searches by searching for "+word1 +word2", 
> then scanning the results for records where the words are also
> adjacent, that would be consistent with the results you're seeing.  As
> long as one of the words in the phrase is indexed, you'll get results.

Yes, it is how phrase search in MySQL is working.

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: Error code 28: No space left on device

[Ron Jamison]

> What will happen on Error code  28:  No space left on device? Will
mysql
> crash down?... Will there be posibility of reading data from tables?

I saw this error on one of my servers not too long ago.  MySQL keeps
running but seemingly refuses to do SELECTs on any tables.  Upon freeing
some space those same SELECTs went through fine without a restart of
mysqld.

I believe the default my.cnf uses /tmp for its temporary files.  If this
partition is full you may either free some space within it or
alternatively specify a different location for MySQL's temporary files.
See the "tmpdir" setting in my.cnf.

e.g.:

tmpdir  = /usr/tmp/

Ron Jamison



-
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