date:20021025

At 14:50 +0200 10/25/02, Natale Babbo wrote:

innodb_data_file_path=ibdata1:100M:autoextended:max:200M

anyone knows what happen if the above innodb
tablespace reach the limit of 200M?


It stops getting bigger. :-)

What do you mean by "what happen"?  That is, what are the conditions
for which you expect something to happen?

If the tablespace fills up and then you run nothing but SELECT queries,
nothing unusual will happen.  If the tablespace fills up and you try to
add more rows to your InnoDB tables, likely you won't be able to.  (See
http://www.innodb.com/ibman.html#Error_handling for information.)



Thanks in advance.
Natale Babbo

sql



-
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: Too Many Aborted Connects

2002-10-25 Thread Andy Etemadi

I know I'm not the only one experiencing this problem.  The solutions
recommended in the documentation haven't helped resolve it.  I've heard of
people using flush-hosts as a solution, but that's just a band-aid.  Any
ideas?


- Original Message -
From: "Andy Etemadi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 12:37 PM
Subject: Too Many Aborted Connects


> Redhat Linux 2.4.5-beta4va3.17smp-piii
> Dual Intel PIII/1GHz
> 2GB of memory
> 4x36GB SCSI HDDs in RAID5
>
> mysql-3.23.52-pc-linux-gnu-i686
>
>
> Experiencing 50% aborted connections (not aborted clients) over a small
> private
> network consisting of only 2 machines: the above mentioned machine and a
web
> server running Apache 1.3.20 and PHP 4.1.2.
>
> This problem of too many aborted connections requires a flush-hosts every
2
> minutes, during peak traffic.  All traffic to the database comes from the
> web server.
> All connections are made by 4 users; 1 of those 4 is the most prominent.
> NICs
> on both servers are in full duplex mode.
>
> Can anyone shed some light on this problem?
>
> Thanks,
> -- Andy Etemadi
>
>
>
> -
> 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: secure replication

2002-10-25 Thread Lists @ Apted Technologies Inc.

i understand there are other ways of encrypting the traffic, i am just
curious if there are any that employed internally in mysql.  thanks.

-chris

-Original Message-
From: Ronald Petty [mailto:ron.petty@;unigeek.com]
Sent: Thursday, October 24, 2002 6:51 PM
To: Lists @ Apted Technologies Inc.
Subject: Re: secure replication

have you thought about ssh? just a thought.
Ron

-
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 and auto_increment fields

At 11:26 -0500 10/25/02, Chris Boget wrote:

sql, query (*sigh*, I hate this filter)

I have an auto_increment key set up on my InnoDB table.
Whenever I delete all the records, the number isn't reset.
However, for my ISAM tables, whenever I delete all the
records, the auto_increment number is reset.


That's how ISAM tables work.


Is there a reason for this in InnoDB?


Yes: That's how InnoDB tables work.  (So do MyISAM tables.)

The handler for each table type handles AUTO_INCREMENT columns
slightly differently.  You're running across one of those differences.


  Is there a way that I
can reset the auto_increment number when all the records
are deleted?


ALTER TABLE t AUTO_INCREMENT = 1;


  I have a temporary table that has records
added and deleted all the time.  I wouldn't want the record
number to eventually reach the ceiling for the datatype of
the field.

Any insight would be greatly appreciated.

Chris



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

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

RE: phpmyadmin

If you are worried about security, don't run IIS! Now, that's
insecure! Use Apache, this also runs fine on windows.

PHP is as insecure as own programming is. If you program securely
then so is PHP.

My 2 cents.

-Original Message-
From: John Chang [mailto:johnec@;umich.edu] 
Sent: vrijdag 25 oktober 2002 18:10
To: mysql list
Subject: RE: phpmyadmin

>If one cannot avoid using PHP how can I secure it?  I will initially
have 
>it on the same server as IIS.



-
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

Looking for Mysql look-alike for OpenVMS

2002-10-25 Thread Norris, Joseph

Sorry if this not on the exact mysql subject. I have an upcoming project
that requires use of a SQL database system. I wanted to use mysql but mysql
is not available for OpenVMS (thread issue as I understand it). Does anyone
know of something out there that would be on the same order as mysql for
OpenVMS?

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: Mysql Innodb performance slow

2002-10-25 Thread Jeff Mathis

forgive me.

i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is significantly faster than creating a new
prepared statement for every insert.

I'm now using JDBC, and havne't explored this yet. I'm coming from the
Oracle camp, and have only been using mysql for less than a month. so
far, i find it very snappy. I do miss the ability to have stored
procedures, triggers and views however.

jeff 
Dan Nelson wrote:
> 
> In the last episode (Oct 25), Jeff Mathis said:
> > I'll agree to this somewhat:
> >
> > (1) always bind your variables. whatever code you are using to do your
> > inserts, the fewer prepared statements you can make the better.
> >
> > for example:
> > insert into TableName (col1, col2, col2, col4) values (?,?,?,?)
> >
> > then, once you have a prepared statment, do a loop and insert.
> 
> Note that mysql does not support bind variables.  If you think you're
> using them, whatever API you are using is filling them in before
> sending the statement to mysql.  Bind variables do solve quoting
> problems, though, so if you use them, know why you're using them :)
> 
> --
> Dan Nelson
> [EMAIL PROTECTED]

-- 
Jeff Mathis, Ph.D.  505-995-1434
The Prediction Company  [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
Santa Fe, NM 87505

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

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

Re: mySQL logs on Linux

At 3:02 -0800 10/25/02, neal wrote:

Could someone tell me where the logs are written to by default, for a 3.23
install of MySQL on Linux?


To the data directory.  The location of this may vary per installation,
but you can discover it with this query:

SHOW VARIABLES LIKE 'datadir';



I looked in /usr/share/mysql/english and each directory leading up to it,
but I didn't see anything resembling a log file.

Thanks.
Neal



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

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

Re: Mysql Innodb performance slow

2002-10-25 Thread Mark Matthews

Jeroen Geusebroek wrote:
[snip]

You where right, what i did use indivudual inserts. Now I have it
segmented in 1000 rows in one query which massively speeds up the whole
inserting progress. 160K records now takes about 20 seconds instead of
the 100 records ;) I'm really impressed by this massive speed.

Begin;
INSERT INTO foo VALUES (1,2,3,4,5) x 1000
Commit;

That is what I use now.

One question though, does innodb use transactions standard? So without
using
the begin; and commit; statement, does it still use some kind of
transaction?

Because still I don't understand why the isam table takes about 100
seconds for inserting 160K rows, while innodb takes 700 seconds. (using
individual inserts)

Thanks,

Jeroen


When you don't disable autocommit, InnoDB is going to create a 
transaction for _each_ statement, thus you won't be able to expect a lot 
of speed :)

	-Mark


--
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  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

ODBC connectivity?

2002-10-25 Thread Alston, Tony

Recently, something happened on my system that I'm not sure I could ever
explain.  I'm curious if the expertise of the list might be able to help me
out.  Please speak layman terms, as I'm forced to jump in this without
testing the waters...

I was working fine with MSAccess 97 to MySQL (ver 3.23.38) via MySQL ODBC
drivers 2.50 on RH7.1 alpha build.  Several days ago, my Access began
failing to connect to the MySQL database with the ODBC drivers.  I checked
the "/path_to_mysql/server.log" file and discovered that whenever the
connection attempt was made by MSAccess, MySQL killed and restarted.  I've
done some browsing of the 'archives' and came to the conclusion that the
ODBC drivers probably needed updating - since I was still able to connect by
telnet to the server:port from localhost that MySQL was assigned to listen
to for my connections.

Upgrading to ODBC 3.51.04 has not really fixed my problem, but has given me
an error number (#2203) in the windows error boxes.  My MySQL continues to
kill/restart when attempting connection via ODBC.

I have PERL scripts that write/modify via SQL commands to the MySQL
databases that still work ok, which tells me that the global and user
privileges are still intact with the data files.  I've ran 'myisamchk -r
*.MYI' and 'myisamchk -e *.MYI' in the directory with the database files and
no errors were reported.

Also - I've noticed that as root, I cannot shut down the MySQL using the
standard /etc/rc.d/init.d/mysqld stop.  It fails, and I cannot figure out
why.  Failing to properly shut down on a reboot or other system malfunction
will one day severely corrupt my data - and I'm not looking forward to that.
But, I can shut the databases down with 'mysqladmin -p shutdown' and
supplying the root password.  I'm baffled.

I'm not officially part of the list, so if anyone would care to lend some
aid, please e-mail me directly (or to the list and I'll eventually get it).
At this point, I'm desperate.  The hot breath of my users are on my neck...

Thanks in advance.

-Tony

-- 
__
Tony Alston - Westinghouse TRU Solutions, LLC -
Email  
Web Site  
__



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

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

Re: Mysql Innodb performance slow

2002-10-25 Thread Jeff Mathis

I'll agree to this somewhat:

(1) always bind your variables. whatever code you are using to do your
inserts, the fewer prepared statements you can make the better.

for example:
insert into TableName (col1, col2, col2, col4) values (?,?,?,?)

then, once you have a prepared statment, do a loop and insert.

(2) drop all indexes on your table(s). rebuild them after loading (this
alone can give orders of magnitude improvement)

(3) commit every 10,000 records or so.


I can load several million rows into our InnoDB tables in a few minutes.

good luck

jeff

Richard Clarke wrote:
> 
> Jeroen,
> 
> Two things are likely to make this umpteen times faster.
> 
> a) Commit the insert transaction every.. say 1000 records?
> b) use mysql's extended insert statement,
> insert into mytable values
> (row1_field1,row1_field2),(row2_field1,row2_field2),(?,?),(?,?) etc etc
> 
> Ric.
> 
> - Original Message -
> From: "Jeroen Geusebroek" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, October 25, 2002 12:11 PM
> Subject: Mysql Innodb performance slow
> 
> Hi There,
> 
> We have currently an Interbase Database with millions and millions of
> rows which I would like
> to migrate to MySQL if possible to increase the speed.
> 
> Transaction support is necessary, so I am using innoDB.
> 
> When inserting 160K rows in the database (in an innoDB table) it takes
> about 700! seconds
> while the amount of same rows when inserted in a myisam table take about
> 100 seconds.
> 
> Now probably this can be fine tuned (I hope), and would like to ask for
> some suggestions.
> 
> Is anybody using innodb with this amount of rows?  I'm curious of what
> the performance is.
> 
> Is there something I should keep in mind when migrating?
> 
> Kind regards,
> 
> Jeroen Geusebroek
> 
> -
> 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

