AW: Looking for tutorials/examples of ways of accessing mysql via apa che.

[Arendt, Wolfgang, VTC-DITx]

Well for java you will have to get a jdbc-driver first. I think, your best
choice was  think, to get it from here:
.

A tutorial on this topic can be found here:


I suppose, you have Apache with Tomcat as a servlet-container? Try it at


Good luck, and have fun (and this _is_ fun-stuff!)

Wolfgang Arendt

Vodafone TeleCommerce GmbH
SW Test & Config. Management
Wolfgang Arendt
Daniel-Goldbach-Str. 17-19
40880 Ratingen

Tel. +49 (0) 21 02 / 97 2492
Fax +49 (0) 21 02 / 97 2453

mailto:[EMAIL PROTECTED]
www.vodafone-telecommerce.de

-Ursprüngliche Nachricht-
Von:MacDonell, Dennis [SMTP:[EMAIL PROTECTED]]
Gesendet am:Mittwoch, 31. Januar 2001 01:34
An: 'MySQL List'
Betreff:Looking for tutorials/examples of ways of accessing
mysql via apa che.


Hi,

I've been struggling over the last couple of weeks to setup
perl/DBI/apache/mysql/php and have finally accomplished that part of
the
task. The task now is to setup databases and access the data via
active
server pages either in java or php. 

I don't have a good feel for html, but I understand the basics. 

I was wondering if someone out there had some simple
scripts/examples that
could take me through the basics of accessing a database located on
a unix
machine from PC's running Internet Explorer. 

First I would like to just like to get users to fill in a form and
then send
the form to the server and display the results. Later I would like
to be
able to insert data into the database, and allow users to recall
that data.
An example would be contacts database.

Thanks for any help people are willing to give.

Dennis

##
Dennis Macdonell
Systems Administrator
AUSLIG
mail: PO Box 2, Belconnen, ACT 2617
email: [EMAIL PROTECTED]
ph:  61 2 6201 4326
fax: 61 2 6201 4377
##



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

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



---
This Mail has been checked for Viruses
Attention: Encrypted Mails can NOT be checked !

***

Diese Mail wurde auf Viren ueberprueft
Hinweis: Verschluesselte Mails koennen NICHT geprueft werden!


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

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

how many client connections can Mysql handle?

[David Xu]

Hi,

just want to know some limits of Mysql.
by reading Mysql source code, I have found mysql still using select() to handle 
connections,  so can anyone tell me if Mysql will handle connections less than 1024 
in Linux ? I know Mysql uses per thread for client connection, on FreeBSD, 
thread number can be more than on Linux,  can handle more connections than Linux,
but this Mysql design is limited by select(),  there will have file handle occupy 
handle slot, 
so I think Mysql will handle less than 1024 connections,  right?

Thanks
David Xu

Re: Running two "Makes"

[Ashley M. Kirchner]

Evan James Dembskey wrote:

> So -
> is it possible to install Gnu make onto teh Dec in a way that it does not
> interfere at all with the rest of the system? If so, how do I do it?

By default, GNU installs under /usr/local which means, theoretically you can
install GNU make on the system without messing with the original distribution's
version.

AMK4

--
H | Hi, I'm currently out of my mind.  Please leave a message.  BP!
  |
  ~
  Ashley M. Kirchner    .   303.442.6410 x130
  Director of Internet Operations / SysAdmin. 800.441.3873 x130
  Photo Craft Laboratories, Inc. .eFax 248.671.0909
  http://www.pcraft.com  .3550 Arapahoe Ave, #6
  .. .  .  . .Boulder, CO 80303, U.S.A.



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

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 Connection Handle & IPC

[Dave]

Anyone have any ideas on how to store/retrieve an mysql connection handle
(object?) via shmget and friends? (in C of course)

I have been playing with IPC some and I would think that I should be able to
store an open connection handle in shared mem and go back and get it later,
stat it and use it...is this reasonable and can it be done??


Any ideas are appreciated...

-Dave


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

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

[Aravind.B.A]

I have mysql version mysql-3.23.32.tar.gz , which i am trying to compile

along with apache and php on my sun enterprise 220R but after executing
mysql and untaring it, in the scripts dir, i have all the files with
another extension .sh, which i am not able to execute.  now i am not
able to proceed without running this.

This is my config.log output.


configure:796: checking host system type
configure:817: checking target system type
configure:835: checking build system type
configure:870: checking for a BSD compatible install
configure:923: checking whether build environment is sane
configure:958: checking whether make sets ${MAKE}
configure:1004: checking for working aclocal
configure:1017: checking for working autoconf
configure:1030: checking for working automake
configure:1043: checking for working autoheader
configure:1056: checking for working makeinfo
configure:1158: checking whether to enable maintainer-specific portions
of Makef
iles
configure:1200: checking whether build environment is sane
configure:1217: checking whether make sets ${MAKE}
configure:1285: checking for gawk
configure:1317: checking for gcc
configure:1430: checking whether the C compiler (gcc   ) works
configure:1446: gcc -o conftest conftest.c  1>&5
configure:1472: checking whether the C compiler (gcc   ) is a
cross-compiler
configure:1477: checking whether we are using GNU C
configure:1505: checking whether gcc accepts -g
configure:1541: checking for c++
configure:1573: checking whether the C++ compiler (c++   ) works
configure:1589: c++ -o conftest conftest.C  1>&5
configure:1615: checking whether the C++ compiler (c++   ) is a
cross-compiler
configure:1620: checking whether we are using GNU C++
configure:1648: checking whether c++ accepts -g
configure:1680: checking how to run the C preprocessor
configure:1805: checking for ranlib
configure:1914: checking for ld used by GCC
configure:1976: checking if the linker (/usr/ccs/bin/ld) is GNU ld
configure:1992: checking for BSD-compatible nm
configure:2028: checking whether ln -s works
ltconfig:603: checking for object suffix
ltconfig:604: gcc -cconftest.c 1>&5
ltconfig:629: checking for executable suffix
ltconfig:630: gcc -o conftest conftest.c  1>&5
ltconfig:776: checking if gcc PIC flag -fPIC works
ltconfig:777: gcc -c   -fPIC -DPIC  conftest.c 1>&5
ltconfig:829: checking if gcc supports -c -o file.o
ltconfig:830: gcc -c   -o out/conftest2.o  conftest.c 1>&5
ltconfig:862: checking if gcc supports -c -o file.lo
ltconfig:863: gcc -c   -c -o conftest.lo  conftest.c 1>&5
ltconfig:914: checking if gcc supports -fno-rtti -fno-exceptions
ltconfig:915: gcc -c   -fno-rtti -fno-exceptions -c conftest.c
conftest.c 1>&5
ltconfig:958: checking if gcc static flag -static works
ltconfig:959: gcc -o conftest -static conftest.c  1>&5
ltconfig:1653: checking if global_symbol_pipe works
ltconfig:1654: gcc -cconftest.c 1>&5
ltconfig:1657: eval "/usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[
]\([BDT]
\)[ ][  ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$/\1 \2\3 \3/p' >
conftest.nm"
ltconfig:1709: gcc -o conftest   -fno-builtin -fno-rtti
-fno-exceptions   confte
st.c conftstm.o 1>&5
configure:2233: checking for a BSD compatible install
configure:2291: checking for bison
configure:2324: checking for pdftex
configure:2352: checking return type of sprintf


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

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

Running two "Makes"

[Evan James Dembskey]

Hi,


I believe that MySQL needs to be compiled with GNU make. I have to install
MySQL on a Dec Alpha running Digital UNIX V4.0D (Rev. 878). There are a
number of apps running on the Dec that require the native make to work. So -
is it possible to install Gnu make onto teh Dec in a way that it does not
interfere at all with the rest of the system? If so, how do I do it?


Regards,

Evan


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

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

Binary data

[Barry Radloff]

hi I am pretty new at this and would like to know how does one store a
binary blob to the mysql DB ie I would like to store a jpeg to the db

Thanks

Barry Radloff
R&D
Media24

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

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_install_Db.sh...cannot execute.

[Aravind.B.A]

Hello...

I have mysql version mysql-3.23.32.tar.gz , which i am trying to compile
along with apache and php on my sun enterprise 220R but after executing
mysql and untaring it, in the scripts dir, i have all the files with
another extension .sh, which i am not able to execute.  now i am not
able to proceed without running this.

Can anybody guide me ...plz.

Regards
Aravind


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

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: Backup?

[Van]

Steve Ruby wrote:
> 
> Scott Baker wrote:
> >
> > That's the way that I do.  I setup my server to shutdown the MySQL process
> > at 3am, zip up my var directory, and then restart the process.  Can you
> > copy the data with the server running?
> 
> If you are shutting down the server, why don't you just copy the files
> out to the backup and then restart?  Why would you want to copy them back in?
> Save the disk IO and don't remove them in the first place, it would be
> faster and you wouldn't have to worry about
> 
> Yes, you can copy them back in but you should have locks on them through
> some thread so that something doesn't try to write to them.. still
> I'm not sure I see the need since you are backing up the data and
> should not be removing it.

Sorry to be entering this thread late and perhaps ignorantly, but, backups
should be an implementation that preserves data and (if possible) maintains
useability to the application.  Log-update seems a likely candidate and pulling
the backup server into a non-update state and mysql-dumping to a file and
implementing some off-line means of getting that data somewhere useful for your
strategy should be trivial.

Perhaps, this thread applies to a situation where there's only one server.  If
so, I apologize for piping up.

For the record, I understand the implications.  Have had several server moves
last week that required extensive manual replications.  It went well, but, with
much effort.  Redundant servers is appearing more-and-more the most viable way
to keep servers up, secured, and complete.  What inspires this most is uptime. 
There are MySQL means to do this without shutting the server down, if there are
additional servers to play with.  If I'm off-base, I apologize.

Regards,
Van

-- 
=
Linux rocks!!!   http://www.dedserius.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: Backup?

[Steve Ruby]

Scott Baker wrote:
> 
> That's the way that I do.  I setup my server to shutdown the MySQL process
> at 3am, zip up my var directory, and then restart the process.  Can you
> copy the data with the server running?


If you are shutting down the server, why don't you just copy the files
out to the backup and then restart?  Why would you want to copy them back in?
Save the disk IO and don't remove them in the first place, it would be
faster and you wouldn't have to worry about

Yes, you can copy them back in but you should have locks on them through
some thread so that something doesn't try to write to them.. still
I'm not sure I see the need since you are backing up the data and
should not be removing it.

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

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: Backup?

[Marc Swanson]

> > Its not recommended to just `cp' your data directory for use
> > later. You should always dump the database with mysqldump.
>
> Eh?
>
> If you know what you're doing, there's nothing unsafe about it and it
> is WAY faster than using mysqldump.


You're absolutely right.. but try telling that to a client :-)
Most people that ask me to setup a backup system for them want to be able to
see/touch/feel their data in ascii format so they're certain its all
there 


If that's the case you can use a utility I wrote in perl that dumps
databases into a nice directory tree... http://www.mswanson.com/mybackup or
under the contributed section of the mysql website.


-Marc-


#/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
#Marc Swanson |  \|||/  #
#MSwanson Consulting  |  /o o\  #
#Phone:  (603)868-1721|-oooOooo-#
#Fax:(603)868-1730|  Solutions in:  #
#[EMAIL PROTECTED] |  'PHP'Perl  #
# |  'SQL'C++   #
# |  'HTML   'Sh/Csh#
# http://www.mswanson.com |  'Javascript#
#/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#


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

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: A few queries about optimising MySQL variables

[Jeremy D. Zawodny]

On Tue, Jan 30, 2001 at 10:56:56AM +, Basil Hussain wrote:
> 
> Having just upgraded my MySQL server to the latest 3.23.32 version,
> I thought it would be a good idea to have a review of the
> configuration and try to optimise the setup further. I hope someone
> can help me by answering a few queries I have.
> 
> Here's a bit of info about the spec. of the server:
> 
> * Pentium III 600 Mhz
> * 512 Mb RAM
> * Data directories stored on RAID 0 partition
> * RedHat Linux 6.2 (with 2.2.16-22 kernel, retrofitted from RH7)

Got it.

> The majority of the queries to the server are from a few web servers
> using PHP4, connecting using persistant connections (it normally
> runs with approx.  100-150 idle threads because of this).
> 
> So, I have a few questions:
> 
> 1. I think I need to optimise table_cache. It's currently set to the
> default of 64. There are a total of 70 tables on the system. The
> manual says you should increase table_cache if the Opened_tables
> status variable is big. How large is 'big'? This value is currently
> 274 on my system. By how much should I increase table_cache? As a
> guide, the my-large.cnf sample config sets this to 256 - would this
> suit my setup?

Sounds reasonable. It shouldn't make a big impact, but it shouldn't
hurt either.

> 2. I currently have sort_buffer at 8 MB. The sample 'large' config
> suggests 1 Mb. The manual says this should be increased to improve
> sorts and grouping performance - which my queries do a lot
> of. Performance seems fine at the moment, but am I unnecessarily
> using too much memory?

It is allocated on a per-thread basis but only when needed. You can
try to increase it and see if you notice a difference. But with 512MB
and few queries doing sorts, it may not be a big deal. However, if a
lot of your queries require sorting large amounts of data, you may
really benefit.

Really, it's best to run some benchmarks that reflect the workload on
your server and tweak the parameters to see what difference (if any)
the changes make.

> 3. My record_buffer is set to 16 Mb (at the suggestion of someone
> else). The sample 'large' config suggests also 1 Mb. I'm not quite
> sure I understand what this affects. The manual states that: "if you
> do many sequential scans, you may want to increase this value" - but
> what kind of query would make a sequential scan?

Queries that require a full table scan (those which don't or can't use
indexes). "Sequential scans" can mean "full table scans".

> Any answers gratefully accepted!

You didn't mention the key_buffer. If configured well, you can get a
great performance boost from it.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

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

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: Query out field names???

[Ryan Wahle]

If you do a 

DESC tblNAME;

you can go through row by row and check if the Default is NULL

On Tue, 30 Jan 2001, Shawn Cummings wrote:

> 
> 
> 
> I want to query out the field names where the "Default" is NULL ... so I 
> can populate an HTML page for input...
> 
> SHOW FIELDS FROM tblNAME;
> 
> This shows the fieldnames, and the properties -- but how can I just get a 
> list of the fieldnames where the Default is NULL -- or how can I get this 
> list from a Perl script??
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> 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: Mysqld eats up RAM and CPU

[Tony Shiu]

Let me clarify that

those variables in the list Jan mentioned I use mysql default values, others
unmentioned I make them near megabytes.

Per Andrei replied, I suspect it is due to design/query problems.



 -Original Message-
From:   Andrei Cojocaru [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, January 31, 2001 12:49 PM
To: Tony Shiu
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject:RE: Mysqld eats up RAM and CPU

on my server which runs an online game the values are all in the
megabytes

On Wed, 31 Jan 2001, Tony Shiu wrote:

> I wonder the normalization and indexing of tables, Awa the complexity
of
> queries submitted to server. For those variables you mentioned I use
in
> production without significantly slow-down in peak time.
>
>
>  -Original Message-
> From: Matis, Jan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2001 12:46 AM
> To:   'Sam Wong'; [EMAIL PROTECTED]
> Subject:  RE: Mysqld eats up RAM and CPU
>
> what about this ?
>
> 2*PII 450 MHZ
> 1G RAM
> data on hardware raid
>
> port= 3306
> socket  = /tmp/mysql.sock
> user= mysql
> skip-locking
> set-variable= key_buffer=16M
> set-variable= max_allowed_packet=1M
> set-variable= thread_stack=128K
> set-variable= wait_timeout=150
> set-variable= max_connections=768
> set-variable = record_buffer=12k
> set-variable = net_buffer_length=12k
> set-variable = sort_buffer=12k
> set-variable = table_cache=12
>
>
>
> I've never had more than 512 conections ... but sometimes mysql looks
> really
> slow ...
> ant load goes up to 40
> do U have some ideas ?
>
>
> Jan
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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
>
>

--
-Spinlock
EmpireQuest Creator
http://www.empirequest.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: AND on a many to many table, with arbitrary ANDs

[hooker]

Julien

What you're trying to do isn't that uncommon, and I've met the same
problems in two major systems that I've built over the last year.

My solution was to use SQL up to a point (i.e. limit the complexity
of the query) to protect the performance of the server. So, for example,
you can read every record from the StoryCategories table into either a
Perl script (if you want fast development) or a C program (if you want
fast CGI performance) and examine then accept/reject each as you meet
it.

It takes a bit more programming skill, but the server will survive far
more simultaneous enquiries that way than it will with a single complex
SQL query.

Hope this helps some.


The Hooker
--
"I've had a perfectly wonderful evening, but this wasn't it"




> I am in the process of building a search engine on a database. I have two
> tables that have a many-to-many relationship: A story table and a category
> table.
> 
> Story Table:
> ---
> id | story|
> ---
> 1  | Alice in Wonderland
> 2  | Peter Pan
> 3  | Pokemon's adventure
> 4  | Tale of Two cities
> 5  | War and Peace
> 
> ..etc..
> 
> 
> 
> Category Table:
> --
> id | category|
> --
> 1  | Children
> 2  | Classics
> 3  | Tolstoy
> ..etc..
> `
> 
> 
> Storycategories Table:
> --
> storyid | catid  |
> -
> 1   | 1
> 1   | 2
> 2   | 1
> 2   | 2
> 3   | 1
> 4   | 2
> 5   | 2
> 5   | 3
> ..etc..
> 
> 
> >From my (admittedly dim) understanding of SQL, this is how one is supposed
> to organize a many-to-many relationship. So peter pan is listed as 1
> (childrens) and 2 (classics).
> 
> I am writing a web interface to do searches for stories. In my web 
> interface, you have something like this:
> 
> ---
> 
> []Classics []Childrens []Tolstoy []Fiction ... 
> 
> Search Categories:
> (x) match all categories
> ( ) match any category
> 
> ---
> 
> In order to build a query that matches ALL categories, I use aliasing. To do
> a search on stories that are Children AND Classics, I make two instances of
> each table as shown in the example below.
> 
> select
> S.story
>  from
>stories_tbl S,
>categories_tbl C1, storycategories_tbl O1,
>categories_tbl C2, storycategories_tbl O2
>  where
>S.id = O1.storyid and O1.catid = C1.id and
>  C1.category like "Children" and
>S.id = O2.storyid and O2.catid = C2.id and
>  C2.category like "Classic"
>  group by
>story
> 
> 
> This query works fine. My problem arises when I have many categories to
> choose from. If I check many of the categories boxes, and select match all
> categories, my program builds a query with a large amount of tables, I get
> an error like this:
> 
> Error 1116: Too many tables. MySQL can only use 32 tables in a join 
> 
> My guess is that there is a limit of 32 tables in a join, and that my use of
> aliasing here ends up violating the 32 table limit.
> 
> Even worse is when I make a query that has a little less than 32 tables.
> This won't give an error, but will leave a process running on the machine
> that consumes 100% cpu. After a while, this process will render the database
> unusable, and no one can use the database until the process is killed!
> 
> 
> So to clarify, the query that ends up being built looks like this:
> select
> S.story
>  from
>stories_tbl S,
>categories_tbl C1, storycategories_tbl O1,
>categories_tbl C2, storycategories_tbl O2
>
>categories_tbl Cn, storycategories_tbl On
> 
>  where
>S.id = O1.storyid and O1.catid = C1.id and
>  C1.category like "Children" and
>S.id = O2.storyid and O2.catid = C2.id and
>  C2.category like "Classic"
>...
>S.id = On.storyid and On.catid = Cn.id and
>  Cn.category like ""
>  group by
>story
> 
> 
> This query fails when "n" is around 16.
> 
> My question is, how can I build a query that will support an arbitrary
> number of ANDs on a many to many relationship? I'd like to be able to do a
> search on stories that are "Children AND Classics AND Tolstoy AND
> Category N" where N is fairly large (hundred or so)..
> 
> Is there any way to do this? Am I using aliasing incorrectly?
> 
> Those of you that have made it in reading this far, thank you :). I
> appreciate your attention and any assistance you might lend me in this
> matter.
> 
> Julien Beasley

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

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: Are index file only for querying?

[Andrei Cojocaru]

does not matter you are signed up for this mailing list, to unsubscribe
send an email to [EMAIL PROTECTED] with any subject or
text message your heart desires, but make sure you use the email that you
are subscribed with on the mailing list

On Wed, 31 Jan 2001, Ha Linh Don wrote:

> HEllo,
> 
> My name is Don , but I am not interested in "msql". May be , you are
> confused me
> with another person who is expert in database.
> 
> Please remove me out of your mail list
> 
> Thanks
> 
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 26, 2001 11:45 PM
> To: Don
> Cc: msql list
> Subject: Re: Are index file only for querying?
> 
> 
> In the last episode (Jan 26), Don said:
> > I have a table called Ports that contains Port information and has
> > several columns.  I've designated the Portname column as Primary as
> > it is unique (I did not specify it as unique). When I do a:
> > 
> > SELECT * FROM Ports;
> > 
> > It does NOT show the table contents in index order (Portname
> > beginning with "A" all the way through "Z") but rather in the order
> > they were entered.
> 
> SQL tries to give you your results as fast as possible.  Indexes are
> used when they can help.  They cause more disk I/O though, so if MySQL
> determines that a query will read more than 10% (I think) of the
> records in a table, it simply drops to a full table scan.
>  
> > So, it seems to me that indexes are only used for querying.  If I run
> > through the data or issue the above SELECT statement, how do I
> > display my rows in Primary Key order?
> 
> SELECT * FROM Ports ORDER BY Portname;
> 
> 

-- 
-Spinlock
EmpireQuest Creator
http://www.empirequest.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: AND on a many to many table, with arbitrary ANDs

[Andrei Cojocaru]

if my understanding is correct just have two joins using ors for the
categories :-)

On Tue, 30 Jan 2001, Beasley, Julien wrote:

> Hello everyone,
> 
> I am in the process of building a search engine on a database. I have two
> tables that have a many-to-many relationship: A story table and a category
> table.
> 
> Story Table:
> ---
> id | story|
> ---
> 1  | Alice in Wonderland
> 2  | Peter Pan
> 3  | Pokemon's adventure
> 4  | Tale of Two cities
> 5  | War and Peace
> 
> ..etc..
> 
> 
> 
> Category Table:
> --
> id | category|
> --
> 1  | Children
> 2  | Classics
> 3  | Tolstoy
> ..etc..
> `
> 
> 
> Storycategories Table:
> --
> storyid | catid  |
> -
> 1   | 1
> 1   | 2
> 2   | 1
> 2   | 2
> 3   | 1
> 4   | 2
> 5   | 2
> 5   | 3
> ..etc..
> 
> 
> >From my (admittedly dim) understanding of SQL, this is how one is supposed
> to organize a many-to-many relationship. So peter pan is listed as 1
> (childrens) and 2 (classics).
> 
> I am writing a web interface to do searches for stories. In my web 
> interface, you have something like this:
> 
> ---
> 
> []Classics []Childrens []Tolstoy []Fiction ... 
> 
> Search Categories:
> (x) match all categories
> ( ) match any category
> 
> ---
> 
> In order to build a query that matches ALL categories, I use aliasing. To do
> a search on stories that are Children AND Classics, I make two instances of
> each table as shown in the example below.
> 
> select
> S.story
>  from
>stories_tbl S,
>categories_tbl C1, storycategories_tbl O1,
>categories_tbl C2, storycategories_tbl O2
>  where
>S.id = O1.storyid and O1.catid = C1.id and
>  C1.category like "Children" and
>S.id = O2.storyid and O2.catid = C2.id and
>  C2.category like "Classic"
>  group by
>story
> 
> 
> This query works fine. My problem arises when I have many categories to
> choose from. If I check many of the categories boxes, and select match all
> categories, my program builds a query with a large amount of tables, I get
> an error like this:
> 
> Error 1116: Too many tables. MySQL can only use 32 tables in a join 
> 
> My guess is that there is a limit of 32 tables in a join, and that my use of
> aliasing here ends up violating the 32 table limit.
> 
> Even worse is when I make a query that has a little less than 32 tables.
> This won't give an error, but will leave a process running on the machine
> that consumes 100% cpu. After a while, this process will render the database
> unusable, and no one can use the database until the process is killed!
> 
> 
> So to clarify, the query that ends up being built looks like this:
> select
> S.story
>  from
>stories_tbl S,
>categories_tbl C1, storycategories_tbl O1,
>categories_tbl C2, storycategories_tbl O2
>
>categories_tbl Cn, storycategories_tbl On
> 
>  where
>S.id = O1.storyid and O1.catid = C1.id and
>  C1.category like "Children" and
>S.id = O2.storyid and O2.catid = C2.id and
>  C2.category like "Classic"
>...
>S.id = On.storyid and On.catid = Cn.id and
>  Cn.category like ""
>  group by
>story
> 
> 
> This query fails when "n" is around 16.
> 
> My question is, how can I build a query that will support an arbitrary
> number of ANDs on a many to many relationship? I'd like to be able to do a
> search on stories that are "Children AND Classics AND Tolstoy AND
> Category N" where N is fairly large (hundred or so)..
> 
> Is there any way to do this? Am I using aliasing incorrectly?
> 
> Those of you that have made it in reading this far, thank you :). I
> appreciate your attention and any assistance you might lend me in this
> matter.
> 
> Julien Beasley
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 

-- 
-Spinlock
EmpireQuest Creator
http://www.empirequest.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: Mysqld eats up RAM and CPU

[Andrei Cojocaru]

on my server which runs an online game the values are all in the megabytes

On Wed, 31 Jan 2001, Tony Shiu wrote:

> I wonder the normalization and indexing of tables, Awa the complexity of
> queries submitted to server. For those variables you mentioned I use in
> production without significantly slow-down in peak time.
> 
> 
>  -Original Message-
> From: Matis, Jan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2001 12:46 AM
> To:   'Sam Wong'; [EMAIL PROTECTED]
> Subject:  RE: Mysqld eats up RAM and CPU
> 
> what about this ?
> 
> 2*PII 450 MHZ
> 1G RAM
> data on hardware raid
> 
> port= 3306
> socket  = /tmp/mysql.sock
> user= mysql
> skip-locking
> set-variable= key_buffer=16M
> set-variable= max_allowed_packet=1M
> set-variable= thread_stack=128K
> set-variable= wait_timeout=150
> set-variable= max_connections=768
> set-variable = record_buffer=12k
> set-variable = net_buffer_length=12k
> set-variable = sort_buffer=12k
> set-variable = table_cache=12
> 
> 
> 
> I've never had more than 512 conections ... but sometimes mysql looks
> really
> slow ...
> ant load goes up to 40
> do U have some ideas ?
> 
> 
> Jan
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> 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
> 
> 

-- 
-Spinlock
EmpireQuest Creator
http://www.empirequest.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

AND on a many to many table, with arbitrary ANDs

[Beasley, Julien]

Hello everyone,

I am in the process of building a search engine on a database. I have two
tables that have a many-to-many relationship: A story table and a category
table.

Story Table:
---
id | story|
---
1  | Alice in Wonderland
2  | Peter Pan
3  | Pokemon's adventure
4  | Tale of Two cities
5  | War and Peace

..etc..



Category Table:
--
id | category|
--
1  | Children
2  | Classics
3  | Tolstoy
..etc..
`