-- 
Jeff Mathis, Ph.D.  505-995-1434
The Prediction Company  [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
Santa Fe, NM 87505

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

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

RE: Mysql Innodb performance slow

Hi,

>What method are you using for inserting the data?

>Individual INSERTs can be very slow:
>   INSERT INTO foo (x, y, z) VALUES (1, 2, 3);
>   INSERT INTO foo (x, y, z) VALUES (4, 5, 6);
>   ...

>Batch INSERTs can be massively faster:
>   INSERT INTO foo (x, y, z) VALUES (1, 2, 3), (4, 5, 6), ...;

You where right, what i did use indivudual inserts. Now I have it
segmented in 1000 rows in one query which massively speeds up the whole
inserting progress. 160K records now takes about 20 seconds instead of
the 100 records ;) I'm really impressed by this massive speed.

Begin;
INSERT INTO foo VALUES (1,2,3,4,5) x 1000
Commit;

That is what I use now.

One question though, does innodb use transactions standard? So without
using
the begin; and commit; statement, does it still use some kind of
transaction?

Because still I don't understand why the isam table takes about 100
seconds for inserting 160K rows, while innodb takes 700 seconds. (using
individual inserts)

Thanks,

Jeroen

> -Original Message-
> From: Jeroen Geusebroek [mailto:j.geusebroek@;infraxs.com] 
> Sent: Friday, October 25, 2002 3:11 AM
> To: [EMAIL PROTECTED]
> Subject: Mysql Innodb performance slow
> 
> 
> Hi There,
> 
> We have currently an Interbase Database with millions and millions of
> rows which I would like 
> to migrate to MySQL if possible to increase the speed.
> 
> Transaction support is necessary, so I am using innoDB.
> 
> When inserting 160K rows in the database (in an innoDB table) it takes
> about 700! seconds
> while the amount of same rows when inserted in a myisam table 
> take about
> 100 seconds.
> 
> Now probably this can be fine tuned (I hope), and would like 
> to ask for
> some suggestions.
> 
> Is anybody using innodb with this amount of rows?  I'm curious of what
> the performance is.
> 
> Is there something I should keep in mind when migrating?
> 
> Kind regards,
> 
> Jeroen Geusebroek
> 
> -
> 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: Fehler beim Zugriff von Java auf mysql datenbank

2002-10-25 Thread STIBS

Hi!

sind alle Rechte an den entpackten Dateien an den Benutzer übertragen worden, unter 
dem der MySQL Server auf RH gestartet wurde? ps -uax zeigt den an.

Beispiel: User mysql, Group mysql

als root:

bash# chown -R mysql:mysql /var/lib/mysql

Das hatte ich schon mal nach einem Restore von db's (ohne Java).

STIBS



=== At 2002-10-25, 20:42:00 you wrote: ===