Storycategories Table:
--
storyid | catid  |
-
1   | 1
1   | 2
2   | 1
2   | 2
3   | 1
4   | 2
5   | 2
5   | 3
..etc..


>From my (admittedly dim) understanding of SQL, this is how one is supposed
to organize a many-to-many relationship. So peter pan is listed as 1
(childrens) and 2 (classics).

I am writing a web interface to do searches for stories. In my web 
interface, you have something like this:

---

[]Classics []Childrens []Tolstoy []Fiction ... 

Search Categories:
(x) match all categories
( ) match any category

---

In order to build a query that matches ALL categories, I use aliasing. To do
a search on stories that are Children AND Classics, I make two instances of
each table as shown in the example below.

select
S.story
 from
   stories_tbl S,
   categories_tbl C1, storycategories_tbl O1,
   categories_tbl C2, storycategories_tbl O2
 where
   S.id = O1.storyid and O1.catid = C1.id and
 C1.category like "Children" and
   S.id = O2.storyid and O2.catid = C2.id and
 C2.category like "Classic"
 group by
   story


This query works fine. My problem arises when I have many categories to
choose from. If I check many of the categories boxes, and select match all
categories, my program builds a query with a large amount of tables, I get
an error like this:

Error 1116: Too many tables. MySQL can only use 32 tables in a join 

My guess is that there is a limit of 32 tables in a join, and that my use of
aliasing here ends up violating the 32 table limit.

Even worse is when I make a query that has a little less than 32 tables.
This won't give an error, but will leave a process running on the machine
that consumes 100% cpu. After a while, this process will render the database
unusable, and no one can use the database until the process is killed!


So to clarify, the query that ends up being built looks like this:
select
S.story
 from
   stories_tbl S,
   categories_tbl C1, storycategories_tbl O1,
   categories_tbl C2, storycategories_tbl O2
   
   categories_tbl Cn, storycategories_tbl On

 where
   S.id = O1.storyid and O1.catid = C1.id and
 C1.category like "Children" and
   S.id = O2.storyid and O2.catid = C2.id and
 C2.category like "Classic"
   ...
   S.id = On.storyid and On.catid = Cn.id and
 Cn.category like ""
 group by
   story


This query fails when "n" is around 16.

My question is, how can I build a query that will support an arbitrary
number of ANDs on a many to many relationship? I'd like to be able to do a
search on stories that are "Children AND Classics AND Tolstoy AND
Category N" where N is fairly large (hundred or so)..

Is there any way to do this? Am I using aliasing incorrectly?

Those of you that have made it in reading this far, thank you :). I
appreciate your attention and any assistance you might lend me in this
matter.

Julien Beasley



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

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: Mysqld eats up RAM and CPU

[Tony Shiu]

I wonder the normalization and indexing of tables, Awa the complexity of
queries submitted to server. For those variables you mentioned I use in
production without significantly slow-down in peak time.


 -Original Message-
From:   Matis, Jan [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, January 31, 2001 12:46 AM
To: 'Sam Wong'; [EMAIL PROTECTED]
Subject:RE: Mysqld eats up RAM and CPU

what about this ?

2*PII 450 MHZ
1G RAM
data on hardware raid

port= 3306
socket  = /tmp/mysql.sock
user= mysql
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_packet=1M
set-variable= thread_stack=128K
set-variable= wait_timeout=150
set-variable= max_connections=768
set-variable = record_buffer=12k
set-variable = net_buffer_length=12k
set-variable = sort_buffer=12k
set-variable = table_cache=12



I've never had more than 512 conections ... but sometimes mysql looks
really
slow ...
ant load goes up to 40
do U have some ideas ?


Jan

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

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: Are index file only for querying?

[Ha Linh Don]

HEllo,

My name is Don , but I am not interested in "msql". May be , you are
confused me
with another person who is expert in database.

Please remove me out of your mail list

Thanks

-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 11:45 PM
To: Don
Cc: msql list
Subject: Re: Are index file only for querying?


In the last episode (Jan 26), Don said:
> I have a table called Ports that contains Port information and has
> several columns.  I've designated the Portname column as Primary as
> it is unique (I did not specify it as unique). When I do a:
> 
> SELECT * FROM Ports;
> 
> It does NOT show the table contents in index order (Portname
> beginning with "A" all the way through "Z") but rather in the order
> they were entered.

SQL tries to give you your results as fast as possible.  Indexes are
used when they can help.  They cause more disk I/O though, so if MySQL
determines that a query will read more than 10% (I think) of the
records in a table, it simply drops to a full table scan.
 
> So, it seems to me that indexes are only used for querying.  If I run
> through the data or issue the above SELECT statement, how do I
> display my rows in Primary Key order?

SELECT * FROM Ports ORDER BY Portname;

-- 
Dan Nelson
[EMAIL PROTECTED]

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

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



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

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: Looking for tutorials/examples of ways of accessing mysql via apache.

[Daniel Von Fange]

For begining PHP and MySQL this 10-part series is great! 
http://www.webmasterbase.com/article.php?aid=228&pid=0

To control your database remotely check out
http://www.phpwizard.net/projects/phpMyAdmin/
It's very easy to use.

Hope this helps!
-Daniel 



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

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

Replication issue

[Scott Vanderweyst]

Is it possible to define multiple masters for a specific server:
ie: Updates from different servers all update to a single backup server

I'd prefer not to need to set up a circular replication scheme, due to
geographical issues, and also data relavance issues.

Taking a quick look through the source makes it appear that there isn't
currently that functionality.

What are some other ways that I might be able to do this... Multiple
servers on the same machine using the same base directory/databases with
locking enabled(Is this even possible???)

Basically (bi-directional chain)
box0<-box1<->box2<->box3->box4
where arrows show direction of data transmission

Any advice would be appreciated
Scott V


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

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: HYPERLINK type column conversion to ???

[Bob Hall]

>What should I convert Access97 HYPERLINK column type to in MySQL? 
>How do I get Access97 form to look at that new converted column same 
>way as with native column.
>Any suggestions? Everyone in the office was pretty used to clicking 
>on the link to the file in the form, but now I am not able to do 
>this since conversion.
>
>Apollo

Sir, if I recall correctly, I did this by using code behind the form 
that converted a properly formatted URL string to a hyperlink. This 
is an Access question, so I won't elaborate here. If you send me an 
e-mail, I'll try to dig up a code sample in a few days when I have 
the time.

Bob Hall

Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak

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

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

Re: how to get the union of the values in a SET column ?

[Bob Hall]

>Hi again Bob,
>
>  >>I know it's not 'proper' database design and I should have
>  >>normalized the one-to-many relationships to multiple tables.
>  >>However, it was fast and gave me a result which worked quickly
>  >>(and up against a mad deadline).
>  >
>  >I think you've just identified the most common use of the SET datatype.
>  >
>  >In your original posting, you said that a procedural solution
>  >wouldn't scale well. If you database will never be more than 5,000
>  >records, why are you concerned about scalability? Are you planning on
>  >processing a hundred concurrent queries?
>
>I meant scalability in terms of the number of items in the SET
>(not the number of rows in the table). For example, consider a
>SET field with 26 items -
>eg. set_col SET ('A','B','C'. 'Z')
>
>If I wish to find out which values of the SET have been used
>at least once, I have to either:
>a) Query for each member of the SET and find out which gives a result:
>SELECT * FROM my_table WHERE set_col LIKE ('%A%')
>SELECT * FROM my_table WHERE set_col LIKE ('%B%')
>etc.
>b) Select DISTINCT(set_col) and then parse the results
>for for each member of the set .. which is a worse method.
>
>I was hoping that since each member of the SET really
>represents a number, that there would be some bitwise
>operation that would painlessly produce all the members
>of the SET that appear at least once.

Sir, I apologize  for taking so long to respond. I was moving some 
furniture this weekend and dropped a desk on my keyboard.

You are right about SETs, and I am blind. The obvious solution is the 
bitwise or. MySQL has a summary function called Bit_Or(). 
Unfortunately, it returns a decimal representation of the result, so 
you have to massage it a little.
SELECT Bin(Bit_Or(column_name)) FROM your_table;
The bits are in reverse order; if your SET declaration includes a, b, 
c, and d, and you columns include all but b, you'll get 1101 from the 
SELECT statement. This is fine if you're going to process the bits in 
your client. But if you want to display the bits in MySQL in the same 
order as your SET declaration, you can use
Reverse(Binary(Bin(Bit_Or(column_name
which will give you 1011.

Bob Hall

Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak

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

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: normal cpu usage

[Jeremy D. Zawodny]

On Tue, Jan 30, 2001 at 07:38:06PM -0300, Alejandro M. Leonian wrote:

> Hi guys..would you be so kind to tell me what's the normal % of cpu
> usage per mysqld thread?  i get some 10.5 or 12 % peaks, which
> frighten me a lil' bit.  Thanks!

It depends. ;-) I don't think there is a norm.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

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

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

myODBC time problems in Access

[Gregory King]

Im trying to use myodbc to enter some data through MS access.  The problem
is, when I link to the table it shows the data in my data formatted fields
all messed up.  The data in the mysql table is fine, it is something the
odbc driver or access is doing.  I read on the Egroup that Scott Baker was
having a simular problem in September, but I didnt see any responses to
his request for help.

Is anyone familiar with the problem / solutions?

Thanks in advance...

Greg



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

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: Backup?

[Jeremy D. Zawodny]

On Tue, Jan 30, 2001 at 05:07:40PM -0800, Scott Baker wrote:

> That's the way that I do.  I setup my server to shutdown the MySQL
> process at 3am, zip up my var directory, and then restart the
> process.  Can you copy the data with the server running?

Certainly can.

I do nightly on-line backups with a script that I wrote a while
back. You can safely do it if you flush tables and then obtain a read
lock on the tables.

The `mysqlhotcopy' script does something similar I think. It's
distributed with recent versions of MySQL.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

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

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: Backup?

[Scott Baker]

That's the way that I do.  I setup my server to shutdown the MySQL process 
at 3am, zip up my var directory, and then restart the process.  Can you 
copy the data with the server running?

Scott

At 04:37 PM 1/30/2001 -0800, you wrote:
>On Tue, Jan 30, 2001 at 04:39:19PM -0700, Colin Faber wrote:
> >
> > Its not recommended to just `cp' your data directory for use
> > later. You should always dump the database with mysqldump.
>
>Eh?


-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]

"Children today are tyrants. They contradict their parents, gobble their 
food, and tyrannize their teachers." - Socrates




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

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: Auto-Increment - how can I avoid repeating IDs?

[Pat Sherrill]

I would suggest developing a link (read: programmer controlled foreign key)
over columns that would have a consistent repeatable meaning.  This would
allow the developer the ability to rebuild keys and relationships with
programmer developed utilities without dependence upon the underlying file
handler or database.

Just my opinion...

Pat...
[EMAIL PROTECTED]

BTW I believe you would need to roll your own auto increment to accomplish
your desire.


- Original Message -
From: "Viken Nokhoudian" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 3:57 PM
Subject: Auto-Increment - how can I avoid repeating IDs?


> I am using MySQL ver. 3.22.32
>
> When a table has an auto-incrementing ID field and the last inserted
> record had an ID of, say, 100, then I delete that record, the database
> engine will re-use the 100 value. How can I get the engine to never
> repeat an ID value to avoid corrupted data correlations?
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Backup?

[Jeremy D. Zawodny]

On Tue, Jan 30, 2001 at 04:39:19PM -0700, Colin Faber wrote:
>
> Its not recommended to just `cp' your data directory for use
> later. You should always dump the database with mysqldump.

Eh?

If you know what you're doing, there's nothing unsafe about it and it
is WAY faster than using mysqldump.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

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

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 tutorials/examples of ways of accessing mysql via apache.

[MacDonell, Dennis]

Hi,

I've been struggling over the last couple of weeks to setup
perl/DBI/apache/mysql/php and have finally accomplished that part of the
task. The task now is to setup databases and access the data via active
server pages either in java or php. 

I don't have a good feel for html, but I understand the basics. 

I was wondering if someone out there had some simple scripts/examples that
could take me through the basics of accessing a database located on a unix
machine from PC's running Internet Explorer. 

First I would like to just like to get users to fill in a form and then send
the form to the server and display the results. Later I would like to be
able to insert data into the database, and allow users to recall that data.
An example would be contacts database.

Thanks for any help people are willing to give.

Dennis

##
Dennis Macdonell
Systems Administrator
AUSLIG
mail: PO Box 2, Belconnen, ACT 2617
email: [EMAIL PROTECTED]
ph:  61 2 6201 4326
fax: 61 2 6201 4377
##


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

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

Re: 'USE_RAID' in mysql-3.22.32?

[Brian Reichert]

On Mon, Jan 29, 2001 at 11:48:29PM +0100, Tonu Samuel wrote:
> On Mon, 29 Jan 2001, Brian Reichert wrote:
> 
> > In pawing though the source for mysql-3.22.32 (our current version
> > in production), I noticed in acconfig.h, a macro 'USE_RAID', which
> > in term seems to set up the use of .
> > 
> > But, I can't find any documentation for this, and the configure
> > program doesn't seem to set it one way or another.
> > 
> > What is the state of that code?  For that version of MySQL, it it
> > useful/meaningful to activate it, if I intend to make use of a RAID
> > array?
> 
> This is impossible. RAID was introduced in 3.23.x series. Also
> documentation have evreything about it.

'Impossible'?

Just now, I can grab:

  

And, in that tarball, on line 190 of acconfig.h:

  /* Use MySQL RAID */
  #undef USE_RAID

And there is a include/raid.h.

And, Docs/mysqld_error.txt has this message defined:

  #define ER_NO_RAID_COMPILED 1174
  "This version of MySQL is not compiled with RAID support",

There is no 'RAID' attribute to the 'CREATE TABLE' syntax in the
supplied docs.

My question was:

> What is the state of that code?

I _surmise_ that it's unused code, as it was not fully implemented
at this point.  I was uncertain if it was code that specific to
the yet-to-be-introcuded RIAD attributes to a table, or if it just
messed with the layout of files on disk to allow for better
performance in general on RAID arrays.

I merely wanted verification.

> 
> Tonu
> 

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

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

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

Re: MySQL Tables over Multiple Drives

[Brian Reichert]

On Tue, Jan 30, 2001 at 06:51:01AM -0500, Jason Frisvold wrote:
> Well, there are a few reasons..  We have a system with 4 8G drives..  If we
> use one for root and one to mirror that root, we have 2 drives left.
> Now, if we raid those 2 remaining drives (RAID5) we get about 12 Gigs of space
> available...

I'm confused; what does RAID5 on just two drives get you?  One
drive, and you're still dead.  I would have thought that (in this
case) just striping would have been the way to go...

> ---
> Jason H. Frisvold
> Senior ATM Engineer
> Engineering Dept.
> Penteledata
> CCNA Certified - CSCO10151622
> [EMAIL PROTECTED]
> ---
> "I love deadlines. I especially like the whooshing sound they make as they
> go flying by." -- Douglas Adams

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

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

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

Re: How to select the 10 last items from a table?

[Remco van den Berg]

On Wed, Jan 31, 2001 at 02:02:05AM +0300, Rus wrote:
> He need 10 last records ordered by id.
> 
> You also can try this
> SELECT  *,count(*) as c FROM item GROUP BY ID LIMIT c-10,10

mysql> select *,count(*) as c from lid group by id limit c-10,10;
ERROR 1064: You have an error in your SQL syntax near 'c-10,10' at line 1

> or
> SELECT  *,count(*)-10 as c FROM item GROUP BY ID LIMIT c,10

mysql> select *,count(*)-10 as c from lid group by id limit c,10;
ERROR 1064: You have an error in your SQL syntax near 'c,10' at line 1

Nope

Still no one-query-solution

-Remco

-- 

Remco van den Berg   Admin/SO/helpdesk DSE  
  ICQ: 47514668 [EMAIL PROTECTED] http://www.dse.nl/   


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

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

RE: Connectivity to MySQL DB

[Quentin Bennett]

Hi,

You don't need a special process - the MySQL ODBC driver talks directly to
the mysqld already running on Solaris.

Regards

Quentin

-Original Message-
From: Sanjeev Kabra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 31 January 2001 11:58
To: [EMAIL PROTECTED]
Subject: Connectivity to MySQL DB


Hi Everybody,

I have installed MySQL on Solaris and have even setup the connectivity
using MyODBC on windows. I would like to know what I have to execute on
Solaris like listener process for Oracle so that when I connect from
windows environment I can connect to the database running on Solaris.

Thanks in advance.

Sanjeev.

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

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

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: Auto-Increment - how can I avoid repeating IDs?

[Viken Nokhoudian]

Rus wrote:
> 
> That's strange. I thought that auto_increment field not suppose to use same
> value. May be it's problem connected with transaction. Check doc's on
> COMMIT. Try to set AUTOCOMMIT=1

It's real.  Here is a demonstration. First, the table definition...

+-+--+--+-+-++
| Field   | Type | Null | Key | Default | Extra  |
+-+--+--+-+-++
| vik_ID  | int(10) unsigned |  | PRI | 0   | auto_increment |
| vikname | varchar(255) |  | | ||
+-+--+--+-+-++

And here is a demonstration of the behavior.  It is pretty weird:


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 3.22.32

Type 'help' for help.

mysql> select * from Vik;
++-+
| vik_ID | vikname |
++-+
|  1 | Da man  |
|  2 | Da sow  |
++-+
2 rows in set (0.01 sec)

mysql> delete from Vik where vik_ID=2;
Query OK, 1 row affected (0.00 sec)

mysql> select * from Vik;
++-+
| vik_ID | vikname |
++-+
|  1 | Da man  |
++-+
1 row in set (0.00 sec)

mysql> insert into Vik (vikname) VALUES ('George');
Query OK, 1 row affected (0.00 sec)

mysql> select * from Vik;
++-+
| vik_ID | vikname |
++-+
|  1 | Da man  |
|  2 | George  |
++-+
2 rows in set (0.00 sec)

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: Backup?

[Steve Ruby]

James Ervin wrote:
> 
> Can you restore from a backup of the mysql data directory or do you need to
> dump the database in order to be able to restore?  I have seen some traffic
> on the list that suggests that a dump is the way to go.  I backup the data
> directory each night, but I would hate to find out that that is not the way
> to go if/when things go bad.
> 
> James Ervin


Restore from a copy of the directory is the fastest way to recover
(short
of replication).  Just make sure that when you copy the files you
do some intellegent copying.

shutdown the server before copying
OR
use mysqlhotcopy
OR
write your own scheme to lock the flush and lock the tabkes you need
before
copying.

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

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: Backup?

[Colin Faber]

Its not recommended to just `cp' your data directory for use later. You should
always dump the database with mysqldump.


James Ervin wrote:

> Can you restore from a backup of the mysql data directory or do you need to
> dump the database in order to be able to restore?  I have seen some traffic
> on the list that suggests that a dump is the way to go.  I backup the data
> directory each night, but I would hate to find out that that is not the way
> to go if/when things go bad.
>
> James Ervin
> City of Bedford Network Administration
> [EMAIL PROTECTED]
> Office: (540)587-6040
> Cell: (540)875-7526
> Pager: (540)296-0231
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: How to select the 10 last items from a table?

[Remco van den Berg]

On Tue, Jan 30, 2001 at 11:48:22PM +0300, Rus wrote:
> May be it could work
> SELECT  * FROM item ORDER BY ID LIMIT count(*)-10,10

mysql> SELECT  id FROM lid ORDER BY ID LIMIT count(*)-10,10;
ERROR 1064: You have an error in your SQL syntax near 'count(*)-10,10' at line 1

> or
> SELECT  * FROM SELECT  * FROM item ORDER BY ID DESC LIMIT 10 ORDER BY ID

mysql> select * from select * from lid order by id DESC limit 10 order by id;
ERROR 1064: You have an error in your SQL syntax near 'select * from lid order by id 
DESC limit 10 order by id' at line 1


I think you have to make use of at least two queries. One to get MAX(id) and
one for the actual query:

mysql> select MAX(id) from lid;
+-+
| MAX(id) |
+-+
| 489 |
+-+
1 row in set (0.00 sec)
mysql> select id from lid order by id limit 479,10;

But that only works when all id's up to the last one exist.
If you delete records from the table calculating 479 by substracting 10 
from MAX(id) doesn't work.

So, the only solution left, I can think of, is to make use of an temporary
table (in memory) to store the results of your query which are in the wrong
order. And then query the temporary table to get right order.

-Remco

-- 

Remco van den Berg   Admin/SO/helpdesk DSE  
  ICQ: 47514668 [EMAIL PROTECTED] http://www.dse.nl/   


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

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

Re: Insert Problem

[Toby Miller]

My bad, not enough sleep I guess.

Thanks,
Toby

- Original Message -
From: "Roger Ramirez" <[EMAIL PROTECTED]>
To: "Toby Miller" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 6:33 AM
Subject: Re: Insert Problem


> Hmmm I don't believe you can have a where in an insert statement.  You
> either do or you don't.  Perhaps you are thinking of update?
>
> - Original Message -
> From: "Toby Miller" <[EMAIL PROTECTED]>
> To: "Liste mysql" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 30, 2001 6:28 AM
> Subject: Insert Problem
>
>
> I have a record being inserted and I don't see what the problem is. This
is
> the insert statement:
>
> insert into auth_users (username, password, firstname, lastname, address1,
> address2, city, state, zip, phone, fax, email, hint) values ("username",
> "password", "firstname", "lastname", "Address1", "", "City", "ST",
"12345",
> "444-555-", "", "[EMAIL PROTECTED]", "password hint") where username =
> "username" and password = "cd6c8f619fe02d9ea5d283cea1dfdefc"
>
> Here is the error that I am getting:
>
> You have an error in your SQL syntax near 'where username = "tobymiller"
and
> password = "cd6c8f619fe02d9ea5d283cea1dfdefc"' at line 1
>
> I am using a MD5 encrypted string for the password, that's what that is.
>
> Here is the table that this record is being inserted into:
>
> CREATE TABLE auth_users (
>username varchar(20) NOT NULL,
>password varchar(120) NOT NULL,
>firstname varchar(36) NOT NULL,
>lastname varchar(36) NOT NULL,
>address1 varchar(60),
>address2 varchar(60),
>city varchar(60),
>state char(2),
>zip varchar(10),
>phone varchar(12),
>fax varchar(12),
>email varchar(120) NOT NULL,
>hint varchar(120),
>ipaddress varchar(15),
>hash varchar(120),
>created timestamp(14),
>createdby varchar(20) DEFAULT 'byhand' NOT NULL,
>loggedin timestamp(14),
>UNIQUE username (username)
> );
>
>
> Any ideas?
>
> Thanks,
> Toby
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

HYPERLINK type column conversion to ???

[Apolinaras 'Apollo' Sinkevicius]

What should I convert Access97 HYPERLINK column type to in MySQL? How do I 
get Access97 form to look at that new converted column same way as with 
native column.
Any suggestions? Everyone in the office was pretty used to clicking on the 
link to the file in the form, but now I am not able to do this since 
conversion.

Apollo 



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

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: Auto-Increment - how can I avoid repeating IDs?

[René Tegel]

The most lovely feature of auto_increment is one of the reasons why we
switched from interbase to mysql. Instead of having to call a stored
procedure every time you need a unique id, or obtain one by triggers, or
create a semi-unique one the way you do, one just have a flexible and
controlable unique id function :)
So i strongly disagree the unwantedness of auto_increment. at least: you
dont have to use it if you don't like to, as you proved by a simple client
side function.


- Original Message -
From: "Roger Ramirez" <[EMAIL PROTECTED]>
To: "Viken Nokhoudian" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 11:07 PM
Subject: RE: Auto-Increment - how can I avoid repeating IDs?


> Use your own id's.  I personally hate auto increment.  I do all my work in
> php so I make my id's like this.
>
> srand(time());
> $id = md5(uniqid(rand()));
>
> This will make a 32 character id.
>
> > -Original Message-
> > From: Viken Nokhoudian [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 30, 2001 3:58 PM
> > To: [EMAIL PROTECTED]
> > Subject: Auto-Increment - how can I avoid repeating IDs?
> >
> >
> > I am using MySQL ver. 3.22.32
> >
> > When a table has an auto-incrementing ID field and the last inserted
> > record had an ID of, say, 100, then I delete that record, the database
> > engine will re-use the 100 value. How can I get the engine to never
> > repeat an ID value to avoid corrupted data correlations?
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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: Auto-Increment - how can I avoid repeating IDs?

[hooker]

> 
> I am using MySQL ver. 3.22.32
> 
> When a table has an auto-incrementing ID field and the last inserted
> record had an ID of, say, 100, then I delete that record, the database
> engine will re-use the 100 value. How can I get the engine to never
> repeat an ID value to avoid corrupted data correlations?

I get round a very similar problem by having a validity marker in each
record :

valid   tinyint default 1,

Instead of deleting records, set the marker to zero and once a day (more
often if you get heavy traffic in the table) tidy the table by deleting
all invalid records except for the one with the highest auto_increment
field.  A bit messy, but it does work.


The Hooker
--
"I've had a perfectly wonderful evening, but this wasn't it"

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

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

Connectivity to MySQL DB

[Sanjeev Kabra]

Hi Everybody,

I have installed MySQL on Solaris and have even setup the connectivity using MyODBC on 
windows. I would like to know what I have to execute on Solaris like listener process 
for Oracle so that when I connect from windows environment I can connect to the 
database running on Solaris.

Thanks in advance.

Sanjeev.

Re: How to select the 10 last items from a table?

[Rus]

He need 10 last records ordered by id.

You also can try this
SELECT  *,count(*) as c FROM item GROUP BY ID LIMIT c-10,10
or
SELECT  *,count(*)-10 as c FROM item GROUP BY ID LIMIT c,10

Something should work

- Original Message -
From: Scott Gerhardt <[EMAIL PROTECTED]>
To: Rus <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 12:40 AM
Subject: RE: How to select the 10 last items from a table?


> SELECT * FROM item
> ORDER BY ID
> LIMIT 10
>
> or change to "ORDER BY ID DESC" to get the desired result.
>
> - Scott
>
> > May be it could work
> > SELECT  * FROM item ORDER BY ID LIMIT count(*)-10,10
> > or
> > SELECT  * FROM SELECT  * FROM item ORDER BY ID DESC LIMIT 10 ORDER BY ID
> >
> >
> >
> >
> > - Original Message -
> > From: Karlsson Andreas-andkar01 <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, January 30, 2001 6:00 PM
> > Subject: How to select the 10 last items from a table?
> >
> >
> > Hi,
> > I have a table were all rows have their own ID. How can I select only
the
> > last items out of this table?
> > This command fixes it but I receive the items in the wrong order that I
> > would like them...
> > SELECT * FROM item ORDER BY ID DESC LIMIT 10
> > brgds
> > Andreas
> >
> > Andreas Karlsson
> > MAGNET- Motorola Applications Global Network
> > Campus Gräsvik 2
> > 371 75 Karlskrona
> > Phone: +46-455-379 306
> > E-mail:[EMAIL PROTECTED]
> > 
> > Become a MAGNET member - register at:
> > http://www.motorola.com/developers/wireless/
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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

Backup?

[James Ervin]

Can you restore from a backup of the mysql data directory or do you need to 
dump the database in order to be able to restore?  I have seen some traffic 
on the list that suggests that a dump is the way to go.  I backup the data 
directory each night, but I would hate to find out that that is not the way 
to go if/when things go bad.



James Ervin
City of Bedford Network Administration
[EMAIL PROTECTED]
Office: (540)587-6040
Cell: (540)875-7526
Pager: (540)296-0231


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

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: Auto-Increment - how can I avoid repeating IDs?

[Rus]

That's strange. I thought that auto_increment field not suppose to use same
value. May be it's problem connected with transaction. Check doc's on
COMMIT. Try to set AUTOCOMMIT=1

- Original Message -
From: Viken Nokhoudian <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 11:57 PM
Subject: Auto-Increment - how can I avoid repeating IDs?


> I am using MySQL ver. 3.22.32
>
> When a table has an auto-incrementing ID field and the last inserted
> record had an ID of, say, 100, then I delete that record, the database
> engine will re-use the 100 value. How can I get the engine to never
> repeat an ID value to avoid corrupted data correlations?
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

_slow_ index generation

[Sheer El-Showk]

Please cc [EMAIL PROTECTED] on any response, I'm on the list but I filter to
a file, thanks.

Can someone (maybe with some MySQL-innards code experience) please explain 
this problem:

Generating an index on the first character of a varchar(70) on a 350 meg
table on a PII 366 128 MB Ram, normal IDE disk takes over 17000 seconds
(ie it never even finished but the process took that much time in "show
processlist" before I finally killed it).  And the server was not hung in
any way ... in fact I watched it generate a ~550Mb temporary table in the
MySQL data dir (filename began with a hash #sql).  In fact the system's
resources, disk access aside, weren't even being strained ... ~8% memory,
3-4% CPU.

Obviously the limiting factor was disk access which was slowing everything
down.  So here are the questions:

(1) Why does mysql do this all of this on disk -- the table (~300 MB) may
well have required more than physical memory, but the first character of
each varchar and the associated file offset of the record would only be a
fraction of that space (and isn't that all you need to create an index
... just pull out the values and the offsets and sort them and then store
in an index file).

(2) Even if the whole table needed to be manipulated and done on disk
(seems like a really poor idea) why is a temporary table much larger than
the original table being generated.

(3) Are there configuration options to somehow make MySQL behave more
intelligently than this, because this is really impractical -- 300 MB
isn't really large -- I know this system may seem like a low-end system 
but its just my laptop.  On our production system this takes less time,
but still much to long.

I'm not a database engineer, in fact I'm very new to databases, and I
don't mean to sound hostile (I know I may come off that way), but I'm just
a little suprised.  I'm guessing there is a way around this behaviour
(MySQL is usually used with large DB's ... I can't imagine this would have
been ignored), but I am a little suprised that the default configuration
is _so_ badly tuned to large databases.

I would appreciate any help and explanations (for my own benefaction,
in fact the more you are willing to explain and DB's and their innards 
the happier I'd be) -- the more detailed the better.

Thanks in advance,
Sheer


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

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: Auto-Increment - how can I avoid repeating IDs?

[Alexander Skwar]

So sprach Viken Nokhoudian am Tue, Jan 30, 2001 at 12:57:50PM -0800:
> When a table has an auto-incrementing ID field and the last inserted
> record had an ID of, say, 100, then I delete that record, the database
> engine will re-use the 100 value. How can I get the engine to never
> repeat an ID value to avoid corrupted data correlations?

Huh??  This does not happen here with mysql .31!

mysql> describe TEST;
+---++--+-+-++-+
| Field | Type   | Null | Key | Default | Extra  | Privileges  
||
+---++--+-+-++-+
| ID| tinyint(4) |  | PRI | NULL| auto_increment | 
|select,insert,update,references |
| Value | tinyint(4) |  | | 0   || 
|select,insert,update,references |
+---++--+-+-++-+

mysql> insert into TEST (Value) values (1);
Query OK, 1 row affected (0.00 sec)

mysql> select * from TEST;
++---+
| ID | Value |
++---+
|  1 | 1 |
++---+
1 row in set (0.00 sec)

mysql> delete from TEST where Value='1';
Query OK, 1 row affected (0.00 sec)

mysql> insert into TEST (Value) values (2);
Query OK, 1 row affected (0.00 sec)

mysql> select * from TEST;
++---+
| ID | Value |
++---+
|  2 | 2 |
++---+
1 row in set (0.00 sec)

Alexander Skwar
-- 
How to quote:   http://learn.to/quote (german) http://quote.6x.to (english)
Homepage:   http://www.digitalprojects.com   |   http://www.iso-top.de
   iso-top.de - Die guenstige Art an Linux Distributionen zu kommen
Uptime: 2 hours 38 minutes

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

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

normal cpu usage

[Alejandro M. Leonian]

Hi guys..would you be so kind to tell me what's the normal % of cpu usage per mysqld 
thread?
i get some 10.5 or 12 % peaks, which frighten me a lil' bit.
Thanks!


AML

Re: Auto-Increment - how can I avoid repeating IDs?

[Angela]

Easiest way, upgrade to 3.23:)
Other way: create a table just to make auto_increment IDs and take the
number from it each time to put in your original table.


Viken Nokhoudian wrote:
> 
> I am using MySQL ver. 3.22.32
> 
> When a table has an auto-incrementing ID field and the last inserted
> record had an ID of, say, 100, then I delete that record, the database
> engine will re-use the 100 value. How can I get the engine to never
> repeat an ID value to avoid corrupted data correlations?
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Angela Curtis
Innovative Business Consultants
http://www.ibc2001.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 Tables over Multiple Drives

[Tim Bunce]

On Tue, Jan 30, 2001 at 01:13:43PM -0800, Jeremy D. Zawodny wrote:
> On Tue, Jan 30, 2001 at 05:08:46PM +, Tim Bunce wrote:
> > On Tue, Jan 30, 2001 at 10:57:16PM +0800, Sam Wong wrote:
> > > >
> > > > So why isn't the --with-raid option set in the binary download version?
> > >
> > > The file will be bigger and slower in result
> > 
> > I doubt it would be significantly bigger. I believe --with-raid
> > support is a very small and simple layer between mysqld and the file
> > i/o system calls.
> 
> At the open source database summit, I asked Monty why it wasn't
> enabled in the binaries they provide, and he said that it was for
> performance reasons. On each table open, MySQL has to see if it is a
> RAID table and do a bit of extra work.

Why not determine it by checking only if the open of the non-raid fail
failed?  That way there'd be no penalty for those not using the raid
feature.

> > I'm not sure what you mean by "slower in result".
> 
> He has estimated it as a performance hit of a "few percent", but if
> your tables stay open (because you don't have many, or you have a
> good-sized table cache) it really shouldn't be an issue.

I can't see where a "few percent" hit would come from unless tables
were being opened at the rate of many per second.  Anyone smart enough
to be using the raid feature would also know how to tune mysql to keep
the files open. Those not using the feature should see no hit.

Anyway, even if there is a hit, why not allow a runtime config option
to disable the raid feature? Checking a global in C is basically free.

> He said that MaxSQL would have many of the compile-time options
> enabled for folks who still wanted to use a binary release. But it
> doesn't appear to have materialized...

I wish it would.

Monty, can you give us an update?

Tim.

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

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: Auto-Increment - how can I avoid repeating IDs?

[Cal Evans]

Write your own Serial Assigned Key (SAK) routine.

Put a table in your database :

SAK

SAKID auto_increment tinyint

table varChar(80) not null
field varChar(80) not null
nextValue bigint
lockedBy varCar(10)


Now, each time you do an insert follow these steps:

1: Select the record from SAK for the table.field you want to use.
2: See if there is a value in lockedBy. If so, someone else is already using
it, wait or bail.  If not, then update the record with your userID or if in
PHP, your session number. basically anything that's unique to this client
and or session.
3: Select to see if the lockedBy field is what you put in it.  Just to make
sure you got the lock and not someone else.
4: select to get the value in nextValue
5: Update to increment the value by 1 and to remove the lock.

Now, it doesn't really take 5 steps to do this, you can combine 3 & 4. I
broke them out logically so you could see what is going on.

Also, if you are the *only* person using the database, all the locking stuff
is superfluous.

Hope this helps,

Cal
http://www.calevans.com


-Original Message-
From: Viken Nokhoudian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 2:58 PM
To: [EMAIL PROTECTED]
Subject: Auto-Increment - how can I avoid repeating IDs?


I am using MySQL ver. 3.22.32

When a table has an auto-incrementing ID field and the last inserted
record had an ID of, say, 100, then I delete that record, the database
engine will re-use the 100 value. How can I get the engine to never
repeat an ID value to avoid corrupted data correlations?


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

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

[REPLICATION: /var/lib/mysql/master.info corrupted during restart]

[Andrew Kornak]

>Description:

>How-To-Repeat:
<1) stop mysqld server (mysqladmin shutdown)
 2) restart server (shutdown -r now) or restart mysqld
 3) slave will be unable to connect with master as the
master.info file is corrupted.>
>Fix:


>Submitter-Id:  
>Originator:Andrew Kornak
>Organization:  RapidMedia Network, Inc.
  
 
  *
  Andrew Kornak
  RapidMedia Network
  1431 Opus Place, Suite 620
  Downers Grove, IL.  60515
  http://www.rapidmedianetwork.com
  *
>
>MySQL support: [none]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.32 (Official MySQL RPM)

>Environment:

System: Linux andrew 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 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.0)
Compilation info: CC='egcs'  CFLAGS='-O6 -fomit-frame-pointer -mpentium'  CXX='egcs'  
CXXFLAGS='-O6 -fomit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   11 Jan 24 19:52 /lib/libc.so.6 -> libc-2.2.so
-rwxr-xr-x1 root root  5155229 Jan 10 18:09 /lib/libc-2.2.so
-rw-r--r--1 root root 24498288 Jan 10 17:35 /usr/lib/libc.a
-rw-r--r--1 root root  178 Jan 10 17:35 /usr/lib/libc.so
lrwxrwxrwx1 root root   10 Nov  2 08:42 /usr/lib/libc-client.a -> 
c-client.a
Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql 
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ 
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin 
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql 
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db 
'--with-comment=Official MySQL RPM'


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

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 and Mac OS X Server