>Hallo,
>
>ich habe auf einem laufenden webserver mit mysql das verzeichnis
>var/lib/mysql als tar file mit czpf erstellt und auf einem anderen
>rechner an die selbe stelle entpackt.
>Auf dem Quellrechner (System: Suse 7.2 als webserver mit apache 1.3.26
>und tomcat 402) läuft mysql 3.23.49a-1und mysql-client 3.23.49a-1.
>Auf dem Zielrechner (System redhat 7.3 als webserver mit apache 1.3.26
>und tomcat 402) läuft  mysql-3.23.49-3
>mysqlclient9-3.23.22-6 , mysql-devel-3.23.49-3 und
>mysql-server-3.23.49-3. als rpm installiert.
>
>Wenn ich mit der webzugriffsseite mit benutzer und pw drauf zugreiffen
>will erscheint die folgende Webmeldung:
>
>java.lang.NullPointerException
>at
>genericDatabaseAccess.utilities.GenericAccess.selectRow(GenericAccess.ja
>va:
>at
>accountManagement.databaseAccess.UserFlatView.getUserForLogin(UserFlatVi
>ew.
>at userAccess.LoginFilter.processLogin(LoginFilter.java:75)
>at userAccess.LoginFilter.doFilter(LoginFilter.java:46)
>at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
>tionFilterChain.at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
>erChain.at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
>e.
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
>72)
>at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
>e.
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
>72)
>at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>at
>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234
>3)
>at
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
>:
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
>lve.
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
>:
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
>72)
>at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>at
>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
>at
>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
>va:
>at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
>72)
>at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>at
>org.apache.catalina.connector.warp.WarpRequestHandler.handle(WarpRequest
>Handler.at
>org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.jav
>a:
>at java.lang.Thread.run(Thread.java:536)
>
>Wer kann mir helfen oder tipps geben wo ich eine antwort finden kann.
>
>Mit freundlichen Grüßen
>
>Erik Lang
>goetzfried ag - Ihr Projektpartner
>
>Windmühlstraße 14
>60329 Frankfurt
>Telefon 069.263-59064
>Telefax 069.263-51587
>Handy  0174.342 77 92
>www.goetzfried-ag.com
>eMail: [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

= = = = = = = = = = = = = = = = = = = =

2002-10-25, Best regards, Freundliche Grüße

STIBS (aka Michael Stibane)
Training, Consulting, Development
(Linux, Network, Internet, Database)
http://www.stibs.cc

Escapade Server-Sided Scripting Language Development Team
Pensacola - Dallas - Dresden - London
http://www.escapade.org

Mandrakesoft Linux-Campus Trainer
http://www.mandrakesoft.com/training

= = = = = = = = = = = = = = = = = = = =
No HTML mails please!



-
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

Slackware and MySQL Revisited

2002-10-25 Thread Blain Nelson


Thank you all for your suggestions.  In response to an off-list suggestion, I decided 
to not use the 
default installation, and to try recompiling after deleting the initial package.

And it barfs on compile right at the point of "this is going to take a while, if it 
barfs, try configure 
--with-low-memory" and I did and it barfed right there again.  So I'm going to, for 
now, use the 
prerolled binary, and then, when I throw more ram in the beast, try compiling again.  
(my gcc version 
was in the range recommended, as is make, so I don't know what the problem is, but I 
never do)

So thanks for your suggestions.  I may be back with other simple questions while I get 
set up again.

Take care,
Blain

PS, for the bot: MySQL, SQL, query
-- 
( ) ASCII ribbon campaign
 X  against HTML e-mail
/ \



-
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: Performance over a network

>I agree that whatever the app is, having the ability to unplug the
>database (or for it to go down) and have there be a queue on the other
>machine is ideal.  This will mean that even if the db machine reboots
>for whatever reason in the middle of the night, nobody will ever know
>the difference.  This is good application design.

Might be a good idea for a database doing only inserts, but when you
also
use select statements it does not (of course) work.

> 30's seconds over a 100MB line, that really is a lot of data for a
single query. I can pull 200K rows with 5 columns in about 20 seconds.
(int, double, double, date_time, varchar(2).

Problem could also be the application you use to get the data. Look at
your
processor and see if that is a bottleneck.

Next try to look at your network configuration; try to FTP a file (over
100MB) from the DB server to the client or the other way around and see
what
the transfer rates are.

Jeroen

-Original Message-
From: Brent Baisley [mailto:brent@;landover.com.] 
Sent: Friday, October 25, 2002 9:20 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Performance over a network

It would be helpful to know how much data you are trying to pump across.

If you are having trouble finishing in under 30 seconds over a 100mb 
connection, it must be a lot of data.
The first thing to check is to make sure you have your connections set 
to full duplex. Even if there are only two machines talking you could be

getting a lot of collisions, especially if you are transferring data in 
small amounts.

Which brings me to the next suggestion. If you are doing many individual

sql inserts you may not be using the network efficiently. You want to be

able to fill multiple network packets during your transfer, taking 
advantage of what some refer to as "burst" mode. You should be using 
this style insert:
INSERT INTO db (field1,field2,...) VALUES 
(val1,val2,...),(val1,val2,...),(val1,val2,...),(val1,val2,...),...

If you are still having trouble, you may want to rethink how you are 
going about transferring the data. Perhaps creating an import file 
locally and transferring the file over to the database machine. You then

have a program on the db machine to process files that are transferred. 
In this scenario you don't have any timing issues since you are 
essentially creating a queue that is being processed on the db machine. 
Once a file is processed it's deleted and then the program checks for 
any other files ot process. This also allows you to take the database 
down for maintenance if you have to. Lots of benefits to this setup.

On Thursday, October 24, 2002, at 08:45 PM, [EMAIL PROTECTED] 
wrote:

> * Is there any explicit tuning which can be done to speed up
access
>   over the network (short of adding gig-ethernet cards which isn't
>   likely) ?
>
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577

-
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: InnoDB and auto_increment fields

2002-10-25 Thread Chris Boget

CB> However, for my ISAM tables, whenever I delete all the 
CB> records, the auto_increment number is reset.
CB> Is there a reason for this in InnoDB?  Is there a way that I
CB> can reset the auto_increment number when all the records
CB> are deleted?  
> try exec this query:
> alter table  auto_increment = 0;

hmm, that did the trick.  But why must I do this manually?  Does
it have something to do with how the InnoDB tables/records are
stored?  Why isn't this done automatically as it is for MyISAM tables?

Thanks for the info!

Chris



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

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

Fehler beim Zugriff von Java auf mysql datenbank

2002-10-25 Thread Lang, Erik

Hallo,

ich habe auf einem laufenden webserver mit mysql das verzeichnis
var/lib/mysql als tar file mit czpf erstellt und auf einem anderen
rechner an die selbe stelle entpackt.
Auf dem Quellrechner (System: Suse 7.2 als webserver mit apache 1.3.26
und tomcat 402) läuft mysql 3.23.49a-1und mysql-client 3.23.49a-1.
Auf dem Zielrechner (System redhat 7.3 als webserver mit apache 1.3.26
und tomcat 402) läuft  mysql-3.23.49-3 
mysqlclient9-3.23.22-6 , mysql-devel-3.23.49-3 und
mysql-server-3.23.49-3. als rpm installiert.

Wenn ich mit der webzugriffsseite mit benutzer und pw drauf zugreiffen
will erscheint die folgende Webmeldung:

java.lang.NullPointerException
at
genericDatabaseAccess.utilities.GenericAccess.selectRow(GenericAccess.ja
va:
at
accountManagement.databaseAccess.UserFlatView.getUserForLogin(UserFlatVi
ew.
at userAccess.LoginFilter.processLogin(LoginFilter.java:75)
at userAccess.LoginFilter.doFilter(LoginFilter.java:46)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.ja
va:
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234
3)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.warp.WarpRequestHandler.handle(WarpRequest
Handler.at
org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.jav
a:
at java.lang.Thread.run(Thread.java:536)

Wer kann mir helfen oder tipps geben wo ich eine antwort finden kann.

Mit freundlichen Grüßen

Erik Lang
goetzfried ag - Ihr Projektpartner

Windmühlstraße 14
60329 Frankfurt
Telefon 069.263-59064
Telefax 069.263-51587
Handy  0174.342 77 92
www.goetzfried-ag.com
eMail: [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

About mysql ER diagram

2002-10-25 Thread Jannie Qu

Hi, all,

I tried to use ERwin "reverse engineer" to automatic draw ER model diagram 
for mysql database tables. Some of the tables have foreign key constraints. 
But ERwin is not able to draw the line between parent table and child table. 
Any one of you know how to solve this problem or any other software has this 
functionality? I don't want to draw foreign key line manually.

Thank you and regards,
Jing





_
Broadband? Dial-up? Get reliable MSN Internet Access. 
http://resourcecenter.msn.com/access/plans/default.asp


-
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 make a connection to the mysql server.

2002-10-25 Thread Arfan Ahmad Rana

[root@lhr root]# mysql_setpermission
Password for user  to connect to MySQL:
Can't make a connection to the mysql server.
 The error: Access denied for user: 'root@localhost' (Using password: YES) 
at /usr/bin/mysql_setpermission line 65,  line 1.
[root@lhr root]#





no  sir  same  problem i instal all rpms  as   rpm -Uvh   ...

pls  do help  , i saw taht  line   ie  line  number 65 it is 
$dbh= DBI->connect
("DBI:mysql:mysql:host=$hostname:port=$opt_port:mysql_socket=$opt_socket",$o
pt_
  die("Can't make a connection to the mysql server.\n The error: 
$DBI::errstr");


-
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: Strange behavior of CASE .. WHEN ... THEN....

2002-10-25 Thread Adam Nelson

I think that's confusing, but right.

every null value is distinct, thus null != null.

weird, but null is not a value, it's the lack of a value, so nothing can
be shown about it.

so, 

SELECT IF( NULL = NULL, 0 , 1 ) AS RESULT ;

is not the same as

SELECT IF( NULL is NULL, 0 , 1 ) AS RESULT ;

-Original Message-
From: Harald Fuchs [mailto:lists-mysql@;news.protecting.net] 
Sent: Friday, October 25, 2002 5:42 AM
To: [EMAIL PROTECTED]
Subject: Re: Strange behavior of CASE .. WHEN ... THEN

In article <000701c27193$1bf2bfa0$aa3fe7cb@jsheo>,
"Heo, Jungsu" <[EMAIL PROTECTED]> writes:

> Hello, every one.
> I Found a bug about CASE .. WHEN .. THEN..

mysql> SELECT VERSION() ;
> ++
> | VERSION()  |
> ++
> | 4.0.3-beta |
> ++
> 1 row in set (0.00 sec)

mysql> select CASE NULL WHEN  NULL THEN 0 ELSE 1 END AS RESULT ;
> ++
> | RESULT |
> ++
> |  1 |
> ++
> 1 row in set (0.00 sec)

> I think RESULT should be '0'. Am I wrong?

> IF() works finely.

mysql> SELECT IF( NULL IS NULL, 0 , 1 ) AS RESULT ;
> ++
> | RESULT |
> ++
> |  0 |
> ++
> 1 row in set (0.00 sec)

> Is this a bug or a mistake of mine?

The latter one.  While "NULL IS NULL" returns true, "NULL = anything"
returns false, even if "anything" is NULL.

[Filter fodder: SQL 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

RE: MySQL oil change

2002-10-25 Thread Adam Nelson

These are good ideas.  Just remember, if it ain't broke, don't fix it.

Unless I see performance degradation, I don't see the need to do
maintenance that could potentially create huge downtime (defrag doesn't
work, table files are permanently destroyed).  The risks must be
weighed.

I used ext3 filesystem which needs virtually no maintenance.  Innodb
seems to just keep on chugging without any loss of speed.  Granted, my
data is for the most part low write, high read with the writes being
sequential.  I am very diligent about indexing as well (extremely
important for high-read systems).  Also, I use oversized hardware to
keep things snappy without having to waste time worrying about the
minutae (ie. an extra $1k on hardware can be an amazing boost)

-Original Message-
From: mos [mailto:mos99@;fastmail.fm] 
Sent: Thursday, October 24, 2002 6:23 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL oil change

At 03:38 PM 10/24/2002, you wrote:
>Does anyone have any good maintenance tips for MySQL that should be
done on
>a regular basis?
>I know table optimization is good to do from time to time but I would
like
>to know of there is anything else I can do to help keep MySQL stable
and
>running smoothly.
>
>Thanks
>
>Mark

Mark,
 Just my 2 cents (so you know you're getting you money's 
worth),  is don't forget to frequently defrag the hard disk. If you
have 
the time, you *may* want to unload and reload the data every now and
then 
(make sure you have backups in place). This helps to make the data more 
contiguous specially if using InnoDb. Or you can use Optimize Table if
you 
do a lot of deletes to MyISAM tables. Large tables may pose a problem
with 
the Optimize command because some people have reported crashes. Of
course, 
and I stress again, make sure you have backups in place. Run Myisamchk 
daily (hourly?) on your tables to make sure they haven't become
corrupted. 
And like changing the oil in your car, make sure the car is not running
at 
the time. (In other words, have scheduled down times when you can 
perform routine maintenance.)

 Also see
http://www.linux.gr/cgi-bin/info2www?(mysql)Performance 
and http://i4net.tv/marticle/get.php?action=getarticle&articleid=4

Mike

-
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: libmyisam help...

2002-10-25 Thread Anthony R. J. Ball

  Heh... it seems like a perfect solution to me... I am loading
a few million records a day into tables... building a new table
and swapping out the old... I have to process the data a little,
so to speed it up I've been forking children and passing 1
record files to load into LOAD DATA INFILE to keep it paralell...
I figure if I write it straight into the apam, I wont have
to hassle with all the forking around, so to speak... may even
pick up some speed.

  I'd eventually like to wrap it in perl possibly, but I can't 
even make a regular C program yet... blah.

query and sql... bah!

On Fri, Oct 25, 2002 at 01:32:14PM -0500, Paul DuBois wrote:
> At 10:42 -0400 10/25/02, Anthony R. J. Ball wrote:
> >  Does no one know how to compile a program with the myisam
> >library?
> 
> Not me.  Never tried it.  Maybe no one else has, either.
> 
> >
> >  I will gladly put together a simple document on it for others
> >if someone can just point me in the proper direction, i.e. which
> >header files are required (I get a bunch of warnings if I just
> >include myisam.h), and what the proper gcc line is to link
> >everything in right is...
> 

-- 
 ___  __  ____  _  _  _  _     
/ __)(  )(  )  /__\( \/ )( ___)  ( \( )( ___)(_  _)
\__ \ )(__)(  /(__)\\  /  )__))  (  )__)   )(  
(___/(__)(__)(__)\/  ()()(_)\_)() (__) 
How many roads must a man walk down before you call him a cab?

-
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

ordered group by

2002-10-25 Thread M Spreij


1. When using "GROUP BY" it is not possible to order the rows before the grouping 
takes place, is that right? Like, if you're selecting books, grouping on author, and 
you want to show the first book of each author, you'd want to order by date and then 
group by author?

2. Other grouping question, let's say I have those books again, and I want to display 
all the books, ordered by author, and know how many books by each author there are as 
well, like so:

  Name: Bks: Title:
  Author A | 3  | booktitle_1
  Author A | 3  | booktitle_2
  Author A | 3  | booktitle_3
  Author B | 1  | booktitle_4
  Author C | 2  | booktitle_5
  Author C | 2  | booktitle_6

Is this possible in one query? Using two at the moment, first a count(*), group by 
books and then fetching them all, using the count value for ROWSPAN value in HTML.

TIA!

Regards,

Martin
-- 



-
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: Performance over a network

2002-10-25 Thread Adam Nelson

I agree that whatever the app is, having the ability to unplug the
database (or for it to go down) and have there be a queue on the other
machine is ideal.  This will mean that even if the db machine reboots
for whatever reason in the middle of the night, nobody will ever know
the difference.  This is good application design.

-Original Message-
From: Brent Baisley [mailto:brent@;landover.com.] 
Sent: Friday, October 25, 2002 9:20 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Performance over a network

It would be helpful to know how much data you are trying to pump across.

If you are having trouble finishing in under 30 seconds over a 100mb 
connection, it must be a lot of data.
The first thing to check is to make sure you have your connections set 
to full duplex. Even if there are only two machines talking you could be

getting a lot of collisions, especially if you are transferring data in 
small amounts.

Which brings me to the next suggestion. If you are doing many individual

sql inserts you may not be using the network efficiently. You want to be

able to fill multiple network packets during your transfer, taking 
advantage of what some refer to as "burst" mode. You should be using 
this style insert:
INSERT INTO db (field1,field2,...) VALUES 
(val1,val2,...),(val1,val2,...),(val1,val2,...),(val1,val2,...),...

If you are still having trouble, you may want to rethink how you are 
going about transferring the data. Perhaps creating an import file 
locally and transferring the file over to the database machine. You then

have a program on the db machine to process files that are transferred. 
In this scenario you don't have any timing issues since you are 
essentially creating a queue that is being processed on the db machine. 
Once a file is processed it's deleted and then the program checks for 
any other files ot process. This also allows you to take the database 
down for maintenance if you have to. Lots of benefits to this setup.

On Thursday, October 24, 2002, at 08:45 PM, [EMAIL PROTECTED] 
wrote:

> * Is there any explicit tuning which can be done to speed up
access
>   over the network (short of adding gig-ethernet cards which isn't
>   likely) ?
>
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577

-
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 make a connection to the mysql server.

2002-10-25 Thread Arfan Ahmad Rana

[root@lhr root]# mysql_setpermission
Password for user  to connect to MySQL:
Can't make a connection to the mysql server.
 The error: Access denied for user: 'root@localhost' (Using password: YES) 
at /usr/bin/mysql_setpermission line 65,  line 1.
[root@lhr root]#





no  sir  same  problem i instal all rpms  as   rpm -Uvh   ...

pls  do help  , i saw taht  line   ie  line  number 65 it is 
$dbh= DBI->connect
("DBI:mysql:mysql:host=$hostname:port=$opt_port:mysql_socket=$opt_socket",$o
pt_
  die("Can't make a connection to the mysql server.\n The error: 
$DBI::errstr");


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

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

Problem with dates and BETWEEN operator

2002-10-25 Thread Jakub Szewczyk


>Description:
  This is a simple bug with dates and 'between' operator. Full data is
supported below, but for the start I show the very essence of the problem. I
use the latest stable version of MySQL - 3.23.52.

SELECT weeks.ix FROM team, weeks WHERE 
  team.ix=6 AND 
  weeks.start > team.ctime AND 
  weeks.start < DATE_ADD(team.ctime, INTERVAL 7 DAY);

returns 1 row;


SELECT weeks.ix FROM team, weeks WHERE 
  team.ix=6 AND 
  (weeks.start BETWEEN team.ctime AND DATE_ADD(team.ctime, INTERVAL 7 DAY));

... is supposed to do the same as the first command - but it does return
no rows.

Interestingly, replacing team.ctime with NOW() removes the problem:

SELECT weeks.ix FROM weeks WHERE
  (weeks.start BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 7 DAY));

... it returns one row, as it is supposed to. So, the problems seems to be
related somehow to selected date columns used together with BETWEEN
operator.

>How-To-Repeat:
This is full log of operations, as they were requested in the manual:

Logging to file 'bugreport'
mysql> use sok;
Database changed
mysql> show variables;
+-+---+
| Variable_name   | Value  
|  
| |
+-+---+
| back_log| 50 
|  
| |
| basedir | /usr/local/mysql/  
|  
| |
| binlog_cache_size   | 32768  
|  
| |
| character_set   | latin2 
|  
| |
| character_sets  | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 
|usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 
|croat cp1257 latin5 |
| concurrent_insert   | ON 
|  
| |
| connect_timeout | 5  
|  
| |
| datadir | /usr/local/mysql/var/  
|  
| |
| delay_key_write | ON 
|  
| |
| delayed_insert_limit| 100
|  
| |
| delayed_insert_timeout  | 300
|  
| |
| delayed_queue_size  | 1000   
|  
| |
| flush   | OFF
|  
| |
| flush_time  | 0  
|  
| |
| have_bdb| NO 
|  
| |
| have_gemini | NO 
|  
| |
| have_innodb | NO 
|  
| |

Re: Re: phpmyadmin (OT)

2002-10-25 Thread STIBS

Mitchell,

I run phpmyadmin at a freewebhost on RH 7.0/ Apache 1.3.22/ PHP 4.0.6/ MySQL 3.23.46 
in multiuser mode with about 300 users for one year. Zero problems at all with the 
software. The box got hacked but not because of vulnerabilities in phpmyadmin.

In time I use Usermin (plugin for Webmin see webmin.com - good as hosting-console) or 
MySQLman (http://www.gossamer-threads.com), both Perl/DBI based. Neither any security 
problems though MySQLman has it's problems displaying HTML code in database fields 
e.g. from CMS db's.

STIBS

=== At 2002-10-25, 11:56:00 you wrote: ===

>Hrm.
>
>Yes, php can be vulnerable, but I was more worried about phpmyadmin and the
>potential of direct access to my databases.
>
>This particular server runs red hat 7.3, and they bundle php with their
>distro. They also patch everything in their distros fairly regularly and I
>subscribe to their update services, I feel fairly secure in their offerings.
>
>I was mostly fishing for any horror stories out there from people that
>installed phpmyadmin and were hacked because of it. I like the convenience,
>but am not willing to sacrifice security. I am however willing to run php,
>so the security concern is purely with phpmyadmin.
>
>Any advice would be most appreciated,
>
>Mitchell
>
>On 10/25/02 11:47 AM, "Thomas Seifert" <[EMAIL PROTECTED]> wrote:
>

= = = = = = = = = = = = = = = = = = = =

2002-10-25, Best regards, Freundliche Grüße

STIBS (aka Michael Stibane)
Training, Consulting, Development
(Linux, Network, Internet, Database)
http://www.stibs.cc

Escapade Server-Sided Scripting Language Development Team
Pensacola - Dallas - Dresden - London
http://www.escapade.org

Mandrakesoft Linux-Campus Trainer
http://www.mandrakesoft.com/training

= = = = = = = = = = = = = = = = = = = =
No HTML mails please!

-
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 and auto_increment fields

2002-10-25 Thread Dyego Souza do Carmo

Dobrý den,
sexta-feira, 25 de outubro de 2002, 14:26:05, napsal jste:

CB> sql, query (*sigh*, I hate this filter)

CB> I have an auto_increment key set up on my InnoDB table.
CB> Whenever I delete all the records, the number isn't reset.
CB> However, for my ISAM tables, whenever I delete all the 
CB> records, the auto_increment number is reset.
CB> Is there a reason for this in InnoDB?  Is there a way that I
CB> can reset the auto_increment number when all the records
CB> are deleted?  I have a temporary table that has records
CB> added and deleted all the time.  I wouldn't want the record 
CB> number to eventually reach the ceiling for the datatype of 
CB> the field.

CB> Any insight would be greatly appreciated.

CB> Chris

try exec this query:

alter table  auto_increment = 0;






-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- 
$ look into "my eyes"
look: cannot open my eyes
-
   Reply: [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

What password is being used

2002-10-25 Thread Zack W Kneisley

Ok, dumb question, I'm getting an error when a connection is being made
from vpopmail with a qmail installation.  I'm getting an access denied
for a user.. I've granted the user all the privs avail and still
denied.. where can I look in logs to find out why... I can't change the
password this is account is using because I compiled it into the
install. Can I see what password the user is trying to use??

sql, query


Zack




-
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 and auto_increment fields

2002-10-25 Thread Chris Boget

sql, query (*sigh*, I hate this filter)

I have an auto_increment key set up on my InnoDB table.
Whenever I delete all the records, the number isn't reset.
However, for my ISAM tables, whenever I delete all the 
records, the auto_increment number is reset.
Is there a reason for this in InnoDB?  Is there a way that I
can reset the auto_increment number when all the records
are deleted?  I have a temporary table that has records
added and deleted all the time.  I wouldn't want the record 
number to eventually reach the ceiling for the datatype of 
the field.

Any insight would be greatly appreciated.

Chris



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

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

Re: Strange behavior of CASE .. WHEN ... THEN....

At 11:41 +0200 10/25/02, Harald Fuchs wrote:

In article <000701c27193$1bf2bfa0$aa3fe7cb@jsheo>,
"Heo, Jungsu" <[EMAIL PROTECTED]> writes:


 Hello, every one.
 I Found a bug about CASE .. WHEN .. THEN..


mysql> SELECT VERSION() ;

 ++
 | VERSION()  |
 ++
 | 4.0.3-beta |
 ++
 1 row in set (0.00 sec)


mysql> select CASE NULL WHEN  NULL THEN 0 ELSE 1 END AS RESULT ;

 ++
 | RESULT |
 ++
 |  1 |
 ++
 1 row in set (0.00 sec)



 I think RESULT should be '0'. Am I wrong?



 IF() works finely.



mysql> SELECT IF( NULL IS NULL, 0 , 1 ) AS RESULT ;

 ++
 | RESULT |
 ++
 |  0 |
 ++
 1 row in set (0.00 sec)



 Is this a bug or a mistake of mine?


The latter one.  While "NULL IS NULL" returns true, "NULL = anything"
returns false, even if "anything" is NULL.

[Filter fodder: SQL query]


If you're using the CASE to test whether a part

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

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

re: re: innodb tables backup

At 12:44 +0200 10/25/02, Natale Babbo wrote:

i tried it ... but nothing to do!
when mysql parse the foreign key in the create table i
get the error.

perhaps i'm wronging in restoring tables/db!

i use this method:
shell> mysql -u  -p < 

is it wrong?

Depends.

- DId you add the SET FOREIGN_KEY_CHECKS = 0; statement to the dump
  file?
- What version of MySQL do you have?

If you added the statement, and you have a recent enough version of
MySQL, then it will work not only for the INSERT statements in the
dump file, but for the CREATE TABLE statements as well.

thanks.
Natale Babbo

 --- Victoria Reznichenko
<[EMAIL PROTECTED]> ha scritto: >
Natale,

 Friday, October 25, 2002, 10:08:00 AM, you wrote:

 NB> ok ... that's right for data (insert into ...)
 ... but
 NB> i get the error before ... when mysql try to
 create
 NB> child table:
 NB> CREATE TABLE ... idParent BIGINT, INDEX
 idpar_ind
 NB> (idParent), FOREIGN KEY (idParent) REFERENCES
 NB> parent(id)
 NB> .. when mysql parses the foreign key, parent
 table
 NB> doesn't exist yet!

 No, it's true not only for data.
 Put

 SET FOREIGN_KEY_CHECKS=0;

 in the dump file and then restore tables. It works
 fine for me.

 NB>  --- Victoria Reznichenko
 NB> <[EMAIL PROTECTED]> ha scritto: >
 NB> Natale,
 >> Thursday, October 24, 2002, 10:57:00 AM, you
 wrote:
 >>
 >> NB> Anyone knows how to backup innodb tables in
 the
 >> right
 >> NB> sql order?
 >> NB> ... i mean ... to allow restoring correctly
 >> NB> without foreign key constraint violation (if
 in
 >> the
 >> NB> backup file ddl code for the child table is
 >> before ddl
 >> NB> code for the parent table i get an error).
 >>
 >> You can set up SET FOREIGN_KEY_CHECKS=0, in this
 >> case foreign key
 >> constraints will not be checked. It's supported
 >> since 3.23.52 and

 > >> 4.0.3

-
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: phpmyadmin

2002-10-25 Thread John Chang

If one cannot avoid using PHP how can I secure it?  I will initially have 
it on the same server as IIS.

At 10:40 AM 10/25/2002 -0500, Ed Carp wrote:
> A quick question: Is phpmyadmin secure? Anyone have an negative
> experiences
> having it installed on their server?

PHP itself is not secure unless special steps are taken to secure it, and
even then it's no guarantee.  There have been several exploits published
against PHP, and a few of them have been root exploits.  I avoid PHP when I
can, especially on shared servers.

sql, 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

-
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: Performance over a network

2002-10-25 Thread Kenneth Hylton

I just got done playing with this same scenario. 

If the task finishes locally OK, but totally dogs on the network, then you
may have a network issue, NOT a MySQL issue.

1) Make sure that the switch and boxes are set to full duplex operation.
This will eliminate collisions.  Make sure that everything is REALLY running
full duplex.  Don't assume that it just is.

2) Make sure that your switch has a high enough internal bandwidth to handle
the full duplex traffic.  Many older switches do not have the internal
backplane bandwidth between ports to support a lot of 100 Mbit traffic even
though they will accept 100 Mb full duplex connections on all ports.  They
may have only a backplane bandwidth of 200-300 Mb and you can fill that up
with e-mail, internaet, etc. and leave nothing left over for server to
server traffic.

3) Put the servers on a VLAN if possible to avoid other network traffic.

Symptoms of these problems are slow processing with none of your boxes
loaded up.  top will show them idle and the completion time for your
processing will be painfully long.  It will run fine locally, but, just
crater over the network.

Sound familiar?

When I made the above changes, I was able to change network throughput from
12 Mb/sec between application server box and database server box to 160
Mb/sec of traffic.  top then showed the application boxes as totally busy
with no idle time.  The MySQL box was never really taxed even at that
throughput level.

Also, you can look to optimize your SQL (i.e.: multiple records inserted per
INSERT SQL command - see web for syntax) but that may not be your issue if
it worked OK on the local box.

I found that stringing several Athlon XP1800+ boxes together (my test
environment) I was able to max out the boxes before I maxed out the network
@ a true 100 Mb full duplex.

Hope this helps!

Ken Hylton
Programmer Analyst IV
LEC Systems & Programming

Billing Concepts, Inc.
7411 John Smith Drive
San Antonio, Texas 78229-4898
(210) 949-7261



-Original Message-
From: [EMAIL PROTECTED] [mailto:hooker@;rave.iinet.net.au]
Sent: Thursday, October 24, 2002 7:45 PM
To: [EMAIL PROTECTED]
Subject: Performance over a network


Hi,

I'm running MySQL 3.23.51 on a Debian Linux server, and I've got a
performance question.

I have a perl application which builds up data in memory (in a hash) and
every 30 seconds forks and writes the data to a database. When both perl
script and MySQL server are on the same machine, the script manages to
finish writing to the database before the next child appears (*most* of
the time :-) ). However, if the script and MySQL server are on different
machines, separated by an uncongested 100 Mbs ethernet network, the
child always fails to write to the database within the 30 second window.

So, my questions are ...


*   Is there a measure of the expected difference between these two
scenarios?

*   Is there any explicit tuning which can be done to speed up access 
over the network (short of adding gig-ethernet cards which isn't
likely) ?

The reason for not just leaving everything on the same machine is that
the expected growth over the next 6 months will mandate more than one
server to handle the incoming data, so the separation between script and
database engine is going to have to happen anyway.

Hopefully ...


Paul Wilson
Chime Communications Ltd


-
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: phpmyadmin (OT)

2002-10-25 Thread Mitchell Wright

Hrm.

Yes, php can be vulnerable, but I was more worried about phpmyadmin and the
potential of direct access to my databases.

This particular server runs red hat 7.3, and they bundle php with their
distro. They also patch everything in their distros fairly regularly and I
subscribe to their update services, I feel fairly secure in their offerings.

I was mostly fishing for any horror stories out there from people that
installed phpmyadmin and were hacked because of it. I like the convenience,
but am not willing to sacrifice security. I am however willing to run php,
so the security concern is purely with phpmyadmin.

Any advice would be most appreciated,

Mitchell

On 10/25/02 11:47 AM, "Thomas Seifert" <[EMAIL PROTECTED]> wrote:

> I don't want to start a flame but where do take this from?
> Every security-hole in php has been fixed shortly after it was known.
> 
> Its as secure as any other server-side scripting-language in the web.
> 
> 
> Thomas
> 
> On Fri, 25 Oct 2002 10:40:32 -0500 "Ed Carp" <[EMAIL PROTECTED]> wrote:
> 
>> PHP itself is not secure unless special steps are taken to secure it, and
>> even then it's no guarantee.  There have been several exploits published
>> against PHP, and a few of them have been root exploits.  I avoid PHP when I
>> can, especially on shared servers.
>> 
> 
> sql, 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
> 
> 

-
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: phpmyadmin (OT)

2002-10-25 Thread Mark Stringham

Unfortunately,  when people suggest that they "avoid PHP when they can"  it
usually means they don't understand much about the language or how to use it
appropriately.

That being said, I personally avoid .NET and FrontPage

MS
- Original Message -
From: "Thomas Seifert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 9:47 AM
Subject: Re: phpmyadmin (OT)


> I don't want to start a flame but where do take this from?
> Every security-hole in php has been fixed shortly after it was known.
>
> Its as secure as any other server-side scripting-language in the web.
>
>
> Thomas
>
> On Fri, 25 Oct 2002 10:40:32 -0500 "Ed Carp" <[EMAIL PROTECTED]> wrote:
>
> > PHP itself is not secure unless special steps are taken to secure it,
and
> > even then it's no guarantee.  There have been several exploits published
> > against PHP, and a few of them have been root exploits.  I avoid PHP
when I
> > can, especially on shared servers.
> >
>
> sql, 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
>


-
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: phpmyadmin (OT)

2002-10-25 Thread Thomas Seifert

I don't want to start a flame but where do take this from?
Every security-hole in php has been fixed shortly after it was known.

Its as secure as any other server-side scripting-language in the web.

Thomas

On Fri, 25 Oct 2002 10:40:32 -0500 "Ed Carp" <[EMAIL PROTECTED]> wrote:

> PHP itself is not secure unless special steps are taken to secure it, and
> even then it's no guarantee.  There have been several exploits published
> against PHP, and a few of them have been root exploits.  I avoid PHP when I
> can, especially on shared servers.
> 

sql, 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

RE: phpmyadmin

2002-10-25 Thread Ed Carp

> A quick question: Is phpmyadmin secure? Anyone have an negative
> experiences
> having it installed on their server?

PHP itself is not secure unless special steps are taken to secure it, and
even then it's no guarantee.  There have been several exploits published
against PHP, and a few of them have been root exploits.  I avoid PHP when I
can, especially on shared servers.

sql, 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

phpmyadmin

2002-10-25 Thread Mitchell Wright

Greetings everyone,

A quick question: Is phpmyadmin secure? Anyone have an negative experiences
having it installed on their server?

I found notes on one exploit, but in my google searches did not bring up
anything too serious.

Regards,

Mitchell
 - sql 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

SEGFAULT unless reverse...

2002-10-25 Thread jonfray

>Description:
I have the same problem as a previous mail :
# http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:107859
But I couldn't find the final issue (except adding every host in
my /etc/hosts file)
>How-To-Repeat:
Run this command from a host that has no reverse DNS available
# /usr/local/mysql/bin/mysql -u mediation -h 194.242.186.11 -p
An error occur :
# ERROR 2013: Lost connection to MySQL server during query
On the server, the logs contains these lines :
# /usr/local/mysql/bin/safe_mysqld: line 1:  4698 Erreur de segmentation nice 
--5 nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql 
--datadir=/usr/local/mysql/var --user=mysql 
--pid-file=/usr/local/mysql/var/sodium.mediation-telecom.net.pid --skip-locking --log 
--log-bin >>/usr/local/mysql/var/sodium.mediation-telecom.net.err 2>&1
#
# Number of processes running now: 1
# mysqld process hanging, pid 4701 - killed
# 021025 15:56:26  mysqld restarted
>Fix:
The only solution I found was to add each host that need to connect in the 
/etc/hosts.conf file.

>Submitter-Id:  [EMAIL PROTECTED]
>Originator:Jean-Eudes ONFRAY
>Organization:  Mediation Télécom
>MySQL support: none
>Synopsis:  SEGFAULT unless reverse...
>Severity:  critical
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.53 (Source distribution)

>Environment:
RedHat 7.1, All patch applied
System: Linux sodium.mediation-telecom.net 2.4.18-17.7.xsmp #1 SMP Tue Oct 8 12:37:04 
EDT 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/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 oct  7 10:59 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x1 root root  1285884 sep  9 18:10 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27336078 sep  9 17:48 /usr/lib/libc.a
-rw-r--r--1 root root  178 sep  9 17:48 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql


-
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: Connection

2002-10-25 Thread Jocelyn Fournier

Hi,

After a little search, it seems to mean to "treat BIGINT as INT".

Regards,
  Jocelyn

- Original Message -
From: "Arthur" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 4:59 PM
Subject: Connection


> Hello mysql,
>
>  Often I've seen  OPTION=16384 in a connection string
>  Whay does it mean?
>
> --
> Best regards
> A backpacker in the foot hills of MySQL,
>
>  Arthur  mailto:ArthurMaloney@;seipas.com
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


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

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

Connection

2002-10-25 Thread Arthur

Hello mysql,

 Often I've seen  OPTION=16384 in a connection string
 Whay does it mean?

-- 
Best regards
A backpacker in the foot hills of MySQL,

 Arthur  mailto:ArthurMaloney@;seipas.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 tablespace size

2002-10-25 Thread Fernando Grijalba

My guess is that you can not operate the db when space is required and you
get error message.  Like when trying to alter a table it will tell you that
the table is full.  This is because MySQL will create a temporary table drop
the original and rename the new one.

HTH

JFernando

-Original Message-
From: Natale Babbo [mailto:natale_babbo75@;yahoo.it]
Sent: October 25, 2002 08:51
To: [EMAIL PROTECTED]
Subject: innodb tablespace size


innodb_data_file_path=ibdata1:100M:autoextended:max:200M

anyone knows what happen if the above innodb
tablespace reach the limit of 200M?

Thanks in advance.
Natale Babbo


sql

__
Mio Yahoo!: personalizza Yahoo! come piace a te
http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/

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

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



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

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

Re: MySQL with Slackware -- wha?

2002-10-25 Thread B. van Ouwerkerk

IIRC Slackware 7 and 8 come with MySQL preinstalled.

But.. it does compile fine here.. on both 7 and 8. But you really have to 
uninstall (pkgtool) the default installed.. next you follow all the staps 
as explained in the MySQL manual (actually a file in the docs directory).

Have fun,


B.

At 16:11 24-10-02 -0700, Blain Nelson wrote:
Howdy,

I've used MySQL before, a few years ago, under Slackware.  I never could 
get it to compile (despite
lots of help from folks here), but a pre-rolled binary did just fine for 
what I needed at the time.
That system is no longer hooked up.

I've recently installed a newer version of Slack (7.0 I believe) which 
comes with MySQL in it, but I
can't get mysqld to run either on its own or (preferably) with safe_mysqld.

It appears that all the scripts are in /usr/bin/, mysqld is in 
/usr/libexec/ and the data files are off
of /var/lib/mysql/.

I did do mysql_install_db, but, when I try to use safe_mysqld &, it says 
that it's starting, and then
it says that it's done.  When I look in /var/lib/mysql/ there is a .err 
file that says
"/usr/libexec/mysqld Can't find file: './mysql/host.frm' (errno: 
13)".  It's very insistant about this,
btw -- I've checked several times, and that's all that it has to say about 
that.

The manual says that errno: 13 means we've got a permission problem, but 
I've tried chmod to the
/var/lib/mysql/ and /var/lib/mysql/mysql/ directories and their contents, 
and that doesn't seem to make
anybody happier.

So, for you folks I've seen in the archive saying how Slack rocks (with 
which I agree), a hand would be
appreciated.

Additional data in case it's handy:

mysqlaccess indicates that this is:
$VERSION= "2.06, 20 Dec 2000";
and
$SERVER = "3.21"

Any other information you can tell me how to find out for you will be 
given on request, but I may ask
for commonly used words to be defined or clarified because I'm not all 
that great with this stuff.

TIA,
Blain


--
( ) ASCII ribbon campaign
 X  against HTML e-mail
/ \



-
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: libmyisam help...

2002-10-25 Thread Anthony R. J. Ball


  Does no one know how to compile a program with the myisam
library?

  I will gladly put together a simple document on it for others
if someone can just point me in the proper direction, i.e. which
header files are required (I get a bunch of warnings if I just 
include myisam.h), and what the proper gcc line is to link 
everything in right is...


On Thu, Oct 24, 2002 at 10:36:49AM -0400, Anthony R. J. Ball wrote:
>   
>   Hi all... I am attempting to play with the myisam
> api to try to make loading hordes of data a little
> simpler/faster, and so am trying out the myisam interface...
> specifically, eventually to try an wrap it in a perl
> module. Herein lies my problem...
> 
>   I know enough C to get by, but am having some problems
> with getting the myisam lib linked right, and the includes
> right...
> 
>   Could someone give me the proper compiler arguments
> and header includes to get me started?
> 
>   I tried -lmyisam, but when I compile I get 
> /tmp/ccTiEnWS.o: In function `main':
> /tmp/ccTiEnWS.o(.text+0x13): undefined reference to `mi_open'
> 
>   I would appreciate any help, I haven't been able to find
> any sample code online... I may even be able to release the perl
> module (if I can get it to work...)
> 
>   I am testing for now on Linux, but in the end I want
> this to work on Solaris...
> 
>   Here are the words sql and query, so this message will
> post ;)
> 
> -- 
>  ___  __  ____  _  _  _  _     
> / __)(  )(  )  /__\( \/ )( ___)  ( \( )( ___)(_  _)
> \__ \ )(__)(  /(__)\\  /  )__))  (  )__)   )(  
> (___/(__)(__)(__)\/  ()()(_)\_)() (__) 
> "These are the times that try men's souls." - T. Paine
> 
> 
> -
> 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
> 

-- 
 ___  __  ____  _  _  _  _     
/ __)(  )(  )  /__\( \/ )( ___)  ( \( )( ___)(_  _)
\__ \ )(__)(  /(__)\\  /  )__))  (  )__)   )(  
(___/(__)(__)(__)\/  ()()(_)\_)() (__) 
These special effects aren't very special.


-
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: Lost Connection

2002-10-25 Thread Mark Matthews

John Coder wrote:

On Fri, 2002-10-25 at 00:14, Lewis Watson wrote:

- Original Message -
From: "Mark Matthews" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 8:40 PM
Subject: Re: Lost Connection

[snip]

OPS. Sorry, I have had my head up this bsd machine so intensely that I
forgot which machine it happened on... Please forgive me, it did happen on a
Redhat 7.0? 7.1 build of Redhat! I compiled it from source
./config --prefix=/usr/local. I am so sorry. This is a production machine...
What's the best way to upgrade from this to 3.23.53a? I greatly appreciate
your help.
Lewis

according to mysql compiling from source has probs if you are using gcc
2.96 so they suggest using their binaries
do a gcc -v and see what version of gcc you use.

John Coder 

It's not just that...RedHat has been upgrading GLIBC to a version that 
has problems running MySQL. MySQL AB compiles mysql statically with a 
somewhat optimized (for MySQL) version of GLIBC, which prevents 
compatibility issues with any version of GLIBC on Linux.

	-Mark

--
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  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: innodb tablespace size

2002-10-25 Thread Lenz Grimmer

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Friday 25 October 2002 14:50, Natale Babbo wrote:

> innodb_data_file_path=ibdata1:100M:autoextended:max:200M
> 
> anyone knows what happen if the above innodb
> tablespace reach the limit of 200M?

I would assume you will get an error: "table space full" :)

Bye,
LenZ
- -- 
For technical support contracts, visit https://order.mysql.com/?ref=mlgr
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Lenz Grimmer <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Production Engineer
/_/  /_/\_, /___/\___\_\___/   Hamburg, Germany
   <___/   www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux)

iD8DBQE9uUFeSVDhKrJykfIRAoPfAJ0UZjmT2BBal5mW/jfVgB+vu09TrQCfZbjv
vq9XTdj4P5PJUz9Xfm0d61U=
=yqLm
-END PGP SIGNATURE-

-
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 consuming too much CPU / processes never close

2002-10-25 Thread universe

Hi,

mySQL 3.23.49 on Debian GNU/Linux 3.0, Kernel 2.4.19 on a Xeon 2 Ghz (1
CPU) and 2 GB DDR-RAM. The following problem arises:

All mysqld processes (UNIX) consume too much CPU power. There are
usually a 4-10 active processes that want 30% to 99.9% of CPU power -
EACH of them. "top" just showed me 8 mySQL procs with each demanding 30%
of CPU. The load average of the system is at 20 right now. It also came
to my attention that there are plenty of mySQL-processes (processes
within mySQL) simply sleeping and never closing. 

I did the following to investigate the problem:

- "mysqladmin processlist" always brought up "Too many connections".
Therefore I changed the max_connections value to 500 for a test.
However, that would basically take the system down or bring it into a
unusable state as mySQL processes would build up and build up even more
and never close (especially the ones marked as "Sleep"). After a couple
minutes almost all 500 connections were used up. Load average was beyond
20.