[atheory]

Look here for the OSX Server binary source:
 http://www.mysql.com/downloads/mysql-3.23.html

and read this:

"Before trying to configure *MySQL*
on Mac OS X server you must first
first install the pthread package
from `http://www.prnet.de/RegEx/mysql.html'".

Really... make *SURE* you install the pcthreads-package before the mySQL
package...

Keith James
Network Manager
FTF Inc.




on 1/30/01 10:55 AM, Doug Dockery at [EMAIL PROTECTED] wrote:

> Hello all -
> 
> I'm a new mySQL user and am interested to know if anyone has successfully
> installed mySQL in the Mac OS X Server environment - if so, is there a
> precompiled binary or install instructions for the platform?
> 
> Thanks and sorry for the newbie question.
> 
> Doug





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

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: Auto-Increment - how can I avoid repeating IDs?

[Roger Ramirez]

Use your own id's.  I personally hate auto increment.  I do all my work in
php so I make my id's like this.

srand(time());
$id = md5(uniqid(rand()));

This will make a 32 character id.

> -Original Message-
> From: Viken Nokhoudian [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 3:58 PM
> To: [EMAIL PROTECTED]
> Subject: Auto-Increment - how can I avoid repeating IDs?
>
>
> I am using MySQL ver. 3.22.32
>
> When a table has an auto-incrementing ID field and the last inserted
> record had an ID of, say, 100, then I delete that record, the database
> engine will re-use the 100 value. How can I get the engine to never
> repeat an ID value to avoid corrupted data correlations?
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Auto-Increment - how can I avoid repeating IDs?

[The Tilghman]

Upgrade to 3.23.

-- 
"There cannot be a crisis today.  My schedule is already full."
 --Henry Kissinger

> -Original Message-
> From: Viken Nokhoudian [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 14:58
> 
> I am using MySQL ver. 3.22.32
> 
> When a table has an auto-incrementing ID field and the last inserted
> record had an ID of, say, 100, then I delete that record, the database
> engine will re-use the 100 value. How can I get the engine to never
> repeat an ID value to avoid corrupted data correlations?
> 

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

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: OT: Compiling GCC

[Ron Beck]

Hi,
My first recommendation would be to download one of the GCC binaries and
use pkgadd to install the product.  Go to...

http://www.sunfreeware.com/

and select your version of Solaris (2.6) from the menu on the upper
right side of the form.  Then scroll through the lower right window
until you find the gcc version you want.  Use the pkgadd command to load
GCC.

Then, recompile mysql and make sure you specify gcc as the compiler.

Good luck,
Ron


Quentin Bennett wrote:
> 
> Hi,
> 
> In attempt to see if a core dump in mysql is the result of a broken SUN
> compiler, as suggested, I am trying to compile gcc 2.95.2 on Solaris 2.6
> x86.
> 
> I have subscribed to gnu-help, but haven't had a response from there yet. Is
> anyone out there able to help me off the list to get gcc going.
> 
> Thanks in advance.
> 
> Quentin Bennett
> Transport Systems Division
> Infinity Solutions
> Phone: + 64 9 358 9720
> Fax : + 64 9 309 4142
> mailto:[EMAIL PROTECTED]
> http://www.infinity.co.nz
> 
> The information contained in this email is privileged and confidential
> and intended for the addressee only. If you are not the intended
> recipient, you are asked to respect that confidentiality and not
> disclose, copy or make use of its contents. If received in error
> you are asked to destroy this email and contact the sender immediately.
> Your assistance is appreciated.
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> 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

Query out field names???

[Shawn Cummings]

I want to query out the field names where the "Default" is NULL ... so I 
can populate an HTML page for input...

SHOW FIELDS FROM tblNAME;

This shows the fieldnames, and the properties -- but how can I just get a 
list of the fieldnames where the Default is NULL -- or how can I get this 
list from a Perl script??


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

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: Nightly Backup of my database

[Steve Ruby]

Don wrote:
> 
> Hi list,
> 
> I'm trying to backup up database in /etc/cron.daily.  I've played with
> mysql dump with the following syntax:
> 
> mysqldump --opt -p my_dbf.db > my_dbf.backup
> mysqldump --opt -p "my_password" my_dbf.db > my_dbf.backup
> mysqldump --opt -p my_dbf.db > my_dbf.backup < pswd
> (pswd contains the password)
> 
> In each case, I still get prompted for the password.  How can I automate
> this so that is accepts the password that I include.  I guess what I am
> looking for is the proper syntax or a neat trick.
> 
> Thanks,
> Don

You must supply the password without a space between it and the -p

mysqldump --opt -u -p mydb > mydb.backup

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

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

HYPERLINK type column conversion to ???

[Apolinaras 'Apollo' Sinkevicius]

What should I convert Access97 HYPERLINK column type to in MySQL? How do I 
get Access97 form to look at that new converted column same way as with 
native column.
Any suggestions? Everyone in the office was pretty used to clicking on the 
link to the file in the form, but now I am not able to do this since 
conversion.

Apollo


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

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

RE: How to select the 10 last items from a table?

[Scott Gerhardt]

SELECT * FROM item
ORDER BY ID
LIMIT 10

or change to "ORDER BY ID DESC" to get the desired result.

- Scott

> May be it could work
> SELECT  * FROM item ORDER BY ID LIMIT count(*)-10,10
> or
> SELECT  * FROM SELECT  * FROM item ORDER BY ID DESC LIMIT 10 ORDER BY ID
>
>
>
>
> - Original Message -
> From: Karlsson Andreas-andkar01 <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, January 30, 2001 6:00 PM
> Subject: How to select the 10 last items from a table?
>
>
> Hi,
> I have a table were all rows have their own ID. How can I select only the
> last items out of this table?
> This command fixes it but I receive the items in the wrong order that I
> would like them...
> SELECT * FROM item ORDER BY ID DESC LIMIT 10
> brgds
> Andreas
>
> Andreas Karlsson
> MAGNET- Motorola Applications Global Network
> Campus Gräsvik 2
> 371 75 Karlskrona
> Phone: +46-455-379 306
> E-mail:[EMAIL PROTECTED]
> 
> Become a MAGNET member - register at:
> http://www.motorola.com/developers/wireless/
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

Load Balancing.

[Nathan Cook]

It seems like I have seen somewhere that load balancing and
fail-over-services are available for MySQL, to share the load and mirror the
data between two machines.

Is this possible and if so where can I read more about it?

Thank You,
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]


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

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 upon order by with group by and join

[Quentin Bennett]

Hi,

Yes, RTFM.

Your select result is too big for the configure tmp_table_size, and you are
not using --big-tables.

Regards

Quentin

-Original Message-
From: Chana Black [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 31 January 2001 09:13
To: [EMAIL PROTECTED]
Subject: Error upon order by with group by and join


Hi,

I am using mysql  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686).

When I try to run the following query:
select tb1.fname, tbl1.lname, tbl2.appID, count(tbl2.appID) as count from 
tbl1, tbl2 where tbl1.id = tbl2.appID group by tbl2.appID order by
tbl1.fname

I get the following error:
ERROR 1114: The table 'SQL2ae1_0' is full

Does anyone know what this means? How I can fix this?

Thanks,
Chana Black


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

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

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

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

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: Nightly Backup of my database

[Quentin Bennett]

Hi,

Try taking the space out from "-p passwd"

Regards
Quentin

-Original Message-
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 31 January 2001 09:45
To: msql list
Subject: Nightly Backup of my database


Hi list,

I'm trying to backup up database in /etc/cron.daily.  I've played with
mysql dump with the following syntax:

mysqldump --opt -p my_dbf.db > my_dbf.backup
mysqldump --opt -p "my_password" my_dbf.db > my_dbf.backup
mysqldump --opt -p my_dbf.db > my_dbf.backup < pswd
(pswd contains the password)

In each case, I still get prompted for the password.  How can I automate
this so that is accepts the password that I include.  I guess what I am
looking for is the proper syntax or a neat trick.

Thanks,
Don



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

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

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

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

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: Nightly Backup of my database

[Laszlo G. Szijarto]

Hi,
Well, there's one easy way to do it, but it compromises security just a
little bit.

mysqldump --opt -u'username' -p'userspassword' my_dbf.db > my_dbf.backup

One way to minimize security risks would be to create a user with minimal
capabilities to do backups -- only given these limited permissions and only
on localhost or from the backup server if not the same as the db server.  Or
you can try some fancy programming -- say, by writing a PERL script, that
runs an encryption routine on the password first.  And make sure to restrict
ownership of your cron files.




- Original Message -
From: "Don" <[EMAIL PROTECTED]>
To: "msql list" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 3:45 PM
Subject: Nightly Backup of my database


> Hi list,
>
> I'm trying to backup up database in /etc/cron.daily.  I've played with
> mysql dump with the following syntax:
>
> mysqldump --opt -p my_dbf.db > my_dbf.backup
> mysqldump --opt -p "my_password" my_dbf.db > my_dbf.backup
> mysqldump --opt -p my_dbf.db > my_dbf.backup < pswd
> (pswd contains the password)
>
> In each case, I still get prompted for the password.  How can I automate
> this so that is accepts the password that I include.  I guess what I am
> looking for is the proper syntax or a neat trick.
>
> Thanks,
> Don
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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 Tables over Multiple Drives

[Jeremy D. Zawodny]

On Tue, Jan 30, 2001 at 05:08:46PM +, Tim Bunce wrote:
> On Tue, Jan 30, 2001 at 10:57:16PM +0800, Sam Wong wrote:
> > > So why isn't the --with-raid option set in the binary download version?
> >
> > The file will be bigger and slower in result
> 
> I doubt it would be significantly bigger. I believe --with-raid
> support is a very small and simple layer between mysqld and the file
> i/o system calls.

At the open source database summit, I asked Monty why it wasn't
enabled in the binaries they provide, and he said that it was for
performance reasons. On each table open, MySQL has to see if it is a
RAID table and do a bit of extra work.

> I'm not sure what you mean by "slower in result".

He has estimated it as a performance hit of a "few percent", but if
your tables stay open (because you don't have many, or you have a
good-sized table cache) it really shouldn't be an issue.

He said that MaxSQL would have many of the compile-time options
enabled for folks who still wanted to use a binary release. But it
doesn't appear to have materialized...

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

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

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

Auto-Increment - how can I avoid repeating IDs?

[Viken Nokhoudian]

I am using MySQL ver. 3.22.32

When a table has an auto-incrementing ID field and the last inserted
record had an ID of, say, 100, then I delete that record, the database
engine will re-use the 100 value. How can I get the engine to never
repeat an ID value to avoid corrupted data correlations?


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

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 1170: BLOB column 'Url' used in key specification without a key length

[Mark Maggelet]

On Tue, 30 Jan 2001 10:04:47 -0800, [EMAIL PROTECTED]
([EMAIL PROTECTED]) wrote:
>This underscores a problem I have found with a few asp-driven
>college
>websites. Ungodly long URLs are used to address some of their pages.
>When I have inquired about this, and how to tell a friend where to
>find particular information, I was simply informed that this was a
>characterisitic of the system they used. I am using URL fields, but
>in a few instances, I have had to look for a page with a shorter
>address to enter. This is not just a mysql problem; the schools with
>systems like this need to address the business down-side of the
>difficulty in doing a referral.

Just copy & paste the url into an email. What's so hard about that?


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

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

Re: How to select the 10 last items from a table?

[Rus]

May be it could work
SELECT  * FROM item ORDER BY ID LIMIT count(*)-10,10
or
SELECT  * FROM SELECT  * FROM item ORDER BY ID DESC LIMIT 10 ORDER BY ID




- Original Message -
From: Karlsson Andreas-andkar01 <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 6:00 PM
Subject: How to select the 10 last items from a table?


Hi,
I have a table were all rows have their own ID. How can I select only the
last items out of this table?
This command fixes it but I receive the items in the wrong order that I
would like them...
SELECT * FROM item ORDER BY ID DESC LIMIT 10
brgds
Andreas

Andreas Karlsson
MAGNET- Motorola Applications Global Network
Campus Gräsvik 2
371 75 Karlskrona
Phone: +46-455-379 306
E-mail:[EMAIL PROTECTED]

Become a MAGNET member - register at:
http://www.motorola.com/developers/wireless/

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

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

Nightly Backup of my database

[Don]

Hi list,

I'm trying to backup up database in /etc/cron.daily.  I've played with
mysql dump with the following syntax:

mysqldump --opt -p my_dbf.db > my_dbf.backup
mysqldump --opt -p "my_password" my_dbf.db > my_dbf.backup
mysqldump --opt -p my_dbf.db > my_dbf.backup < pswd
(pswd contains the password)

In each case, I still get prompted for the password.  How can I automate
this so that is accepts the password that I include.  I guess what I am
looking for is the proper syntax or a neat trick.

Thanks,
Don



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

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: (Got an error reading communication packets)

[Maciek Uhlig]

> -Original Message-
> From: Matis, Jan [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 9:02 PM
> To: [EMAIL PROTECTED]
> Subject: (Got an error reading communication packets)

> do You have an idea why ?

yes...

>
>
> I was searching on deja but I didn't found anything :(

How did you do it? It's almost impossible...

Go to http://www.deja.com/home_ps.shtml and in the 'enter keywords' field
type 'error reading communication packets'. Then click 'search'. You'll get
about 300 articles on the subject, some with the answer for your question...

Maciek


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

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

Install of mysql on AIX fails due to missing member shr.o in module libz.a

[NELSON, GLEN]

From: t199k01
To: [EMAIL PROTECTED]
Subject: Install of mysql on AIX fails due to missing member shr.o in module
libz.a
>Description:
Previously, I was failing because module libz.a didn't exist. Per your
advice,
I installed zlib from gnu. Now, the module appears to be found, but it
cannot
locate member shr.o. The following is the screen output of the installation:

Executing /fmcusr/shared/kshrc ...
exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the
following errors:
0509-150   Dependent module /usr/local/lib/libz.a(shr.o) could not
be loaded.
0509-152   Member shr.o is not found in archive
WARNING: The host 'ddcux6' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL deamon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
exec(): 0509-036 Cannot load program ./bin/mysqld because of the following
errors:
0509-150   Dependent module /usr/local/lib/libz.a(shr.o) could not
be loaded.
0509-152   Member shr.o is not found in archive
Installation of grant tables failed!

>How-To-Repeat:
run mysql_install_db
>Fix:
 unknown
>Submitter-Id:[EMAIL PROTECTED]
>Originator:Glen Nelson
>Organization:
 FMC Corporation
>MySQL support: none
>Synopsis: Install of mysql on AIX fails due to missing member shr.o
>Severity:non-critical
>Priority:medium
>Category:mysql
>Class:sw-bug
>Release:mysql-3.23.31 (Official MySQL binary)

>Environment:

System: AIX ddcux6 3 4 000D36AD4C00
AIX version 4.3.3.0

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

Compilation info: CC='gcc'  CFLAGS='-O3 -mcpu=powerpc -Wa,-many
-fomit-frame-pointer'  CXX='c++'  CXXFLAGS='-O3 -mcpu=powerpc -Wa,-many
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx   1 bin  bin   19 Sep 14 17:04 /lib/libc.a ->
/usr/ccs/lib/libc.a
lrwxrwxrwx   1 bin  bin   19 Sep 14 17:04 /usr/lib/libc.a ->
/usr/ccs/lib/libc.a
Configure command: ./configure  --prefix=/usr/local/mysql
'--with-comment=Official MySQL binary' --with-extra-charsets=complex
--disable-shared
Perl: This is perl, version 5.005_03 built for aix 

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

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

Error upon order by with group by and join

[Chana Black]

Hi,

I am using mysql  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686).

When I try to run the following query:
select tb1.fname, tbl1.lname, tbl2.appID, count(tbl2.appID) as count from 
tbl1, tbl2 where tbl1.id = tbl2.appID group by tbl2.appID order by tbl1.fname

I get the following error:
ERROR 1114: The table 'SQL2ae1_0' is full

Does anyone know what this means? How I can fix this?

Thanks,
Chana Black


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

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: idle CPU

[Vivek Khera]

> "TS" == Tim Samshuijzen <[EMAIL PROTECTED]> writes:

TS> We're running a large database on a dedicated server.
TS> When I look in the list of active processes, I notice that a 
TS> complicated query takes up no more than about 30 % of CPU. 
TS> During this time the CPU is more than 60 % idle. 
TS> Is there some way to speed up the process? 

Make your disks infinitely fast.  Then the CPU will be your bottleneck
rather than your disks.

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

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

(Got an error reading communication packets)

[Matis, Jan]

010130 20:58:30  Aborted connection 7 to db: 'dpanews' user: 'newsfeed'
host: `web1.somewhere.de' (Got an error reading communication packets)