- Test-wise I switched "wait_timeout" and "interactive_timeout" from 8
days (default value) to 60 seconds. Thereby the Sleep processes would
not stay open but instead get shut down by the system after 60 seconds -
this took some load away from the system (I thought).

- Now, with the timeout values set to only 10 seconds and the
max_connections to 100 I still have a unusable system. mySQL keeps
consuming more and more CPU and has plenty of processes (both UNIX and
within mySQL) open. The websites that access mySQL through PHP will only
load after 10 seconds, 30 seconds or sometimes never - depending on the
load. 

Would it be possible that a single PHP website that executes plenty of
queries can produce so much load to mySQL?

"mysqladmin status" shows: Uptime: 1685  Threads: 8  Questions: 27156 
Slow queries: 672  Opens: 10787  Flush tables: 1  Open tables: 65 
Queries per second avg: 16.116

All PHP (PHP 4.1.2 on Apache 1.3.26) is encoded by zend, so I cannot
really say what the code is like. However, I have a logfile that shows
all queries to mySQL. 

Does this sound like a flaw in the programming layout to you? Or rather
a configuration error somewhere? 

Any hints are greatly appreciated!

Thanks,
Markus

-
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

Where to find mysql 4.1 win32 source distribution

2002-10-25 Thread Fethi Altunyuva

It may be a stupid question .I'm not able to download the mysql 4.1 win32
source distribution,As far as I seen
in the downloads page there exists only the binary version.
Where can I find source distribution
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: secure replication

2002-10-25 Thread Michael T. Babcock

Paul DuBois wrote:


No.  mysqld --help shows --master-ssl, --master-ssl-key, and 
--master-ssl-cert
options, but they're placeholders at the moment and haven't been 
implemented.

Any examples of running mysql's replication over an ssltunnel link, 
without damaging the local connections?
(I could probably work it out myself if I tried, mind you ...)
And is there an active internal / external project to make the secure 
connections work?

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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: Tips for optimizing link analysis ...

2002-10-25 Thread Michael T. Babcock

[EMAIL PROTECTED] wrote:


The actual situation is a telecom analysis: a calls b
and a is suspect. Who are the people connected to a ?
we have call records  of calls in tables


Ok, so you should have a table, I presume, like:

Callers: id (phone number)
Calls: id, callerid, calledid, startime, endtime

SELECT calledid FROM Calls WHERE callerid = suspect;
SELECT callerid FROM Calls WHERE calledid = suspect;

SQL.

(you could put them both in one result list as well)

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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

VS: Strange problem with MySql & IIS & ASP

2002-10-25 Thread Morsky Juha

Millions of thanks!

Now it's working perfectly!!!
Once again MS bugs...

Regards
Juha

-Alkuperäinen viesti-
Lähettäjä: Terence [mailto:terencel@;sunway.edu.my]
Lähetetty: 23. lokakuuta 2002 4:54
Vastaanottaja: Morsky Juha; [EMAIL PROTECTED]
Aihe: Re: Strange problem with MySql & IIS & ASP



I had the same problem. It's in your connection, somehow ASP doesnt retrieve
the results when doing a select and count, so you need to use a connection
like this:

dim myConn
Set myConn= Server.CreateObject ("ADODB.Connection")
myConn.ConnectionString =
"Driver={MySQL};SERVER=xxx.xxx.xxx.xxx;DATABASE=mydb;UID=user;PWD=pwd;PORT=3
306;OPTION=16384;"
myConn.Open

Hopefully this works.

Cheers
Terence





Hi All!

I've Select like this:

SELECT ExpDepDate, ActArrDate FROM oceandata

It works beautifully

But When I modify it like this

SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata

I'll get nothing, just a empty screen with a browser!

I'm using Ultradev to create this and when I test it in Ultradev it works
good, same in MySQL CC Admin. But not on IIS?
ASP look like this:

<%@LANGUAGE="VBSCRIPT"%>

<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_connMyIFDData_STRING
Recordset1.Source = "SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs
FROM oceandata"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = 10
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>


Untitled Document




  <%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
  
<%=(Recordset1.Fields.Item("ExpDepDate").Value)%>
<%=(Recordset1.Fields.Item("ActArrDate").Value)%>
<%=(Recordset1.Fields.Item("Act_Est").Value)%>
  
  <%
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
Wend
%>



<%
Recordset1.Close()
%>

Any help will be helpfull

Regards
Juha Mörsky


MySQL

-
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

-
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: Understanding MySQL column type SET

2002-10-25 Thread Luc Foisy

> 
> mysql> CREATE TABLE settest( chain SET( "A", "B", "C" ) NOT NULL, 
>   UNIQUE INDEX ichain( chain ) );
> 
> mysql> INSERT INTO settest SET chain="A,C";
> 
> mysql> SELECT * from settest;
> +---+
> | chain |
> +---+
> | A,C   |
> +---+
> 
> mysql> SELECT * FROM settest WHERE chain="A,C";
> +---+
> | chain |
> +---+
> | A,C   |
> +---+
> 
> mysql> SELECT * FROM settest WHERE chain="C,A";
> Empty set (0.00 sec)

++From Manual: http://www.mysql.com/doc/en/SET.html
++SET values are sorted numerically. NULL values sort before non-NULL SET values. 

That means when you create SET("A","B","C") they are assigned the decimal values of 
1,2,4

++mysql> SELECT * FROM tbl_name WHERE set_col = 'val1,val2';
++mysql> SELECT * FROM tbl_name WHERE set_col & 1;
++The first of these statements looks for an exact match. The second looks for values 
+containing the first set member. 

Since they are sorted numerically, and WHERE chain="C,A" is looking for an exact 
match, it will not find it.

> mysql> SELECT * FROM settest WHERE FIND_IN_SET("C,A", chain);
> Empty set (0.01 sec)

++Normally, you perform a SELECT on a SET column using the LIKE operator or the 
+FIND_IN_SET() function: 

++mysql> SELECT * FROM tbl_name WHERE set_col LIKE '%value%';
++mysql> SELECT * FROM tbl_name WHERE FIND_IN_SET('value',set_col)>0;

Looks to me these are expecting "value" (singular) not "values"
And regardless all of them are looking for exact matches against how the data is stored

If you were to create with SET("C","A","B") looking for FIND_IN_SET("C,A",chain) would 
probably work
 
Anyways, not considering myself a Guru, but that's how I am seeing it

Luc 

-
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: Performance over a network

2002-10-25 Thread Brent Baisley

It would be helpful to know how much data you are trying to pump across. 
If you are having trouble finishing in under 30 seconds over a 100mb 
connection, it must be a lot of data.
The first thing to check is to make sure you have your connections set 
to full duplex. Even if there are only two machines talking you could be 
getting a lot of collisions, especially if you are transferring data in 
small amounts.

Which brings me to the next suggestion. If you are doing many individual 
sql inserts you may not be using the network efficiently. You want to be 
able to fill multiple network packets during your transfer, taking 
advantage of what some refer to as "burst" mode. You should be using 
this style insert:
INSERT INTO db (field1,field2,...) VALUES 
(val1,val2,...),(val1,val2,...),(val1,val2,...),(val1,val2,...),...

If you are still having trouble, you may want to rethink how you are 
going about transferring the data. Perhaps creating an import file 
locally and transferring the file over to the database machine. You then 
have a program on the db machine to process files that are transferred. 
In this scenario you don't have any timing issues since you are 
essentially creating a queue that is being processed on the db machine. 
Once a file is processed it's deleted and then the program checks for 
any other files ot process. This also allows you to take the database 
down for maintenance if you have to. Lots of benefits to this setup.


On Thursday, October 24, 2002, at 08:45 PM, [EMAIL PROTECTED] 
wrote:

*	Is there any explicit tuning which can be done to speed up access
	over the network (short of adding gig-ethernet cards which isn't
	likely) ?


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


-
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 2013: Lost connection to MySQL server during query

Davide,
Friday, October 25, 2002, 11:57:23 AM, you wrote:

DP> I'm new to MySQL. I am trying to set replication in MySQL but i get the
DP> error in the subject. 

DP> Can you help me please?

Can you be more detailed?
What OS? What versions of MySQL servers? What did you done before you got
this error? You gave incomplete info ..



-- 
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: MySQL with Slackware -- wha?

2002-10-25 Thread gerald_clark

Do you have a Linux user 'mysql', and does mysql own the database
directories/subdirectories/files ?

Blain Nelson wrote:

Howdy,

I've used MySQL before, a few years ago, under Slackware. I never could get it to compile (despite
lots of help from folks here), but a pre-rolled binary did just fine for what I needed at the time.
That system is no longer hooked up.

I've recently installed a newer version of Slack (7.0 I believe) which comes with MySQL in it, but I
can't get mysqld to run either on its own or (preferably) with safe_mysqld.

It appears that all the scripts are in /usr/bin/, mysqld is in /usr/libexec/ and the data files are off
of /var/lib/mysql/.

I did do mysql_install_db, but, when I try to use safe_mysqld &, it says that it's starting, and then
it says that it's done. When I look in /var/lib/mysql/ there is a .err file that says
"/usr/libexec/mysqld Can't find file: './mysql/host.frm' (errno: 13)". It's very insistant about this,
btw -- I've checked several times, and that's all that it has to say about that.

The manual says that errno: 13 means we've got a permission problem, but I've tried chmod to the
/var/lib/mysql/ and /var/lib/mysql/mysql/ directories and their contents, and that doesn't seem to make
anybody happier.

So, for you folks I've seen in the archive saying how Slack rocks (with which I agree), a hand would be
appreciated.

Additional data in case it's handy:

mysqlaccess indicates that this is:
$VERSION = "2.06, 20 Dec 2000";
and
$SERVER = "3.21"

Any other information you can tell me how to find out for you will be given on request, but I may ask
for commonly used words to be defined or clarified because I'm not all that great with this stuff.

TIA,
Blain

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

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

re: RE: Understanding MySQL column type SET

Artem,
Friday, October 25, 2002, 12:55:14 AM, you wrote:

AK> I have v.4.0.4b max nt, and I have the same result, even more:

AK> mysql> INSERT INTO settest SET chain="A,C";
AK> ERROR 1062: Duplicate entry 'A,C' for key 1
AK> mysql> INSERT INTO settest SET chain="C,A";
AK> ERROR 1062: Duplicate entry 'A,C' for key 1

AK> but

AK> mysql> SELECT * FROM settest WHERE FIND_IN_SET('C,A', chain)>0;
AK> Empty set (0.00 sec)

AK> I guess it can be a bug.

It's not a bug, it's a behaviour of a SET column type.

When you INSERT "C,A" in the settest, this value will be re-ordered to
"A,C" at first. As chain can contain only unique values, you get
"Duplicate entry" error.

There is no value "C,A" in the table, that is why you get an empty
result set. There is a mention about it in Paul DuBois's book (pg 106).

AK> -Original Message-
AK> From: Lopez David E-r9374c [mailto:r9374c@;motorola.com]
AK> Sent: Thursday, October 24, 2002 5:09 PM
AK> To: Mysql List (E-mail)
AK> Subject: Understanding MySQL column type SET


AK> Gurus

AK> I'm having trouble understanding the column type SET.
AK> To explain my problem, I'll create a table, populate
AK> it, and do selects.


AK> mysql> CREATE TABLE settest( chain SET( "A", "B", "C" ) NOT NULL,
AK>   UNIQUE INDEX ichain( chain ) );

AK> mysql> INSERT INTO settest SET chain="A,C";

AK> mysql> SELECT * from settest;
AK> +---+
AK> | chain |
AK> +---+
AK> | A,C   |
AK> +---+

AK> mysql> SELECT * FROM settest WHERE chain="A,C";
AK> +---+
AK> | chain |
AK> +---+
AK> | A,C   |
AK> +---+

AK> mysql> SELECT * FROM settest WHERE chain="C,A";
AK> Empty set (0.00 sec)

AK>  or 

AK> mysql> SELECT * FROM settest WHERE FIND_IN_SET("C,A", chain);
AK> Empty set (0.01 sec)

AK> In reading MySQL Reference Manual, this second select statement 
AK> should work. But in version()=3.23.49-nt-log, it does not. 

AK> In my understanding of set theory, if a SET has A,B,C

AK>   A,C == C,A

AK> Can anyone tell me what I'm missing?

AK> BTW, for my application, I'm only interested in unique entries.
AK> ---
AK> David E Lopez


-- 
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: MySQL with Slackware -- wha?

Blain,
Friday, October 25, 2002, 2:11:11 AM, you wrote:

BN> I've used MySQL before, a few years ago, under Slackware.  I never could get it to 
compile (despite 
BN> lots of help from folks here), but a pre-rolled binary did just fine for what I 
needed at the time.  
BN> That system is no longer hooked up.

BN> I've recently installed a newer version of Slack (7.0 I believe) which comes with 
MySQL in it, but I 
BN> can't get mysqld to run either on its own or (preferably) with safe_mysqld.  

BN> It appears that all the scripts are in /usr/bin/, mysqld is in /usr/libexec/ and 
the data files are off 
BN> of /var/lib/mysql/.

BN> I did do mysql_install_db, but, when I try to use safe_mysqld &, it says that it's 
starting, and then 
BN> it says that it's done.  When I look in /var/lib/mysql/ there is a .err file that 
says 
BN> "/usr/libexec/mysqld Can't find file: './mysql/host.frm' (errno: 13)".  It's very 
insistant about this, 
BN> btw -- I've checked several times, and that's all that it has to say about that.

BN> The manual says that errno: 13 means we've got a permission problem, but I've 
tried chmod to the 
BN> /var/lib/mysql/ and /var/lib/mysql/mysql/ directories and their contents, and that 
doesn't seem to make 
BN> anybody happier.  

BN> So, for you folks I've seen in the archive saying how Slack rocks (with which I 
agree), a hand would be 
BN> appreciated.  