hallo gentlemans .. I have a lot of this type messages in my mysql errorlog
file ...
do You have an idea why ? 


I was searching on deja but I didn't found anything :(


Jan 

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

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

one error when I run the Mysql++ sample

[Hensen Yi]

I got a error when  I run the sample file of Mysql++ , the file is
simple1.cc
I compile use below command:

g++ -g  -o mysimple simple1.cc  /usr/lib/libsqlplus.so -L/usr/lib/mysql
-I/usr/include/mysql/ -lmysqlclient -lnsl -lz -crypt -lsocket -lm

and I did not got any erro in compile and link, however when I run
mysimple I got error:

Error: Can't connect to local MySQL server through socket
'/temp/mysql.sock'(111).

So could you help to slove my problem? Thank you very much

Hensen



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

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

OT: Compiling GCC

[Quentin Bennett]

Hi,

In attempt to see if a core dump in mysql is the result of a broken SUN
compiler, as suggested, I am trying to compile gcc 2.95.2 on Solaris 2.6
x86.

I have subscribed to gnu-help, but haven't had a response from there yet. Is
anyone out there able to help me off the list to get gcc going.

Thanks in advance.

Quentin Bennett
Transport Systems Division
Infinity Solutions
Phone: + 64 9 358 9720
Fax : + 64 9 309 4142
mailto:[EMAIL PROTECTED]
http://www.infinity.co.nz