BN> Additional data in case it's handy:

BN> mysqlaccess indicates that this is:
BN> $VERSION= "2.06, 20 Dec 2000";
BN> and 
BN> $SERVER = "3.21"

BN> Any other information you can tell me how to find out for you will be given on 
request, but I may ask
BN> for commonly used words to be defined or clarified because I'm not all that great 
with this stuff.

MySQL must be owner of the data dir.

chown -R mysql /var/lib/mysql


-- 
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: re: re: innodb tables backup

Natale,
Friday, October 25, 2002, 1:44:19 PM, you wrote:

NB> i tried it ... but nothing to do!
NB> when mysql parse the foreign key in the create table i
NB> get the error.

NB> perhaps i'm wronging in restoring tables/db!

NB> i use this method:
shell> mysql -u  -p < 

NB> is it wrong?

What version of MySQL server do you use?
I already wrote you that it works only since 3.23.52 and 4.0.3


-- 
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: MySQL 4.0.4 Difference

Fernando,
Thursday, October 24, 2002, 5:35:02 PM, you wrote:

FG> I would like to know what is the difference between MySQL 4.0.4 MAX & PRO.

Yes.
Here is described all packages:
 http://www.mysql.com/news/article-111.html



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

innodb tablespace size

2002-10-25 Thread Natale Babbo

innodb_data_file_path=ibdata1:100M:autoextended:max:200M

anyone knows what happen if the above innodb
tablespace reach the limit of 200M?

Thanks in advance.
Natale Babbo


sql

__
Mio Yahoo!: personalizza Yahoo! come piace a te 
http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/

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

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

Re: Mysql Innodb performance slow

2002-10-25 Thread Richard Clarke

Jeroen,

Two things are likely to make this umpteen times faster.

a) Commit the insert transaction every.. say 1000 records?
b) use mysql's extended insert statement,
insert into mytable values
(row1_field1,row1_field2),(row2_field1,row2_field2),(?,?),(?,?) etc etc

Ric.


- Original Message -
From: "Jeroen Geusebroek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 12:11 PM
Subject: Mysql Innodb performance slow


Hi There,

We have currently an Interbase Database with millions and millions of
rows which I would like
to migrate to MySQL if possible to increase the speed.

Transaction support is necessary, so I am using innoDB.

When inserting 160K rows in the database (in an innoDB table) it takes
about 700! seconds
while the amount of same rows when inserted in a myisam table take about
100 seconds.

Now probably this can be fine tuned (I hope), and would like to ask for
some suggestions.

Is anybody using innodb with this amount of rows?  I'm curious of what
the performance is.

Is there something I should keep in mind when migrating?

Kind regards,

Jeroen Geusebroek

-
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

Mysql Innodb performance slow

Hi There,

We have currently an Interbase Database with millions and millions of
rows which I would like 
to migrate to MySQL if possible to increase the speed.

Transaction support is necessary, so I am using innoDB.

When inserting 160K rows in the database (in an innoDB table) it takes
about 700! seconds
while the amount of same rows when inserted in a myisam table take about
100 seconds.

Now probably this can be fine tuned (I hope), and would like to ask for
some suggestions.

Is anybody using innodb with this amount of rows?  I'm curious of what
the performance is.

Is there something I should keep in mind when migrating?

Kind regards,

Jeroen Geusebroek

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

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

re: re: innodb tables backup

2002-10-25 Thread Natale Babbo

i tried it ... but nothing to do!
when mysql parse the foreign key in the create table i
get the error.

perhaps i'm wronging in restoring tables/db!

i use this method:
shell> mysql -u  -p < 

is it wrong?

thanks.
Natale Babbo



 --- Victoria Reznichenko
<[EMAIL PROTECTED]> ha scritto: >
Natale,
> Friday, October 25, 2002, 10:08:00 AM, you wrote:
> 
> NB> ok ... that's right for data (insert into ...)
> ... but
> NB> i get the error before ... when mysql try to
> create
> NB> child table:
> NB> CREATE TABLE ... idParent BIGINT, INDEX
> idpar_ind
> NB> (idParent), FOREIGN KEY (idParent) REFERENCES
> NB> parent(id)
> NB> .. when mysql parses the foreign key, parent
> table
> NB> doesn't exist yet!
> 
> No, it's true not only for data.
> Put
> 
> SET FOREIGN_KEY_CHECKS=0;
> 
> in the dump file and then restore tables. It works
> fine for me.
> 
> NB>  --- Victoria Reznichenko
> NB> <[EMAIL PROTECTED]> ha scritto: >
> NB> Natale,
> >> Thursday, October 24, 2002, 10:57:00 AM, you
> wrote:
> >> 
> >> NB> Anyone knows how to backup innodb tables in
> the
> >> right
> >> NB> sql order?
> >> NB> ... i mean ... to allow restoring correctly
> >> NB> without foreign key constraint violation (if
> in
> >> the
> >> NB> backup file ddl code for the child table is
> >> before ddl
> >> NB> code for the parent table i get an error).
> >> 
> >> You can set up SET FOREIGN_KEY_CHECKS=0, in this
> >> case foreign key
> >> constraints will not be checked. It's supported
> >> since 3.23.52 and
> >> 4.0.3
> 
> 
> -- 
> 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
>  

__
Mio Yahoo!: personalizza Yahoo! come piace a te 
http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/

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

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

Re: can anybody tell me!!!

2002-10-25 Thread Mark

- Original Message - 
From: "svens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 3:45 AM
Subject: can anybody tell me!!!


> Hello
> 
> I have server Intel P-4 2,8Ghz 2Gb RAM
> 
> so
> and 
> I hve INNODB 
> and table with 145000 records
> and when Im trying to query
> select * from bla where date like "20021025%" order by date
> DESC limit 20 searhc time is 2,4 to 3,2 seconds
> what a hell is going on?
>  
> What can I do to fast up these quesry requests ??


Create an index on the field for the WHERE clause; like this (in Perl):

$sth = $dbh -> prepare ("ALTER table bla ADD INDEX(date)");
die $dbh->errstr if (not defined ($sth -> execute));


> I cant imagine if my table will contain some of 96
> rows  it will search my query a hundred years

Creating an index should shave off a few years. :)

- Mark

System Administrator Asarian-host.org

---
"If you were supposed to understand it,
we wouldn't call it code." - FedEx


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

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

re: mySQL logs on Linux

neal,
Friday, October 25, 2002, 2:02:18 PM, you wrote:

n> Could someone tell me where the logs are written to by default, for a 3.23
n> install of MySQL on Linux?

n> I looked in /usr/share/mysql/english and each directory leading up to it,
n> but I didn't see anything resembling a log file.

By default log files are located in the MySQL data dir.



-- 
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: mySQL logs on Linux

2002-10-25 Thread David Bordas

> Could someone tell me where the logs are written to by default, for a 3.23
> install of MySQL on Linux?
> 
> I looked in /usr/share/mysql/english and each directory leading up to it,
> but I didn't see anything resembling a log file.
> 
> Thanks.
> Neal

Logs are in your data directory with the Tables ...
Perhaps /var/mysql/data or /usr/local/mysql/data

David

-
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: Database in path to foreign key references

2002-10-25 Thread Heikki Tuuri

Christian,

- Original Message -
From: "Christian Lizell" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, October 24, 2002 6:18 PM
Subject: Database in path to foreign key references


> Hello!
>
> Is there any way to get rid of the database name in the path to the
> reference of a foreign key. When using mysqldump to copy a database
> the name of the source database is in the path of the foreign key
> reference. In my case, that is not what I want.
>
> An example:
>
> mysql> use source_database;
> mysql> create table T (
>myId int not null, KEY id_ind (myId),
>FOREIGN KEY (myId) REFERENCES T2 (otherId)
> ) type=innodb;
>
> bash> mysqldump source_database
> CREATE TABLE T (
>myId int(11) NOT NULL default '0',
>KEY id_ind (myId),
>FOREIGN KEY (`myId`) REFERENCES `source_database.T2` (`otherId`)
> ) TYPE=InnoDB;
>
> bash> mysqldump source_database | mysql destination_database
>
> Now I have a working copy of the source_database, however all
> references are to the source_database, which is really not what I want.
>
> Is this a feature or is it a bug? Is there a way to get mysql not to
> add the database name in the foreign key reference?

a good point. I have now added to my TODO list to remove the database name
SHOW CREATE TABLE output if the database is the same as the table itself.

> Thanks,
> /Christian

Thank you,

Heikki

> --
> __ Athega AB _ for net workers __
>   Hantverkargatan 21 phone +46 8 54513330
>   SE-112 21 Stockholm, SWEDEN  fax +46 8 54513338
>   http://www.athega.se/ mobile +46 709 156000

sql 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 logs on Linux

2002-10-25 Thread neal

Could someone tell me where the logs are written to by default, for a 3.23
install of MySQL on Linux?

I looked in /usr/share/mysql/english and each directory leading up to it,
but I didn't see anything resembling a log file.

Thanks.
Neal


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

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

re: re: innodb tables backup

Natale,
Friday, October 25, 2002, 10:08:00 AM, you wrote:

NB> ok ... that's right for data (insert into ...) ... but
NB> i get the error before ... when mysql try to create
NB> child table:
NB> CREATE TABLE ... idParent BIGINT, INDEX idpar_ind
NB> (idParent), FOREIGN KEY (idParent) REFERENCES
NB> parent(id)
NB> .. when mysql parses the foreign key, parent table
NB> doesn't exist yet!

No, it's true not only for data.
Put

SET FOREIGN_KEY_CHECKS=0;

in the dump file and then restore tables. It works fine for me.

NB>  --- Victoria Reznichenko
NB> <[EMAIL PROTECTED]> ha scritto: >
NB> Natale,
>> Thursday, October 24, 2002, 10:57:00 AM, you wrote:
>> 
>> NB> Anyone knows how to backup innodb tables in the
>> right
>> NB> sql order?
>> NB> ... i mean ... to allow restoring correctly
>> NB> without foreign key constraint violation (if in
>> the
>> NB> backup file ddl code for the child table is
>> before ddl
>> NB> code for the parent table i get an error).
>> 
>> You can set up SET FOREIGN_KEY_CHECKS=0, in this
>> case foreign key
>> constraints will not be checked. It's supported
>> since 3.23.52 and
>> 4.0.3

-- 
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: Socket Error