The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

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

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

wait_timeout?

[Meyer, Patrick]

I am slowly gaining connections to the database that just sleep.  I know
these can arise from not closing the database.  I am accessing it via MyODBC
from Active Server Pages.  However, I set wait_timeout to 3600... I have
some that have been there for days... just sleeping.  Why doesn't MySQL
disconnect them from the timeout?  Maybe I just don't understand
wait_timeout.

Help appreciated.

[EMAIL PROTECTED]
National Aeronautics and Space Administration

-- S c i e n c e  @  N A S A --
http://science.nasa.gov/ INFORM - the fast paced expansion of knowledge
http://kids.msfc.nasa.gov/ INSPIRE - the future belongs to our children
http://liftoff.msfc.nasa.gov/ INVOLVE - today's dreams, tomorrow's reality.


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

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 1170: BLOB column 'Url' used in key specification without a key length

[John Jensen]

This underscores a problem I have found with a few asp-driven college 
websites. Ungodly long URLs are used to address some of their pages. 
When I have inquired about this, and how to tell a friend where to 
find particular information, I was simply informed that this was a 
characterisitic of the system they used. I am using URL fields, but 
in a few instances, I have had to look for a page with a shorter 
address to enter. This is not just a mysql problem; the schools with 
systems like this need to address the business down-side of the 
difficulty in doing a referral. 

On 29 Jan 2001, at 22:07, Jeremy D. Zawodny wrote:

> I have no idea what this error is trying to tell me...
> 
> I have a table called "Headlines" which contains a VARCHAR(255) field
> called "Url". I need to store larger values in the "Url" column, so I
> want to convert it to TINYTEXT.
> 
> ---snip---
> 
> mysql> alter table Headlines modify Url TINYTEXT NOT NULL;
> 
> ERROR 1170: BLOB column 'Url' used in key specification without a key
> length
> 
> ---snip---
> 
> There is currently a unique index on the Url column. The manual states
> that one can have an index on a BLOB column:
> 
> http://www.mysql.com/doc/B/L/BLOB.html
> 
> So I don't see the problem.
> 
> A search of the mail archives has turned up nothing. A search of
> google also turned up nothing helpful.
> 
> Any ideas?
> 
> This is MySQL 3.23.29.
> 
> Jeremy
> -- 
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878Fax: (408) 530-5454
> Cell: (408) 439-9951
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


John Jensen
520 Goshawk Court
Bakersfield, CA 93309

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

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

Win mysqlc client anomaly

[Mark Chalkley]

Does anyone know why the Windows version of mysqlc (the command line client with 
READLINE support) doesn't support the SOURCE command?

Thanks,

Mark Chalkley


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

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: Mysqld eats up RAM and CPU

[Matis, Jan]

You've got 1G Ram!
Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which
folder)

it's not for me :)) it's for customers and because I'm lamer sometimes is
1GB not enough ...

huge.cnf - thanx for hint : mysql-3.23.32/support-files/my-huge.cnf.sh

look at these ... Do You have any other ideas how to improve speet of my
machine ?


Jan




there is #free
 total   used   free sharedbuffers cached
Mem:   1036004 396204 639800  16396  84032 277300
-/+ buffers/cache:  348721001132
Swap:   123900  0 123900


#dmesg
2k available (1352k kernel code, 424k reserved, 10732k data, 64k init)
Dentry hash table entries: 131072 (order 8, 1024k)
Buffer cache hash table entries: 524288 (order 9, 2048k)
Page cache hash table entries: 262144 (order 8, 1024k)
VFS: Diskquotas version dquot_6.4.0 initialized
Pentium-III serial number disabled.
Checking 386/387 coupling... OK, FPU using exception 16 error reporting.
Checking 'hlt' instruction... OK.
POSIX conformance testing by UNIFIX
mtrr: v1.35a (19990819) Richard Gooch ([EMAIL PROTECTED])
Pentium-III serial number disabled.
per-CPU timeslice cutoff: 99.97 usecs.
CPU1: Intel Pentium III (Katmai) stepping 03
calibrating APIC timer ... 
. CPU clock speed is 549.0806 MHz.
. system bus clock speed is 99.8328 MHz.
Booting processor 0 eip 2000
Calibrating delay loop... 1097.73 BogoMIPS
Pentium-III serial number disabled.
OK.
CPU0: Intel Pentium III (Katmai) stepping 03
Total of 2 processors activated (2192.18 BogoMIPS).
enabling symmetric IO mode... ...done.
ENABLING IO-APIC IRQs
init IO_APIC IRQs
 IO-APIC (apicid-pin) 2-0, 2-5, 2-10, 2-15, 2-16, 2-20, 2-21, 2-22, 2-23 not
connected.
..MP-BIOS bug: 8254 timer not connected to IO-APIC
...trying to set up timer as ExtINT... .. (found pin 0) ... works.
number of MP IRQ sources: 17.
number of IO-APIC #2 registers: 24.
testing the IO APIC...

IO APIC #2..
 register #00: 0200
...: physical APIC id: 02
 register #01: 00170011
... : max redirection entries: 0017
... : IO APIC version: 0011
 register #02: 
... : arbitration: 00
 IRQ redirection table:
 NR Log Phy Mask Trig IRR Pol Stat Dest Deli Vect:   
 00 001 01  000   0   00751
 01 000 00  000   0   01159
 02 000 00  000   0   01151
 03 000 00  000   0   01161
 04 000 00  000   0   01169
 05 000 00  100   0   00000
 06 000 00  000   0   01171
 07 000 00  000   0   01179
 08 000 00  000   0   01181
 09 000 00  000   0   01189
 0a 000 00  100   0   00000
 0b 000 00  000   0   01191
 0c 000 00  000   0   01199
 0d 000 00  100   0   00000
 0e 000 00  000   0   011A1
 0f 000 00  100   0   00000
 10 000 00  100   0   00000
 11 0FF 0F  110   1   011A9
 12 0FF 0F  110   1   011B1
 13 0FF 0F  110   1   011B9
 14 000 00  100   0   00000
 15 000 00  100   0   00000
 16 000 00  100   0   00000
 17 000 00  100   0   00000
IRQ to pin mappings:
IRQ0 -> 2
IRQ1 -> 1
IRQ3 -> 3
IRQ4 -> 4
IRQ6 -> 6
IRQ7 -> 7
IRQ8 -> 8
IRQ9 -> 9
IRQ11 -> 11
IRQ12 -> 12
IRQ13 -> 13
IRQ14 -> 14
IRQ17 -> 17
IRQ18 -> 18
IRQ19 -> 19
 done.
checking TSC synchronization across CPUs: passed.
PCI: PCI BIOS revision 2.10 entry at 0xfdb02
PCI: Using configuration type 1
PCI: Probing PCI hardware
PCI->APIC IRQ transform: (B0,I4,P3) -> 19
PCI->APIC IRQ transform: (B0,I9,P0) -> 17
PCI->APIC IRQ transform: (B1,I3,P0) -> 19
PCI->APIC IRQ transform: (B1,I4,P0) -> 18
Linux NET4.0 for Linux 2.2
Based upon Swansea University Computer Society NET3.039
NET4: Unix domain sockets 1.0 for Linux NET4.0.
NET4: Linux TCP/IP 1.0 for NET4.0
IP Protocols: ICMP, UDP, TCP, IGMP
TCP: Hash tables configured (ehash 524288 bhash 65536)
IPv4 over IPv4 tunneling driver
early initialization of device tunl0 is deferred
GRE over IPv4 tunneling driver
early initialization of device gre0 is deferred
Starting kswapd v 1.5 
Detected PS/2 Mouse Port.
Serial driver version 4.27 with no serial options enabled
ttyS00 at 0x03f8 (irq = 4) is a 16550A
ttyS01 at 0x02f8 (irq = 3) is a 16550A
ttyS02 at 0x03e8 (irq = 4) is a 16550A
pty: 256 Unix98 ptys configured
Software Watchdog Timer: 0.05, timer margin: 60 sec
Real Time Clock Driver v1.09
loop: registered device at major 7
Floppy drive(s): fd0 is 1.44M
FDC 0 is a National Semiconductor PC87306
sym53c8xx: at PCI bus 1, device 4, function 0
sym53c8xx: 53c895 detected with Symbios NVRAM
sym53c895-0: rev=0x01, base=0xfa201000, io_port=0

Re: where to get the Mysql++ API class docuementation.?

[Hensen Yi]

Sinisa:

Thanks, I got it after I download it, I hope the class and method could also be put
in the online browse  or show a notice so that others could know the download
manuel contains the class method.

Best Regards
Hensen




Sinisa Milivojevic wrote:

> Hensen Yi writes:
>  > hi:
>  >
>  > Do you know where to get the class and their methods  documentation of
>  > Mysql++ API,
>  >
>  > Regards
>  > Hensen
>  >
>  >
>
> Hi!
>
> You can download a manual from MySQL++ page.
>
> Regards,
>
> Sinisa
>
>     __ _   _  ___ ==  MySQL AB
>  /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
>/*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaka, Cyprus
>   /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
>   /*/^^^\*\^^^
>  /*/ \*\Developers Team
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Maint Utilities 3.23.32 Core Dumping On SCO 5.0.x

[Grimes, Dean]

>I am using make 3.79.1.  I do not know if that makes a difference.  I am
>using libz-1.1.3 or zlib-1.1.3.

Well I am using the same version of zlib but I am using 3.79 of make. I'll
try make 3.79.1 (but I have my doubts).

This is strange, I can compile 3.23.28-gamma and all runs OK. But 3.23.32
has problems with the afore mentioned utilities. I have a core dump if
anybody is interested.


Thanks,

Dean



-Original Message-
From: Boyd Lynn Gerber [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 10:47 AM
To: Grimes, Dean
Cc: '[EMAIL PROTECTED]'
Subject: Re: Maint Utilities 3.23.32 Core Dumping On SCO 5.0.x


On Tue, 30 Jan 2001, Grimes, Dean wrote:
> I have upgraded from MySQL-3.23.28-gamma to MySQL-3.23.32 and I am having
> problems with some of the maintenance utilities core dumping with a memory
> fault. However, MySQL itself runs fine. The problem utilities are:
>
> mysqldump - core dumps immediately
> mysqlshow - core dumps immediately
> mysqladmin - will not shutdown the database (actually, the database keeps
> restarting and will not shutdown)

I am not able to reproduce the problem on my machine they all work.  I
have tried it on 4 other machines with the same result.  Are you using
libz?  What version of libz?

> My configuration is as follows:
>
> SCO OpenServer 5.0.4 and 5.0.5 - All of the latest patches applied.
> FSU Pthreads - version 3.8
> GNU compiler - version 2.95.2
> GNU make - version 3.79
>
> Other than the above stated problems, MySQL is running fine.

I am using make 3.79.1.  I do not know if that makes a difference.  I am
using libz-1.1.3 or zlib-1.1.3.

Good Luck,

--
Boyd Gerber <[EMAIL PROTECTED]>
ZENEZ   3748 Valley Forge Road, Magna Utah  84044
Office 801-250-0795 FAX 801-250-7975

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

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: Access Ports

[Andreas Vierengel]

-Ursprüngliche Nachricht-
Von: Van <[EMAIL PROTECTED]>
An: Andreas Vierengel <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Datum: 30 January, 2001 16:30
Betreff: Re: Access Ports


>Andreas Vierengel wrote:
>>
>> Try option --skip-grant-tables to mysqld or in mysql.cnf.
>> This will dectivate ALL authorization-checking, but will make the server
a
>> little bit faster...
>>
>> --Andy
>>
>Andy:
>
>Not very secure, I'd argue.
>

Yes, I know. Therefore I wrote "ALL" in capitalized letters :-)
If authorization checking is a "must have" for you, then I think you have no
chance to connect without it. Or run a second mysql-server without
authorization on the same data-files (not very efficient)...

--Andy



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

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 Tables over Multiple Drives

[Tim Bunce]

On Tue, Jan 30, 2001 at 10:57:16PM +0800, Sam Wong wrote:
> > So why isn't the --with-raid option set in the binary download version?
>
> The file will be bigger and slower in result

I doubt it would be significantly bigger. I believe --with-raid support is
a very small and simple layer between mysqld and the file i/o system calls.

I'm not sure what you mean by "slower in result".

Tim.

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

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: 'insert_id' finction not working on V3.23.32

[Angela]

I'm guessing you're using PHP?  I know when we did some upgrades, the
function changed.  It used to be mysql_inser_id([result set]), but when
we upgraded it now wants mysql_insert_id([mysql link])
I believe it was a change between PHP3 and PHP4, but I could be wrong
since we upgraded MySQL at the same time.

-Angela


Julian Hiscock wrote:
> 
> We are running a program which uses the 'mysql_insert_id' function to get
> the id of an AUTO_INSERT key field. This used to work fine with MySQL V3.22,
> but now we've upgraded to V3.23.32 it doesn't seem to be working. The
> function simply returns the same value the whole time the program is
> running.
> 
> Anyone else experienced this or know of a possible cause?
> 
> Cheers,
> 
> Julian
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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

-- 
Angela Curtis
Innovative Business Consultants
http://www.ibc2001.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 Tables over Multiple Drives

[William R. Mussatto]

On Tue, 30 Jan 2001, Sam Wong wrote:

> Date: Tue, 30 Jan 2001 19:32:05 +0800
> From: Sam Wong <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL Tables over Multiple Drives
> 
> Yes, you've to recreate the tables with RAID option (read the manual for
> details)
> and move and link the directoris manually.
> I think there may be a performance gain, instead of performance
> hit...Because as the file spread on diff discs, the seek time gain.
> The code should has been stablize already, I think.
> 
> BTW, why you want it to span over multiple drive?
Please excuse me for being show but "RAID" turns up no hits on the index 
page of the doc's. What is it under and on what versions support it?  
Thanks.

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


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

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: Mysqld eats up RAM and CPU

[Sam Wong]

You've got 1G Ram!
Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which
folder)

- Original Message -
From: "Matis, Jan" <[EMAIL PROTECTED]>
To: "'Sam Wong'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 12:46 AM
Subject: RE: Mysqld eats up RAM and CPU


> what about this ?
>
> 2*PII 450 MHZ
> 1G RAM
> data on hardware raid
>
> port= 3306
> socket  = /tmp/mysql.sock
> user= mysql
> skip-locking
> set-variable= key_buffer=16M
> set-variable= max_allowed_packet=1M
> set-variable= thread_stack=128K
> set-variable= wait_timeout=150
> set-variable= max_connections=768
> set-variable = record_buffer=12k
> set-variable = net_buffer_length=12k
> set-variable = sort_buffer=12k
> set-variable = table_cache=12
>
>
>
> I've never had more than 512 conections ... but sometimes mysql looks
really
> slow ...
> ant load goes up to 40
> do U have some ideas ?
>
>
> Jan
>
>


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

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: Maint Utilities 3.23.32 Core Dumping On SCO 5.0.x

[Boyd Lynn Gerber]

On Tue, 30 Jan 2001, Grimes, Dean wrote:
> I have upgraded from MySQL-3.23.28-gamma to MySQL-3.23.32 and I am having
> problems with some of the maintenance utilities core dumping with a memory
> fault. However, MySQL itself runs fine. The problem utilities are:
>
> mysqldump - core dumps immediately
> mysqlshow - core dumps immediately
> mysqladmin - will not shutdown the database (actually, the database keeps
> restarting and will not shutdown)

I am not able to reproduce the problem on my machine they all work.  I
have tried it on 4 other machines with the same result.  Are you using
libz?  What version of libz?

> My configuration is as follows:
>
> SCO OpenServer 5.0.4 and 5.0.5 - All of the latest patches applied.
> FSU Pthreads - version 3.8
> GNU compiler - version 2.95.2
> GNU make - version 3.79
>
> Other than the above stated problems, MySQL is running fine.

I am using make 3.79.1.  I do not know if that makes a difference.  I am
using libz-1.1.3 or zlib-1.1.3.

Good Luck,

--
Boyd Gerber <[EMAIL PROTECTED]>
ZENEZ   3748 Valley Forge Road, Magna Utah  84044
Office 801-250-0795 FAX 801-250-7975


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

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: Mysqld eats up RAM and CPU

[Matis, Jan]

what about this ? 

2*PII 450 MHZ
1G RAM
data on hardware raid

port= 3306
socket  = /tmp/mysql.sock
user= mysql
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_packet=1M
set-variable= thread_stack=128K
set-variable= wait_timeout=150
set-variable= max_connections=768
set-variable = record_buffer=12k
set-variable = net_buffer_length=12k
set-variable = sort_buffer=12k
set-variable = table_cache=12



I've never had more than 512 conections ... but sometimes mysql looks really
slow ...
ant load goes up to 40 
do U have some ideas ? 


Jan 

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

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: Mysqld eats up RAM and CPU

[Sam Wong]

keybuffer=0?
tablecache=0?
For complicated query, Mysql may search the harddisk for stuff again, the it
holds the query for sometimes...and then some more connection come in, as a
result, more ram and cpu is consumed

May I suggest you to lower down the max connection, and tune up the
caching/buffering setting?

- Original Message -
From: "Scott Gerhardt" <[EMAIL PROTECTED]>
To: "Alejandro M. Leonian" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 12:06 AM
Subject: RE: Mysqld eats up RAM and CPU


> What sort of hardware are you running?
> - Amount of RAM
> - CPU speed.
>
>
>
> >
> > Hi There..
> > I'm running mysql  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu
> > (i686) on  a RedHat 6.1 Os.
> > The server is installed and the configuration is almost by default.
> > The problem is that  most of the time the mysqld threads eat up
> > my RAM and CPU! The server gets very slow at times and it
> > (obviously) afects its performance very badly.
> > Since i'm no expert i have tried as much as i could learn from
> > Deja.com and other web resources.
> > My /etc/my.cnf looks like this:
> >
> > [mysqld]
> > port=3306
> > socket=/tmp/mysql.sock
> > set-variable = key_buffer=0
> > set-variable = record_buffer=4k
> > set-variable = net_buffer_length=4k
> > set-variable = sort_buffer=4k
> > set-variable = table_cache=4
> > set-variable = max_connections=550
> >
> >
> > Please any pointer/tip/manual/website is appreciated.
> > I'm kinda desperate :/.
> > Thanks very much in advance.
> >
> > Latigo
> >
> >
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

'insert_id' finction not working on V3.23.32

[Julian Hiscock]

We are running a program which uses the 'mysql_insert_id' function to get 
the id of an AUTO_INSERT key field. This used to work fine with MySQL V3.22, 
but now we've upgraded to V3.23.32 it doesn't seem to be working. The 
function simply returns the same value the whole time the program is 
running.

Anyone else experienced this or know of a possible cause?

Cheers,

Julian
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Mysqld eats up RAM and CPU

[Scott Gerhardt]

What sort of hardware are you running?
- Amount of RAM
- CPU speed.


 
> 
> Hi There..
> I'm running mysql  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu 
> (i686) on  a RedHat 6.1 Os.
> The server is installed and the configuration is almost by default.
> The problem is that  most of the time the mysqld threads eat up 
> my RAM and CPU! The server gets very slow at times and it 
> (obviously) afects its performance very badly.
> Since i'm no expert i have tried as much as i could learn from 
> Deja.com and other web resources.
> My /etc/my.cnf looks like this:
> 
> [mysqld]
> port=3306
> socket=/tmp/mysql.sock
> set-variable = key_buffer=0
> set-variable = record_buffer=4k
> set-variable = net_buffer_length=4k
> set-variable = sort_buffer=4k
> set-variable = table_cache=4
> set-variable = max_connections=550
> 
>
> Please any pointer/tip/manual/website is appreciated.
> I'm kinda desperate :/.
> Thanks very much in advance.
> 
> Latigo
> 
> 

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

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

mySQL and Mac OS X Server

[Doug Dockery]

Hello all -

I'm a new mySQL user and am interested to know if anyone has successfully
installed mySQL in the Mac OS X Server environment - if so, is there a
precompiled binary or install instructions for the platform?

Thanks and sorry for the newbie question.

Doug

-- 
Doug Dockery
[EMAIL PROTECTED] 


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

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

Re: MyODBC - Long varchar

[Gerald Jensen]

We have a rather complex C++ app that uses MySQL, as well as MSSQL7 and
Oracle in conjunction with Microsoft's Transaction Server.

After considerable trial and error, we have foudn we need to use four of the
options which effect the behaviour of MyODBC ...

- Don't optimize column width
- Return matching rows
- Use manager cursors (exp)
- Return table names in SQLDescribeCol

G. Jensen

- Original Message -
From: "Øystein Selbekk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 1:55 AM
Subject: MyODBC - Long varchar


>
> Hi, we are testing out MySQL, too se if it might meet our needs.
> We are currently having problems returning Text fields from the database
through ODBC.
> System:
> Win NT 4.0
> Visual Basic 6.0 Ent.
> RDO (Remote data objekts, must use!)
> MySQL servers both on W32 and Linux
>
> The first record in the result contains the correct content of the Text
field, but the rest returns NULL. Is there any setting that might fix this
problem?
>
> Another thing: show fields from #tablename# returns 1 record more in a
Linux MySQL server than in the W32. Is there a way to control how much info
that is returned?
>
> Regards Øystein Selbekk, Visbook AS
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

number of tables in a db

[johnny p.]

I have several tables in my db that can potentially become *very* large
*very* quickly.  I was thinking about creating a table for each user of
my database to keep data separate and allow each table to be 4GB due to
OS restrictions.  How many tables can a database have in it? or should i
create a database for each user with an identical table?  and... in that
case... how many databases can MySQL successfully handle at any given
time?

thanks,

johnny p.

---
John Patton, CTO
[EMAIL PROTECTED]

Gameloop, Inc.
http://www.gameloop.com
Austin, TX 512-699-5534


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

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: idle CPU

[Tim Samshuijzen]

the answers make sense

thanks everybody!

Tim Samshuijzen


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

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: idle CPU

[René Tegel]

Yes tim, buy better/faster hard drives and/or put more memory in your
machine.

this 60% idle is the time your proc is waiting for the hard drive reading
data.


- Original Message -
From: "Tim Samshuijzen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 4:03 PM
Subject: idle CPU


>
>
> Hello,
>
> We're running a large database on a dedicated server.
> When I look in the list of active processes, I notice that a
> complicated query takes up no more than about 30 % of CPU.
> During this time the CPU is more than 60 % idle.
> Is there some way to speed up the process?
>
> Tim Samshuijzen
>
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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