Re: can not save the .pdf version of MySql manual

[Sommai Fongnamthip]

If you use IE which associate to PDF file, it may be take a long time to 
display when you click on the link.  Try to use download feature instead 
display (click right mouse on link and choose save target as or download 
with getright/if you have one installed)

Sommai Fongnamthip

At 09:20 2/6/2001 -0500, Paul DuBois wrote:
>On Sat, Jun 02, 2001 at 02:17:38PM +0300, Jüri Kuzmin wrote:
> > Hi all!
> > Can someone please tell me,
> > why i can not save the .pdf version of MySql manual
> > (http://mysql.tradenet.ee/documentation/mysql/alternate.html)
> >
> > Can someone help me, I would like to save this file in my hard disk,
>
>It downloads fine.  This is probably an issue with your browser.
>What did you try, and what happened?  What kind of operating system
>and browser are you using?
>
> > with thanks in advice,
> >
> > Jüri Kuzmin
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>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: remote DB

[Rolf Hopkins]

If your not the admin of the DB, you'll have to ask the DB's admin for your
login and password.  If you are the admin, you'll need to RTFM about DB
security and the GRANT and REVOKE statements.  And no, it's not a good idea
to allow connections using the root user to perform anything else other than
db administration.

- Original Message -
From: "p w" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 14:40
Subject: remote DB


> Hello,
>   Can anyone tell me if the MySQL database has a defualt user ID and
> password? I am trying to access a remote DB with my application, but am
> experiencing difficulties. This may be because I need correct user access
> details. Are there such details, and if so, what are they please?
>   Thanks alot.
>
> Paul.



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

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

remote DB

[p w]

Hello,
  Can anyone tell me if the MySQL database has a defualt user ID and
password? I am trying to access a remote DB with my application, but am
experiencing difficulties. This may be because I need correct user access
details. Are there such details, and if so, what are they please?
Thanks alot.

Paul.  


Get free email and a permanent address at http://www.netaddress.com/?N=1

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

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

good online mysql tutorial???

[Duane Douglas]

hello,

i'm looking for a good online mysql tutorial.  any suggestions?

tia

if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * 
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

problems installing mysql 3.23.38 for linux

[Duane Douglas]

hello,

i'm trying to install mysql 3.23.38 for linux.  the bin directory didn't 
expand when i untarred the mysql installation tarball?  is this a known issue?

tia

if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * 
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

mysql@lists.mysql.com

[root]

>Description:

>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:root
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.33 (Source distribution)

>Environment:

System: Linux php.nodomain.nowhere 2.2.14 #1 SMP Sun Jun 25 16:07:10 KST 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-linux/egcs-2.91.66/specs gcc version
egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc'
CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root
root 13 Jun 4 11:07 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root
root 1249952 Aug 9 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root
2274220 Aug 9 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Aug 9
2000 /usr/lib/libc.so Configure command: ./configure
--prefix=/usr/local/mysql --with-charset=euc_kr
--localstatedir=/file/mysql/data Perl: This is perl, version 5.005_03
built for i386-linux 

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

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 apache, php + mysql on linux redhat 6.2

[Peter Kok]

Hi all

I installed the following version on redhat 6.2 but failed on installing
apache finally!
Please teach me

apache 1.3.19
php-4.0.5
mysql-3.23.38-pc-linux-gnu-i686.tar.gz

mysql can start:  /usr/local/mysql/support-files/mysql.server start

php nothing error: when make and make install
./configure --with-mysql=/usr/local/mysql \
--with-apache=/usr/src/apache \
--enable-track-vars

apache
./configure --prefix=/usr/local/apache \
--activate-module=src/modules/php4/libphp4.a

The error is in 'make'
it seems not locate mysqlclient.

Thank you

regards
Peter



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

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 DB

[Zachary Burnham]

Perl works beautifully with MySQL, as do PHP and Java, and 
$SCRIPTING_LANGUAGE.  Choose your poison.

Z
On Sunday, June 3, 2001, at 08:36 PM, Gary Bonham wrote:

> I've just joined this list as I'm considering using mysql. My databases 
> are
> in Access format, and I don't wish to convert to SQL just yet (although 
> long
> range plans are indeed to do just that), but I need to be able to read 
> them
> in Perl CGI scripts, which is why the interest in mySQL. Is this a 
> feasible
> thing? I'm currently using ASP to access, update, etc., my databases 
> for a
> web site but need to be able to access them from Perl. If this isn't the
> right package, then can someone point me in the right direction?
>
> Gary
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: PHP and MySQL result set navigation

[Rolf Hopkins]

Yep, that's the way you do it. Put it into a 2D array or even better, a
class.  That's if you are familiar with OOP.

- Original Message -
From: "Marco Bleeker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 6:57
Subject: PHP and MySQL result set navigation


> I do something like this, where $result is the result of a mysql_query():
>
>  while ($row = mysql_fetch_array($result))
> {
> if ($row[col] == 1)
> {
> print_entry($row);
> }
> }
> ?>
>
> This is to fill one column on screen. Now I would like to do the same for
> the second column: if ($row[col] == 2). But the $result pointer has moved
> to the end. How to move it back to the start again? reset() won't work,
> because it's not an array, just an integer pointing to a MySQL result set.
> How to move through this result set using PHP? Or should I just run a
> seperate query for each column with a 'where col =' clause? That looks
like
> pretty intensive use of computer resources... I could also turn the result
> set into a 2D array of rows and work with that. Sounds a bit voluminous as
> well...
>
> Thanks, marco
> |
> | Marco Bleeker, Amsterdam
> | [EMAIL PROTECTED]
> | http://www.euronet.nl/users/mbleeker/
> |
> | Attachments only after prior notice please.
> | Don't put me on any kind of mailing list.
> |
> | I am now receiving the Snowhite virus 4x a day
> | - some of you must be infected, please check !
> | (No, you did not get it from me, I use Eudora)
> | __@
> |   _`\<,_
> |__(*)/ (*)Ah, op DIE fiets !
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: JOIN-problems

[Ville Mattila]

> Sir, your query doesn't work on my machine. I either have to GROUP BY 
> orderID, or drop orderID and Name from the SELECT clause. I'm not 
> sure what you're trying to do, so I don't know which to suggest.

Oh, sorry, I didn't check out what did I wrote... ;) Anyway, I got this work after 
GROUP BY OrderID was added to the end of query line. And so it had to be, just forgot 
it.

- Ville


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

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 in slackware trouble

[Van]

bulls wrote:
> 
> dear everybody,
> i've got  error message when test ./mysqladmin -u root
> -h my-host version, but if ./mysql -u root -p , it's
> ok.how to solution?.
> tank you
> 
> =
> 
Bulls:

Try mysqladmin -p -u root version

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: JOIN-problems

[Bob Hall]

>Hi there,
>
>I have five tables in the database: customers, orders, 
>ordercontents, products and payments. The problem is that I should 
>get a list which shows some kind of a ledger list (shows who has 
>paid and so on).
>
>My first try looks like this:
>SELECT orders.OrderID, customers.Name, SUM(ordercontents.Amount * 
>products.Price) AS TotalSum, SUM(payments.PaidFIM) AS TotalPaid FROM 
>orders
>LEFT JOIN customers ON (customers.CustID = orders.CustID)
>LEFT JOIN payments ON (payments.OrderID = orders.OrderID)
>LEFT JOIN ordercontents ON (ordercontents.OrderID = orders.OrderID)
>LEFT JOIN products ON (products.ProdID = ordercontents.ProdID)
>WHERE orders.Cancelled=0 AND ordercontents.Removed=0;
>
>That's it... I hope that you understood the structure. Also there 
>should be noticed that the order can have many different products 
>ordered (listed on ordercontents -table) and also that there can be 
>many separated payments for same order.
>
>Now this query works, but it doesn't return correct amounts for 
>TotalPaid and TotalSum -columns.
>
>Thanks for help,
>- Ville Mattila, Ikaalinen, Finland

Sir, your query doesn't work on my machine. I either have to GROUP BY 
orderID, or drop orderID and Name from the SELECT clause. I'm not 
sure what you're trying to do, so I don't know which to suggest.

Bob Hall

Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
MySQL list magic words: sql query database

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

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

Access DB

[Gary Bonham]

I've just joined this list as I'm considering using mysql. My databases are
in Access format, and I don't wish to convert to SQL just yet (although long
range plans are indeed to do just that), but I need to be able to read them
in Perl CGI scripts, which is why the interest in mySQL. Is this a feasible
thing? I'm currently using ASP to access, update, etc., my databases for a
web site but need to be able to access them from Perl. If this isn't the
right package, then can someone point me in the right direction?

Gary


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

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: Web based application and win2k reports

[Jeremy Zawodny]

On Sun, Jun 03, 2001 at 04:59:24PM -0600, Rick Hanzlik wrote:

> Here the situation.  I need to develop some database applications
> that will run under Apache Web server.  That in itself is not to
> tough.  But, I must be able to access the information stored in the
> database files from a windows 2000 workstation and use Crystal
> reports to generate the necessary management reports.  I have the
> win 32 version of mysql, I have MySQL running on apache on both red
> hat and caldera and I can create the web database application. I
> just can't seem to find a way to get to the data from the win2K
> machine.  Any suggestions?

There is an ODBC driver called MyODBC available on
www.mysql.com. Crystal Reports can use ODBC (if what I've read is
correct), so that should be all you need.

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

MySQL 3.23.29: up 9 days, processed 54,382,230 queries (67/sec. avg)

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

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

PHP and MySQL result set navigation

[Marco Bleeker]

I do something like this, where $result is the result of a mysql_query():



This is to fill one column on screen. Now I would like to do the same for 
the second column: if ($row[col] == 2). But the $result pointer has moved 
to the end. How to move it back to the start again? reset() won't work, 
because it's not an array, just an integer pointing to a MySQL result set. 
How to move through this result set using PHP? Or should I just run a 
seperate query for each column with a 'where col =' clause? That looks like 
pretty intensive use of computer resources... I could also turn the result 
set into a 2D array of rows and work with that. Sounds a bit voluminous as 
well...

Thanks, marco
|
| Marco Bleeker, Amsterdam
| [EMAIL PROTECTED]
| http://www.euronet.nl/users/mbleeker/
|
| Attachments only after prior notice please.
| Don't put me on any kind of mailing list.
|
| I am now receiving the Snowhite virus 4x a day
| - some of you must be infected, please check !
| (No, you did not get it from me, I use Eudora)
| __@
|   _`\<,_
|__(*)/ (*)Ah, op DIE fiets !



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

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

Web based application and win2k reports

[Rick Hanzlik]

Here the situation.  I need to develop some database applications that will
run under Apache Web server.  That in itself is not to tough.  But, I must
be able to access the information stored in the database files from a
windows 2000 workstation and use Crystal reports to generate the necessary
management reports.  I have the win 32 version of mysql, I have MySQL
running on apache on both red hat and caldera and I can create the web
database application. I just can't seem to find a way to get to the data
from the win2K machine.  Any suggestions?
Thanks
Rick
[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

mysqld (InnoDB) crashes on ROLLBACK of LOAD DATA INFILE

[jshelman]

>Description:

 InnoDB crashes when a ROLLBACK of multiple "LOAD DATA INFILE 'file' 
 REPLACE INTO 'table' commands.
 mysqld will not startup again because InnoDB attempts the rollback
 and crashes again.

>How-To-Repeat:

#create a data file (100,000 lines of 3 integers from 0 to 99)
perl -e 'for($i=0; $i<10; $i++){print "$i\t$i\t$i\n";}' > /tmp/data

# create a table:
create table speed1 (a int not null, b int, c int, primary key (a), index (b)) 
TYPE=INNODB

mysql> SET AUTOCOMMIT=0;
Query OK, 0 rows affected (0.01 sec)

mysql> LOAD DATA INFILE "/tmp/data.dat" REPLACE INTO TABLE speed1;
Query OK, 20 rows affected (5.60 sec)
Records: 10  Deleted: 10  Skipped: 0  Warnings: 0

mysql> ROLLBACK;
Query OK, 0 rows affected (2.08 sec)

mysql> LOAD DATA INFILE "/tmp/data.dat" REPLACE INTO TABLE speed1;
Query OK, 20 rows affected (5.59 sec)
Records: 10  Deleted: 10  Skipped: 0  Warnings: 0

mysql> LOAD DATA INFILE "/tmp/data.dat" REPLACE INTO TABLE speed1;
Query OK, 20 rows affected (5.92 sec)
Records: 10  Deleted: 10  Skipped: 0  Warnings: 0

mysql> ROLLBACK;
ERROR 2013: Lost connection to MySQL server during query
mysql>

Running mysqld in gdb results in the following:

(gdb) run --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=root 
--pid-Starting program: /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql 
--dInnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 269517328
InnoDB: Doing recovery: scanned up to log sequence number 0 269582848
InnoDB: Doing recovery: scanned up to log sequence number 0 269648384
InnoDB: Doing recovery: scanned up to log sequence number 0 269713920
InnoDB: Doing recovery: scanned up to log sequence number 0 269779456
InnoDB: Doing recovery: scanned up to log sequence number 0 269844992
InnoDB: Doing recovery: scanned up to log sequence number 0 269910528
.
.
.
InnoDB: Doing recovery: scanned up to log sequence number 0 280330752
InnoDB: Doing recovery: scanned up to log sequence number 0 280396288
InnoDB: Doing recovery: scanned up to log sequence number 0 280424053
Innobase: 1 uncommitted transaction(s) which must be rolled back
Innobase: Starting rollback of uncommitted transactions
Innobase: Rolling back trx no 194872

Program received signal SIGSEGV, Segmentation fault.
0x811c9f8 in trx_undo_rec_release ()
(gdb) bt
#0  0x811c9f8 in trx_undo_rec_release ()
#1  0x80fc97e in row_undo_mod ()
#2  0x80f74a5 in row_undo ()
#3  0x80f75b1 in row_undo_step ()
#4  0x80de1e4 in que_run_threads ()
#5  0x811b9ee in trx_rollback_all_without_sess ()
#6  0x813ad9b in recv_recovery_from_checkpoint_finish ()
#7  0x80dca09 in innobase_start_or_create_for_mysql ()
#8  0x80b9d50 in innobase_init ()
#9  0x80b44d4 in ha_init ()
#10 0x806f8b2 in main ()
#11 0x81cbd15 in __libc_start_main (main=0x806f000 , argc=6, ubp_av=0xba54, 
init=0x80480b4 <_init>,
fini=0x8239d00 <_fini>, rtld_fini=0, stack_end=0xba4c) at 
../sysdeps/generic/libc-start.c:129

>Fix:
None known.

>Submitter-Id:  
>Originator:Jeff Shelman
>Organization:
>MySQL support: none 
>Synopsis:  mysqld (InnoDB) crashes on ROLLBACK
>Severity:  critical 
>Priority:  high 
>Category:  mysql
>Class: sw-bug 
>Release:   mysql-3.23.38 (Source distribution)

>Environment:

System: Linux shado 2.4.3-20mdk #1 Sun Apr 15 23:03:10 CEST 2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs
gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk)
Compilation info: CC='gcc'  CFLAGS='-O3 -mpentiumpro'  CXX='gcc'  CXXFLAGS='-O3 
-mpentiumpro -felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 May  1 20:19 /lib/libc.so.6 -> libc-2.2.2.so
-rwxr-xr-x1 root root  1216268 Feb 21 03:38 /lib/libc-2.2.2.so
-rw-r--r--1 root root 26366908 Feb 21 03:31 /usr/lib/libc.a
-rw-r--r--1 root root  178 Feb 21 03:31 /usr/lib/libc.so
Configure command: ./configure  --prefix=/usr/local/mysql --enable-assembler 
--with-mysqld-ldflags=-all-static --with-innodb


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

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: Values of SET columns with commas (,) are not distinguishable from multiple values

[Alexander Skwar]

So sprach Benjamin Pflugmann am Sun, Jun 03, 2001 at 11:42:34PM +0200:
> Hello.

Nabend!

> Yes, this is the documented behaviour:

Oh, I must have overlooked the last sentence.  Thanks for pointing it out.

> Regardless, this is an interesting proposal which should be
> considered. Only problem is, that it would break old programs which
> rely on using insertions like like "BLONDE,TALL" currently.

Hmm, yes, it will break old programs which used to insert 'BLONDE\,TALL' and
where clever enough to not have it clash with possible other values.  Ie.
programs/programmers which not allowed the three values 'BLONDE', 'TALL' and
'BLONDE,TALL' to exist in one SET column.

Adding a \ before each and every returned , of one value would allow all the
three column values, though.

Or is there currently some workaround that I can use?  Sadly, trying to
escape the , when adding the column doesn't work:

mysql> alter table test add SetCol2 SET ('BLONDE', 'TALL', 'BLONDE\,TALL');
Query OK, 2 rows affected (0.03 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> sho
show databasesshow fields from  show keys fromshow tables   
mysql> show fields from test;
+-++--+-+-++
| Field   | Type   | Null | Key | Default | Extra  
||
+-++--+-+-++
| ID  | tinyint(3) unsigned zerofill   |  | PRI | NULL| auto_increment 
||
| SetCol  | set('BLONDE','TALL','BLONDE,TALL') | YES  | | NULL|
||
| SetCol2 | set('BLONDE','TALL','BLONDE,TALL') | YES  | | NULL|
||
+-++--+-+-++
3 rows in set (0.00 sec)

As you can see, SetCol2 contains 'BLONDE,TALL' and not 'BLONDE\,TALL'.
BTW: I consider this to be an error as well...  Someone please point me to
where it's mentioned in the manual that I'm wrong this time :)

Uh - more strangeness:


mysql> alter table test add SetCol3 SET ('BLONDE', 'TALL', 'BLONDE\\,TALL');
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> show fields from test;
+-+--+--+-+-++
| Field   | Type | Null | Key | Default | Extra
|  |
+-+--+--+-+-++
| ID  | tinyint(3) unsigned zerofill |  | PRI | NULL| 
|auto_increment |
| SetCol  | set('BLONDE','TALL','BLONDE,TALL')   | YES  | | NULL|  
|  |
| SetCol2 | set('BLONDE','TALL','BLONDE,TALL')   | YES  | | NULL|  
|  |
| SetCol3 | set('BLONDE','TALL','BLONDE\\,TALL') | YES  | | NULL|  
|  |
+-+--+--+-+-++
4 rows in set (0.00 sec)

mysql> insert into test set SetCol3 = 'BLONDE\\,TALL';
Query OK, 1 row affected (0.01 sec)

mysql> select * from test;
+-+-+-+-+
| ID  | SetCol  | SetCol2 | SetCol3 |
+-+-+-+-+
| 001 | BLONDE,TALL | NULL| NULL|
| 002 | BLONDE,TALL | NULL| NULL|
| 003 | NULL| NULL| TALL|
+-+-+-+-+
3 rows in set (0.00 sec)

Now, why is for ID == 003   SetCol3 == TALL, and not 'BLONDE\\,TALL'?  If
it's because of a stripped escape character, than I don't understand at all
why the \\ in my ALTER TABLE statement survived.

This is very strange/I don't understand it all

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 günstige Art an Linux Distributionen zu kommen
Uptime: 9 hours 12 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

My sql queries...Which is better??

[VVM Ravikumar Sarma Chengalvala]

Hi,
I am using my sql CAPI.I am able to access the
database well but there is one performance issue that
came into my mind.

Is it better to have a single query on multiple tables
using joins?
   (OR)
Multiple queries without joins on each table,in a
sequential order .

If I use joins also,there won't be more than 3 tables.
I got the issue especially keeping in view of the
factor that I am using C API and I can achieve the
effect of having joins through C/C++ language.

Regards,
Ravi





Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

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

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

Problema con mysql

[Juan Jose BorreX]

hola amigos, tengo el siguiente problema con mysql,
Cuando ejecuto mysql me sale el siguiente mensaje:

  Can´t connect to local MySQL server through socket
'/usr/lib/mysql/mysql.sock/ (111)

¿Por ke me sale esto?
Espero ke me ayuden. Gracias


___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
http://messenger.yahoo.es

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

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: Values of SET columns with commas (,) are not distinguishable from multiple values

[Benjamin Pflugmann]

Hello.

On Sun, Jun 03, 2001 at 11:27:46PM +0200, [EMAIL PROTECTED] wrote:
> >Description:
> If a SET coumn contains values with , (comma), it's impossible to
> distinguish values with a , from multiple values.

Yes, this is the documented behaviour:

-- http://www.mysql.com/doc/S/E/SET.html --
A SET is a string object that can have zero or more values, each of
which must be chosen from a list of allowed values specified when the
table is created. SET column values that consist of multiple set
members are specified with members separated by commas (`,'). A
consequence of this is that SET member values cannot themselves
contain commas.
[...]
---

> >Fix:
> A fix might be to escape the , in the ID == 001 case, like when returning:
> 'BLONDE\,TALL', because that also was, what the column was set to.

Regardless, this is an interesting proposal which should be
considered. Only problem is, that it would break old programs which
rely on using insertions like like "BLONDE,TALL" currently.

Bye,

Benjamin.


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

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

Values of SET columns with commas (,) are not distinguishable from multiple values

[askwar]

>Description:
If a SET coumn contains values with , (comma), it's impossible to
distinguish values with a , from multiple values.
>How-To-Repeat:

mysql> alter table test add SetCol SET ('BLONDE', 'TALL', 'BLONDE,TALL');
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> insert into test set SetCol = 'BLONDE\,TALL';
Query OK, 1 row affected (0.01 sec)

mysql> insert into test set SetCol = 'BLONDE,TALL';
Query OK, 1 row affected (0.00 sec)

mysql> select * from tes
test test.SetCol  
mysql> select * from test;
+-+-+
| ID  | SetCol  |
+-+-+
| 001 | BLONDE,TALL |
| 002 | BLONDE,TALL |
+-+-+
2 rows in set (0.00 sec)

Now, if I need to parse the value of SetCol, how can I differentiate the
value in SetCol for ID == 001 and ID == 002?  The first value is just one
value (BLONDE,TALL), while ID == 002 returned two values for SetCol (BLONDE
and TALL).
>Fix:
A fix might be to escape the , in the ID == 001 case, like when returning:
'BLONDE\,TALL', because that also was, what the column was set to.

>Submitter-Id:  
>Originator:Alexander Skwar
>Organization:
  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 günstige Art an Linux Distributionen zu kommen
>
>MySQL support: none
>Synopsis:  Values of SET cols with , cannot be differentiated
>Severity:  serious
>Priority:  high
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.38 (Linux-Mandrake MySQL RPM)
>Server: /usr/bin/mysqladmin  Ver 8.20 Distrib 3.23.38, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.38
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 7 hours 59 min 52 sec

Threads: 10  Questions: 2837  Slow queries: 0  Opens: 355  Flush tables: 1  Open 
tables: 11 Queries per second avg: 0.099
>Environment:

System: Linux teich.garten.digitalprojects.com 2.4.3-27mdk #1 Mon May 7 19:20:27 CEST 
2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs
gcc version 2.96 2731 (Linux-Mandrake 8.1 2.96-0.53mdk)
Compilation info: CC='gcc'  CFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro 
-march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer'  CXX='g++'  
CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math 
-fno-strength-reduce -fno-omit-frame-pointer'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Mai 27 23:05 /lib/libc.so.6 -> libc-2.2.3.so
-rwxr-xr-x1 root root  1242344 Mai 29 15:58 /lib/libc-2.2.3.so
-rw-r--r--1 root root 26897924 Mai 29 15:21 /usr/lib/libc.a
-rw-r--r--1 root root  178 Mai 29 15:21 /usr/lib/libc.so
-rw-r--r--1 root root  2330246 Jun  1 10:05 /usr/lib/libc-client.a
Configure command: ./configure  --enable-shared --enable-thread-safe-client 
--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/share/info --includedir=/usr/include --mandir=/usr/share/man 
--with-berkeley-db --without-innobase '--with-comment=Linux-Mandrake 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: Mac OS X

[Zachary Burnham]

On Saturday, June 2, 2001, at 04:27 PM, Tommy Beavitt wrote:

> In response to a recent question I posted regarding installing 
> MySQL/PHP/Apache on a G4 tibook I was recommended to get a copy of Mac 
> OS X as this was condsidered to be the most stable and easily 
> configurable option at my disposal.
>
> I am fairly well-versed in relational concepts but a bit slow at 
> command-line interfaces.

Steep learning curve ahead :)

>
> My alternatives are: installing the combo on LinuxPPC, using Windows98 
> (emulated) or getting an x86 computer just for running MySQL/PHP/Apache.

Right now LinuxPPC is probably going to give you the fewest obscure 
issues.  I'm typing this on X at the moment, and it's happily running 
MySQL 3.23.36 (yeah yeah, I'm lazy, sue me :), PHP 4.0.5, and Apache 
1.3.20. It all seems to be getting along fine; granted this isn't a 
production server.  I did have to jump through some hoops in order to 
get MySQL to compile; check the archives of the list.  In X's defense, 
Apache *screams* on it, if you believe the benchmarks. (ObBrag: From 
Apache server status page: CPU Usage: u.07 s0 cu0 cs0 - 4.11e-5% CPU 
load) :)


>
> My purpose is to gain knowledge of the above setup in order to publish 
> information to a virtual server I rent on which MySQL/PHP is supported. 
> I come from a Filemaker Pro background.

FMPro is a totally different beast than MySQL in that it's almost 
completely GUI-driven.  MySQL has a GUI only if you use a third-party 
tool.  However importing/exporting between the two shouldn't be 
difficult; export to csf or tab delimited to transfer between the two.

>
> When I looked on the web at examples of using MySQL with Mac OS X I 
> wasn't particularly reassured. It seems that this is something of a 
> minority interest and there are problems with compiling the application.

This may change with Mac OS X Server 10.0.  Of course, as Mac users, 
we're always fighting the lowest common denominator anyway.  This 
doesn't mean it doesn't work, and work pretty darn well.

>
> Can anyone on this list reassure me that this is indeed the easiest way 
> into the technology? Or should I bite the bullet and get torn into 
> Linux? Although I am a support of the Open Source concept I don't mind 
> paying Apple for the OS X license if it is going to get me up and 
> running quickest. I am currently running Mac OS 9.1.

If you're going to be sticking with PPC hardware you're not going to 
have an easy time finding help with just about everything, due to the 
average techie's bias against the Mac.  LinuxPPC is a kind of middle 
ground; it's not quite the same as running Linux on x86 or Sparc, but it 
gets the job done.

>
> Thanks in advance.
>
> Tommy Beavitt
>
> -
> Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
> 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: FW: ezmlm response

[Paul DuBois]

At 4:39 PM -0400 6/3/01, Zachary Burnham wrote:
>Is this new syntax?  It seems to be different from your book, Paul.

Yes, the quoting rules changed a little subsequent to publication of
the book.  The safest way to specify the account name is to quote both
the user and host parts, but you must quote them separately: "user"@"host"

>
>Z
>On Friday, June 1, 2001, at 10:50 PM, Paul DuBois wrote:
>
>>At 10:13 PM -0400 6/1/01, daddius wrote:
>>>hello everyone...   I am very new to mysql and I needed some help creating 1
>>>admin account for 4 computers.
>>>This is the error I keep getting.
>>>
>>> mysql> grant all on *.* to admin@% identified by "password";
>>> ERROR 1064: You have an error in your SQL syntax near '% identified by
>>>"password"' at line 1
>>> mysql>
>>
>>Put quotes around the % character:
>>
>>mysql> grant all on *.* to admin@"%" identified by "password";
>>
>>-- Paul DuBois, [EMAIL PROTECTED]


-- 
Paul DuBois, [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

MySQL Startup Cmd. ??

[Glenn A . Bookout]

Howdy:

( sorry if this is a second post, but I'm not sure if the 1st. one I sent 
went out OK )

   I'm a bit new to MySQL ( and unix in general ), and I have a couple of 
questions:

   We're using the command:

/usr/local/bin/safe_mysqld &

to startup MySQL on a Mac OSX Server 1.2.x system.

   We would like to add the ability to have it do an auto check/recover 
of the files for corruption when we restart.

   Would my startup command be changed to:

/usr/local/bin/safe_mysqld --myisam-recover &

or do I have to go into safe_mysqld and add that command somewhere?

   Since the above command will run on an unattended CPU, is there any 
problems that can result that would hinder the machine from completing 
the startup sequence?

   Also, it there a searchable archive to this list somewhere that I can 
use for other questions?

   Thanks for your time and help in these matters.

Glenn

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

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: FW: ezmlm response

[Zachary Burnham]

Is this new syntax?  It seems to be different from your book, Paul.

Z
On Friday, June 1, 2001, at 10:50 PM, Paul DuBois wrote:

> At 10:13 PM -0400 6/1/01, daddius wrote:
>> hello everyone...   I am very new to mysql and I needed some help 
>> creating 1
>> admin account for 4 computers.
>> This is the error I keep getting.
>>
>>  mysql> grant all on *.* to admin@% identified by "password";
>>  ERROR 1064: You have an error in your SQL syntax near '% 
>> identified by
>> "password"' at line 1
>>  mysql>
>
> Put quotes around the % character:
>
> mysql> grant all on *.* to admin@"%" identified by "password";
>
>
> -- Paul DuBois, [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: Bug: mysql uses temp filesort instead of index

[Jeremy Zawodny]

On Sun, Jun 03, 2001 at 12:37:50PM -0700, Ben Escoto wrote:
> 
>   JDZ> Did you try (sid > 15 and sid < 17), or something that means
>   JDZ> the same thing as (sid = 16) if sid is an int?
> 
>   JDZ> Don't know if it'll help, but you never know...
> 
> Yep, I thought that was worth a try and attempted various
> combinations.  It seemed that any comparison on the sid column
> caused the use of filesort.

What about if you use BETWEEN()?

I meant to suggest that earlier, too, but I, uh... forgot.

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

MySQL 3.23.29: up 9 days, processed 53,727,748 queries (68/sec. avg)

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

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

Re: Problematic RPMs and Source locations

[Neil Zanella]

If you are uncomfortable with RPM try
the following:

rpm -qa | grep mysql
rpm -qa | grep MySQL
rpm -ql MySQL-client*
Also red the maximum rpm manual:
slocate RPM; slocate rpm | grep pdf
I think mysqladmin might be under /usr/sbin.
And to find out where a file came from do
rpm -qf path-to-file.

Now pertaining to the fact that mysql
stuff is instlled all over the place
by the RPMs that is good but when you
try to install PHP it is impossible
to specify a single directory to
--with-mysql=dir. How then is it
possible to install mysql support
into PHP when everything is all
over the place? I red the PHP README
but found no answer and also found
that when given the --with-mysql flag
php 4.0.5 was not compiling on RHL6.2
due to missing files. Any feedback is
welcome. (soory about the text formatting.
MY console is currently 10x40!)


Thanks!

On Sat, 2 Jun 2001, Mike Loiterman wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Background:
> I'm trying to install the full complement of mysql software...share,
> development, client, and server.  I have installed the source for
> 3.23.38 server and it has worked flawlessly.  Nonetheless, I now need
> all of the above pieces of software on my new box.
>
> Problem:
> I can only find:
> 1. Source for ONLY 3.23.38 server
> 2. RPMs for share, development, client and server for 3.23.37
>
> I have no problem using the 3.23.37 stuff, but when I install the
> rpms the installation seems incomplete and just...wrong for lack of a
> better word.  I was under the impression that the default location
> was /usr/local/mysql.  It is for the source.  But things seem spread
> ALL over the place when I install from the RPMs.  For example there
> is no /usr/local/mysql.  Another example, after the server is done
> installing, I am instructed to cahnge the password via
> /usr/bin/mysqladmin, but mysqladmin is no where to be found.  This
> happened on installs from both my RedHat 7.1 distro and from the
> tarball I downloaded from mysql.com.  Am I missing something?  I
> thought I hated RPMs before, but now I REALLY can't stand them.
>
> Is there anywhere to get the latest versions of the source for all
> the components of mysql?
>
> I have installed and reinstalled countless times...i can't stand it
> anymore.  I would be extremely greatful if someone could explain
> these confusing issues to me.  Thank you.
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 7.0.3 for non-commercial use 
>
> iQA/AwUBOxm+H3J6B0BI4qMYEQIajQCeOHI1LuKmyNlMKe2UvEktb/hA2fwAn3gO
> W5p+za6iKAUiTlPlvwGsQLnw
> =IB5U
> -END PGP SIGNATURE-
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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

[Warren van der Merwe]

Hi

How would you set it up so that each server uses different auto numbers?
Could I do it so that server A's auto numbers start with A, and B's with B,
etc etc etc?

Thanks
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> ]On Behalf
> Of Jeremy Zawodny
> Sent: 01 June 2001 08:34
> To: Warren van der Merwe
> Cc: [EMAIL PROTECTED]
> Subject: Re: Replication
>
>
> On Thu, May 31, 2001 at 09:18:48PM +0200, Warren van der Merwe wrote:
> > Hi there
> >
> > I have three sites, each runnin MYSQL. I want to replicate the data
> > between all three. I know I cannot do this with the standard
> > replication in MYSQL, because all three sites will add their own
> > records and the manual says the slave cannot insert entries it's
> > self.
>
> Actually, you can do that with replication. You just have to get it
> right. :-)
>
> Think of it as a replication ring. Imagine 3 servers: A, B, and C.
>
> B is a slave of A.
> C is a slave of B.
> A is a slave of C.
>
> You can insert a record into one, and it will make it to the other
> two. The server-id in the binary log prevents this setup from causing
> an infinite loop.
>
> The trick is making sure that you don't have inserts which try to
> stomp on each other. Generally this means that you can't use
> AUTO_INCREMENT columns without taking extra precautions. You need to
> ensure that server A can't generate the same ID that any other server
> would generate.
>
> If this isn't obvious (not sure how much you already know about
> replication), just say so. We can go into more detail.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
>
> MySQL 3.23.29: up 6 days, processed 41,479,099 queries (73/sec. avg)
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>


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

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

Re: Bug: mysql uses temp filesort instead of index

[Ben Escoto]

> "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> wrote the following on Sun, 3 Jun 2001 21:31:48 +0300 (EEST)

  >> Thank you for the response.  In which cases does DESC disable
  >> indexed sorting?  Perhaps there is a a way around this for the
  >> time being?  For instance, I noticed that although:
  >> 
  >> SELECT * FROM sqmail.sequence_data WHERE sid = 16 ORDER BY sid
  >> DESC,id DESC LIMIT 10
  >> 
  >> uses filesort,
  >> 
  >> SELECT * FROM sqmail.sequence_data WHERE id < 10 ORDER BY sid
  >> DESC,id DESC LIMIT 10

  SM> Can you send me output of EXPLAIN for both queries.

For the first:

+---+--+---+---+-+---++-+
| table | type | possible_keys | key   | key_len | ref   | rows   | Extra  
| |
+---+--+---+---+-+---++-+
| sequence_data | ref  | sidid | sidid |   4 | const | 124561 | where 
|used; Using index; Using filesort |
+---+--+---+---+-+---++-+

And the second:

+---+---+---+---+-+--++-+
| table | type  | possible_keys | key   | key_len | ref  | rows   | Extra  
| |
+---+---+---+---+-+--++-+
| sequence_data | index | NULL  | sidid |   8 | NULL | 155292 | where 
|used; Using index |
+---+---+---+---+-+--++-+

And a "control" case:

EXPLAIN SELECT * FROM sqmail.sequence_data ORDER BY sid DESC,id DESC LIMIT 10;
+---+---+---+---+-+--++-+
| table | type  | possible_keys | key   | key_len | ref  | rows   | Extra  
| |
+---+---+---+---+-+--++-+
| sequence_data | index | NULL  | sidid |   8 | NULL | 155292 | Using 
|index |
+---+---+---+---+-+--++-+


  ryc> Perhaps ORDER BY (column * -1), if the column is numeric would
  ryc> be sufficient. But that might also make the optimizer less
  ryc> willing to use the index for sorting. Also I think MySQL will
  ryc> use filesort when the returned result is large, but I could be
  ryc> wrong.

Yep, thats a good idea, but even for simple queries it seems to turn
indexing off.  For instance, on a table with 12 rows indexed by
id, this:

SELECT id FROM headers ORDER BY (id*-1) LIMIT 10;

took 100+ times as long as the equivalent:

SELECT id FROM headers ORDER BY id DESC LIMIT 10;


  JDZ> Did you try (sid > 15 and sid < 17), or something that means
  JDZ> the same thing as (sid = 16) if sid is an int?

  JDZ> Don't know if it'll help, but you never know...

Yep, I thought that was worth a try and attempted various
combinations.  It seemed that any comparison on the sid column caused
the use of filesort.


--
Ben Escoto

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

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 Startup Cmd. ??

[Glenn A . Bookout]

Howdy:

   I'm a bit new to MySQL ( and unix in general ), and I have a couple of 
questions:

   We're using the command:

/usr/local/bin/safe_mysqld &

to startup MySQL on a Mac OSX Server 1.2.x system.

   We would like to add the ability to have it do an auto check/recover 
of the files for corruption when we restart.

   Would my startup command be changed to:

/usr/local/bin/safe_mysqld --myisam-recover &

or do I have to go into safe_mysqld and add that command somewhere?

   Also, it there a searchable archive to this list somewhere that I can 
use for other questions?

   Thanks for your time and help in these matters.

Glenn

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

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: Bug: mysql uses temp filesort instead of index

[Jeremy Zawodny]

On Sun, Jun 03, 2001 at 11:01:50AM -0700, Ben Escoto wrote:
> > "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> > wrote the following on Sun, 3 Jun 2001 14:52:44 +0300 (EEST)
> 
>   >> Hi, I think I found a bug in mysql.  I tried the mysqlbug thing
>   >> but it didn't work right away.  I hope this message will be
>   >> detailed enough.  I am not subscribed to the mailing list.
> 
>   >> mysql -e "EXPLAIN SELECT * FROM sqmail.sequence_data WHERE sid =
>   >> 16 ORDER BY sid desc,id desc LIMIT 10"
> 
>   >> The output of the last command contains "Using filesort" when it
>   >> seems like it shouldn't.
> 
>   SM> MySQL is still using filesort, because of "ORDER BY sid desc,id
>   SM> desc".
> 
>   SM> Simply, setting DESC disables usage of index ...
> 
> Thank you for the response.  In which cases does DESC disable indexed
> sorting?  Perhaps there is a a way around this for the time being?
> For instance, I noticed that although:
> 
> SELECT * FROM sqmail.sequence_data WHERE sid = 16 ORDER BY sid DESC,id
> DESC LIMIT 10
> 
> uses filesort, 
> 
> SELECT * FROM sqmail.sequence_data WHERE id < 10 ORDER BY
> sid DESC,id DESC LIMIT 10
> 
> does not and is quite fast.  Somehow the optimizer is getting confused
> by the "sid = 16".  I was thinking that perhaps there is some magic
> way of rephrasing the problem that MySQL would understand better.

Did you try (sid > 15 and sid < 17), or something that means the same
thing as (sid = 16) if sid is an int?

Don't know if it'll help, but you never know...

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

MySQL 3.23.29: up 9 days, processed 53,444,771 queries (68/sec. avg)

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

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

Re: Bug: mysql uses temp filesort instead of index

[ryc]

> does not and is quite fast.  Somehow the optimizer is getting confused
> by the "sid = 16".  I was thinking that perhaps there is some magic
> way of rephrasing the problem that MySQL would understand better.
> Failing that, what is the recommended way of making this query
> quicker?  Should I insert another index, for instance called
> negative_id that is always (4294967296 - id) or something like that,
> so I can ORDER BY negative_id instead of ORDER BY id DESC?
>
> Thank you for any advice or suggestions you might have.

Perhaps ORDER BY (column * -1), if the column is numeric would be
sufficient. But that might also make the optimizer less willing to use the
index for sorting. Also I think MySQL will use filesort when the returned
result is large, but I could be wrong.

ryan


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

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: Bug: mysql uses temp filesort instead of index

[Sinisa Milivojevic]

Ben Escoto writes:
> Thank you for the response.  In which cases does DESC disable indexed
> sorting?  Perhaps there is a a way around this for the time being?
> For instance, I noticed that although:
> 
> SELECT * FROM sqmail.sequence_data WHERE sid = 16 ORDER BY sid DESC,id
> DESC LIMIT 10
> 
> uses filesort, 
> 
> SELECT * FROM sqmail.sequence_data WHERE id < 10 ORDER BY
> sid DESC,id DESC LIMIT 10
> 
> does not and is quite fast.  Somehow the optimizer is getting confused
> by the "sid = 16".  I was thinking that perhaps there is some magic
> way of rephrasing the problem that MySQL would understand better.
> Failing that, what is the recommended way of making this query
> quicker?  Should I insert another index, for instance called
> negative_id that is always (4294967296 - id) or something like that,
> so I can ORDER BY negative_id instead of ORDER BY id DESC?
> 
> Thank you for any advice or suggestions you might have.
> 
> 
> --
> Ben Escoto
> 

Hi!

Can you send me output of EXPLAIN for both queries.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, 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

Re: Bug: mysql uses temp filesort instead of index

[Ben Escoto]

> "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> wrote the following on Sun, 3 Jun 2001 14:52:44 +0300 (EEST)

  >> Hi, I think I found a bug in mysql.  I tried the mysqlbug thing
  >> but it didn't work right away.  I hope this message will be
  >> detailed enough.  I am not subscribed to the mailing list.

  >> mysql -e "EXPLAIN SELECT * FROM sqmail.sequence_data WHERE sid =
  >> 16 ORDER BY sid desc,id desc LIMIT 10"

  >> The output of the last command contains "Using filesort" when it
  >> seems like it shouldn't.

  SM> MySQL is still using filesort, because of "ORDER BY sid desc,id
  SM> desc".

  SM> Simply, setting DESC disables usage of index ...

Thank you for the response.  In which cases does DESC disable indexed
sorting?  Perhaps there is a a way around this for the time being?
For instance, I noticed that although:

SELECT * FROM sqmail.sequence_data WHERE sid = 16 ORDER BY sid DESC,id
DESC LIMIT 10

uses filesort, 

SELECT * FROM sqmail.sequence_data WHERE id < 10 ORDER BY
sid DESC,id DESC LIMIT 10

does not and is quite fast.  Somehow the optimizer is getting confused
by the "sid = 16".  I was thinking that perhaps there is some magic
way of rephrasing the problem that MySQL would understand better.
Failing that, what is the recommended way of making this query
quicker?  Should I insert another index, for instance called
negative_id that is always (4294967296 - id) or something like that,
so I can ORDER BY negative_id instead of ORDER BY id DESC?

Thank you for any advice or suggestions you might have.


--
Ben Escoto

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

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

Re: Some more info about backup.

[Heikki Tuuri]

Hi!

>With mysqldump which uses the following query to do this:
>
>SELECT * INTO OUTFILE '/spylog/test/g00hits.txt' FROM g00hits
>
>It takes:
>real1m23.177s   (first time)
>real1m20.934s   (second time)

The dump speed is 45000 rows or 5 MB per second. I think best disks
today can write 10 MB/second. Thus for the dump the disk and the CPU
are about equal bottlenecks.

>mysql> load data infile '/spylog/test/g00hits.txt' ignore into table g00hits;
>Query OK, 3722867 rows affected (8 min 35.73 sec)
>
>mysql> load data infile '/spylog/test/g00hits.txt'  ignore into table g00hits;
>Query OK, 3722867 rows affected (3 min 35.26 sec)

What was the difference between the first run and the second run? Why is
the time in the second run only 1/2 of the first run?

In the second run you load 15000 rows per second, or
1.5 MB/s, which sounds a reasonable speed, since your rows are much
bigger than the rows in my test. Thus there is no performance bug
indicated by these numbers. The question is why your original test
took 40 minutes, though on a different computer.

In my test I was able to load 45000 8-byte rows per second,
which makes an input speed of 400 kB per second, much smaller than
the disk read speed. Thus we see that loading of data is CPU-bound
even on the fastest available processors, if we do not need to do
random disk accesses in building the indexes.

As a conclusion, are these numbers not satisfactory? You can dump
tables at about the same speed as the disk can write, and you can
import 50 million rows or 5 GB per hour.

Regards,

Heikki

At 09:38 PM 6/2/01 +0400, you wrote:
>Hello mysql,
>
>  I'm repeating my test's now with more information and on more
>  powerfull maching with no load now, this should give more accurate
>  results.
>  The machine is Dual PIII-750/1GB RAM
>
>  I'm trying the following table  structure:
>
>CREATE TABLE g00hits (
>  id int(10) unsigned NOT NULL auto_increment,
>  counter_id int(10) unsigned NOT NULL default '0',
>  visitor_id int(10) unsigned NOT NULL default '0',
>  server_id smallint(5) unsigned NOT NULL default '0',
>  ip int(10) unsigned NOT NULL default '0',
>  ts timestamp(14) NOT NULL,
>  method_id tinyint(3) unsigned NOT NULL default '0',
>  http_ver_id tinyint(3) unsigned NOT NULL default '0',
>  page_id int(10) unsigned NOT NULL default '0',
>  referer_page_id int(10) unsigned NOT NULL default '0',
>  status smallint(5) unsigned NOT NULL default '0',
>  bytes int(10) unsigned NOT NULL default '0',
>  browser_id mediumint(8) unsigned NOT NULL default '0',
>  language smallint(5) unsigned NOT NULL default '0',
>  local_visitor_id bigint(10) unsigned NOT NULL default '0',
>  process_time int(10) unsigned NOT NULL default '0',
>  proxy_software_id mediumint(8) unsigned NOT NULL default '0',
>  proxy_client_ip int(10) unsigned NOT NULL default '0',
>  auth_user_id int(10) unsigned NOT NULL default '0',
>  flag int(10) unsigned NOT NULL default '0',
>  session_id int(10) unsigned NOT NULL default '0',
>  doc_type smallint(5) unsigned NOT NULL default '0',
>  online_users smallint(5) unsigned NOT NULL default '0',
>  src_id int(10) unsigned NOT NULL default '0',
>  PRIMARY KEY  (counter_id,ts,id),
>  KEY visitor_id (visitor_id)
>) TYPE=MyISAM PACK_KEYS=1 DELAY_KEY_WRITE=1;
>
>which has:
>mysql> select count(*) from g00hits;
>+--+
>| count(*) |
>+--+
>|  3722867 |
>+--+
>1 row in set (0.01 sec)
>
>MYD file takes 300MB, text output 400MB
>
>With mysqldump which uses the following query to do this:
>
>SELECT * INTO OUTFILE '/spylog/test/g00hits.txt' FROM g00hits
>
>It takes:
>real1m23.177s   (first time)
>real1m20.934s   (second time)
>
>The backup table for the same table takes:
>
>first time:
>mysql> backup table g00hits to '/spylog/test';
>+--++--+--+
>| Table| Op | Msg_type | Msg_text |
>+--++--+--+
>| la00.g00hits | backup | status   | OK   |
>+--++--+--+
>1 row in set (22.60 sec)
>second time:
>
>mysql> backup table g00hits to '/spylog/test';
>+--++--+--+
>| Table| Op | Msg_type | Msg_text |
>+--++--+--+
>| la00.g00hits | backup | status   | OK   |
>+--++--+--+
>1 row in set (21.34 sec)
>
>
>Well. We have 4 times difference here, which is a bit strange as I
>would expect the disk speed should be the limit here, but not
>converting the rows in text format, which is in this case done at
>speed of 45000rows/second, which is not really much I think for this
>type of operation. Hope mysql does not use strcat to form the strings?
>
>
>Well. Let's try to do the restore:
>mysql> restore table g00hits from '/spylog/test';
>+--+-+--+--+
>| Table| Op  | Msg_type | Msg_text |
>+--+-+--+--+
>| test.g00hits | res

Errors compiling with libmsqlclient on FreeBSD

[Richard J. Sexton]

Current FreeBSD. What stupid thing have I done now?

# make
gcc innovcheck.o -o innovcheck /usr/local/lib/vrx/libvrx.a /usr/local/lib/mysql/
libmysqlclient.a /usr/lib/libc.a /usr/lib/libm.a
/usr/libexec/elf/ld: Warning: size of symbol `rtime' changed from 9 to 571 in rt
ime.o
/usr/libexec/elf/ld: Warning: type of symbol `rtime' changed from 1 to 2 in rtim
e.o
/usr/lib/libc.so: warning: mktemp() possibly used unsafely; consider using mkste
mp()
/usr/lib/libc.so: warning: this program uses f_prealloc(), which is stupid.
/usr/local/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_a
lloc':
my_compress.o(.text+0xb0): undefined reference to `compress'
/usr/local/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress
':
my_compress.o(.text+0x121): undefined reference to `uncompress'
*** Error code 1


--
 /"\ / http://www.vrx.net
 \ /  ASCII RIBBON CAMPAIGN / http://killifish.vrx.net
  X   AGAINST HTML MAIL/ [EMAIL PROTECTED] +1 (613) 473-1719
 / \  AND POSTINGS/ http://www.mbz.org http://www.dnso.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: Mac OS X

[Paul DuBois]

At 9:27 PM +0100 6/2/01, Tommy Beavitt wrote:
>In response to a recent question I posted regarding installing 
>MySQL/PHP/Apache on a G4 tibook I was recommended to get a copy of 
>Mac OS X as this was condsidered to be the most stable and easily 
>configurable option at my disposal.
>
>I am fairly well-versed in relational concepts but a bit slow at 
>command-line interfaces.
>
>My alternatives are: installing the combo on LinuxPPC, using 
>Windows98 (emulated) or getting an x86 computer just for running 
>MySQL/PHP/Apache.
>
>My purpose is to gain knowledge of the above setup in order to 
>publish information to a virtual server I rent on which MySQL/PHP is 
>supported. I come from a Filemaker Pro background.
>
>When I looked on the web at examples of using MySQL with Mac OS X I 
>wasn't particularly reassured. It seems that this is something of a 
>minority interest and there are problems with compiling the 
>application.

There are very few problems building it under current releases of MySQL.
One problem *running* it has to do with the inability of mysqladmin to
make the server shut down.

re: reassurance, given the short lifetime of Mac OS X, I'd say it's a
reasonably good platform for MySQL.  Certainly better than either MkLinux
or LinuxPPC were at this stage in their careers.

You might find the following article interesting:

http://www.devshed.com/Server_Side/Administration/BuildingOnOSX/

>
>Can anyone on this list reassure me that this is indeed the easiest 
>way into the technology? Or should I bite the bullet and get torn 
>into Linux? Although I am a support of the Open Source concept I 
>don't mind paying Apple for the OS X license if it is going to get 
>me up and running quickest. I am currently running Mac OS 9.1.
>
>Thanks in advance.
>
>Tommy Beavitt


-- 
Paul DuBois, [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: changing data paths

[Mike]

Unsure on the Paths, but I know someone else will help there, but Kylix doe
not support the current version of MySQL with the libmysql.10 only version
.6 or the 3.23.32 version.

Cheers


-Original Message-
From: simon [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 02, 2001 3:41 PM
To: [EMAIL PROTECTED]
Subject: changing data paths


Hi

I have just started to look at mysql as a database for use with kylix,
using Linux Mandrake 8.0.  One thing I would like to be able to do is store
data in a directory of my choice,  but their seems to be no infomation on
this. The only infomation is on a procedure in windows, but the comments say
that it does not work.

I would appreciate some advice.

regards

Simon


--
*
Simon Batty
Fieldview
West Barsham Road
East Barsham
North Norfolk
NR21 0AR
tel. 01328 820083
mobile/sms 07810648314
**

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

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:Question for a MYSQL expert (I assume this list has some)...

[Heikki Tuuri]

Kenneth,

there was discussion about Parallel MySQL on the internals mailing
list 3 months ago. I have pasted at the end of this message what
I then wrote there about a parallel InnoDB.

I think Jeremy Zawodny is right in suggesting that you create several
application server processes on several computers, and put the database
on a single big SMP box from Sun or HP, for example. In the SAP R/3
OLTP bechmark the application servers use more CPU than the database
server. I think you can find the description of the benchmark
systems from the SAP website.

The perennial question in distributed databases is whether you can
really get more speed from them than from a single SMP box. For a
read-only database the answer is definitely yes, and you can, for example,
use the MySQL replication. For an update-intensive database the problem
is that communication between the nodes uses CPU and introduces latency.

Recent TPC-C records have been run on shared-nothing Windows 2000
clusters, but they take advantage of the TPC-C specification which
has been designed so that it is possible to divide the TPC-C load between
several nodes, and still get only a moderate inter-node communication
load.

Actually, the bottleneck in SMP computers is exactly the same as
in a distributed system: in an update-intensive database application,
processors in the computer have to send data from a processor cache
to another processor cache when they read and update memory locations.

If there are a lot of processors in the computer, this traffic will
saturate the memory bus. This is one of the reasons why the biggest SMP
computers have only 64 processors. And adding bigger processor
caches (Alphas could have up to 16 MB, I think) only helps in a
read-intensive application.

Regards,

Heikki Tuuri
Innobase Oy

>On Fri, Jun 01, 2001 at 10:00:01AM -0700, Kenneth Kopelson wrote:
>>
>> I am hoping there are people who use MySQL for serious business
>> applications on this list.
>
>We're occasionally serious here. Other times, it just depends on the
>sort of mood that people seem to be in. :-)
>
>(I just think it's dangerous to equate "expert" and "serious business"
>given what I've seen at some companies...)
>
>> HERE IS MY QUESTION:
>> 
>> I have need for multiple servers to share the same database files.
>
>Instead of replication?
>
>Folks have done that before. Often times they'll put the data files on
>a Netapp and point a cluster of MySQL servers at it. It's VERY
>important, of course, to have really fast (switched) network
>connections between the MySQL servers and the Netapp.
>
>> We are implementing a site that will have hundreds of thousands of
>> users at the same time, so we need a large pool of Linux servers
>> that are load-balanced.
>
>That is a lot of users. How many simultaneous MySQL sessions to you
>think that will equate to? Will you have some sort of connection
>pooling at the application layer?
>
>> Then, all these servers, each of which will run Apache and MySQL (or
>> another database if MySQL just can't handle the load), needs to
>> access the single large RAID disk array through a giga-bit network
>> connection.
>
>Why not separate the Apache servers from the MySQL servers? It would
>seem to be easier to scale that way.
>
>> Certainly, this is not uncommon, as any large database driven
>> website needs to have a similar setup (like eBay, Microsoft, Apple,
>> Amazon, etc.).
>
>You'd be surprised. Some rather high-traffic sites have been able to
>get away with a single monster database server that had lots of
>clients talking to it. I don't know that should say who this
>particular example is, but they managed to handle a lot of traffic
>using this model with [gasp!] Oracle.
>
>> The servers need to be setup in a cluster to provide the required
>> high-availability.  Also, replication will NOT work, as we need
>> changes to the database to be immediately available to everyone
>> else, and managing 100 or more replicated databases would be a
>> nightmare.
>
>You're going to really need 100 servers?
>
>> So, how do we get support in MySQL so that multiple instances of the
>> mysqld daemon running on separate machines can all access the same
>> database files located on a central server?  I can see how the file
>> system of the central database server could be exported through NFS
>> (or something similar) so that all the machines in the cluster can
>> access the database files.  I also imagine the daemons would need to
>> have some sort of locking mechanism to avoid stepping on each other.
>
>You'll find a very brief mention of what you need to know here:
>
>  http://www.mysql.com/doc/S/y/System.html
>
>What this documentation doesn't say, however, is that this model
>really only works with MyISAM tables. I'm pretty sure it doesn't do
>you any good with InnoDB, BDB, or Gemini tables. And those are the
>ones whith more granular locking and better performance in heavy
>update situations.
>
>If you can tolerate a small amount of

Re: mysql in slackware trouble

[Paul DuBois]

On Sun, Jun 03, 2001 at 05:39:57AM -0700, bulls wrote:
> dear everybody,
> i've got  error message when test ./mysqladmin -u root
> -h my-host version, but if ./mysql -u root -p , it's
> ok.how to solution?.
> tank you

There are two differences between your commands (aside from the fact
that one is mysqladmin and the other mysql):
1) The first command does not include -p, the second command does.
2) The first command names a server host, the second command does not.

Your problem could be due to either difference.  Try specifying -p
for the first command and then entering the password when prompted.
If that doesn't work, then perhaps the MySQL root user on your client
host has no permission to connect to the server on my-host.  In
that case, you'll need to use GRANT to add the appropriate account.

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

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

changing data paths

[simon]

Hi

I have just started to look at mysql as a database for use with kylix,   
using Linux Mandrake 8.0.  One thing I would like to be able to do is store 
data in a directory of my choice,  but their seems to be no infomation on 
this. The only infomation is on a procedure in windows, but the comments say 
that it does not work. 

I would appreciate some advice.

regards 

Simon  


-- 
*
Simon Batty
Fieldview
West Barsham Road
East Barsham
North Norfolk
NR21 0AR
tel. 01328 820083
mobile/sms 07810648314
**

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

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: Java/Linux Mysql JDBC?

[Nico D]

Thankx! I found the jar file.

ta
-nico
On Sun, 3 Jun 2001, Rohit Peyyeti wrote:

> 
> Did you try using binary build? One which I use locally here, I just have to
> un-tar
> the tar file and then add the .jar file in the classpath!
> 
> You can try downloading binary build from this place:
> http://mmmysql.sourceforge.net/
> 
> That's it!
> 
> ...Rohit
> 
> 
> 
> - Original Message -
> From: Nico D <[EMAIL PROTECTED]>
> To: Rohit Peyyeti <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Sunday, June 03, 2001 1:32 PM
> Subject: Re: Java/Linux Mysql JDBC?
> 
> 
> > I've download the tar.gz file off of mysql.com, then I modified
> > the Makefile for the mm.mysql.jdbc program so that it pointed
> > to my java binary directory. When I run "make all" it gives
> > me about 50 or so errors (one included as attachment) but
> > basically consists of
> >
> > .PreparedStatement should be declared abstract; it does not define
> > addBatch() in org.gjt.mm.mysql.PreparedStatement
> >
> > I'm running redhat 7.0 and redhat 7.1 on different boxes, both give the
> > same errors. I've also installed the Java 1.3 binaries and SDK from sun's
> > website. Java Standard Edition build 1.3.0
> >
> > Thankx guys!
> >
> > On Sun, 3 Jun 2001, Rohit Peyyeti wrote:
> >
> > > Can you tell us what exactly you are not able get it to work? What
> > > error you are getting?
> > >
> > > ...Rohit
> > >
> > > - Original Message -
> > > From: Nico D <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Sunday, June 03, 2001 11:08 AM
> > > Subject: Java/Linux Mysql JDBC?
> > >
> > >
> > > > Can anyone out there tell me how to use java and JDBC to connect to a
> > > > MySQL db on a linux box, i've downloaded the api of the website but I
> > > > can't get it working correctly. Could someone send me some sample code
> > > > and/or tell me where to put the api and how to reference it?
> > > >
> > > > thankx alot!
> > > > -nico
> > > >
> > > > --
> > > > 
> > > > Nico Darrow RHCE
> > > > CEO DeckerNET LLC
> > > > Network Engineer/Programmer
> > > > email:[EMAIL PROTECTED]
> > > > ph:706.254.2128
> > > > 
> > > >
> > > > "The software said it worked with windows 95 or better, so I
> > > > installed linux." - NA
> > > >
> > > > "I'm not saying Bill Gates is the devil, its just that if he ever
> > > > went to hell, he wouldn't need a translator." -LJ
> > > >
> > > > "I'll do that just now." -nico
> > > >
> > > > "Never trust a engineer that tatoo's his IP address on his arm,
> > > > especially if its DHCP." - /.
> > > >
> > > >
> > > >
> > > >
> > > > -
> > > > Before posting, please check:
> > > >http://www.mysql.com/manual.php   (the manual)
> > > >http://lists.mysql.com/   (the list archive)
> > > >
> > > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > > >
> > > >
> > >
> > >
> >
> > --
> > 
> > Nico Darrow RHCE
> > CEO DeckerNET LLC
> > Network Engineer/Programmer
> > email:[EMAIL PROTECTED]
> > ph:706.254.2128
> > 
> >
> > "The software said it worked with windows 95 or better, so I
> > installed linux." - NA
> >
> > "I'm not saying Bill Gates is the devil, its just that if he ever
> > went to hell, he wouldn't need a translator." -LJ
> >
> > "I'll do that just now." -nico
> >
> > "Never trust a engineer that tatoo's his IP address on his arm,
> > especially if its DHCP." - /.
> >
> >
> >
> 
> 

-- 

Nico Darrow RHCE
CEO DeckerNET LLC
Network Engineer/Programmer
email:[EMAIL PROTECTED]
ph:706.254.2128


"The software said it worked with windows 95 or better, so I
installed linux." - NA

"I'm not saying Bill Gates is the devil, its just that if he ever
went to hell, he wouldn't need a translator." -LJ

"I'll do that just now." -nico

"Never trust a engineer that tatoo's his IP address on his arm,
especially if its DHCP." - /.




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

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: merge two statements

[Patrick Goetz]

On Sat, 2 Jun 2001, Jens Luedicke wrote:

> I'm using MySQL through the Perl DBI and I want to merge
> two SQL statements that would simplify my code:
> 
> 1. SELECT * FROM filters WHERE folder != '$folder'
> 2. SELECT * FROM mails WHERE folder_name = '$folder' AND x$filters->{type} LIKE 
>'%$filters->{pattern}%'
> 
> for each of the results of the first statement the second statement is called
> and based on the new results further actions are taken. 
> 
> How can I merge them?
> 

This would be what's called a subselect, and MySQL doesn't support them
yet.



 ***
 Gallons of oil per day that the proposed drilling of Alaska's Arctic
 National Wildlife Refuge is projected to yield:  42,000,000

 Gallons by which daily U.S. oil consumption would drop if SUVs' average
 fuel efficiency increased by 3 mpg:  49,000,000
 ***
   _Patrick Goetz
 _| ~-. Dept. of Mathematics
 \, *_} The University of Texas at Austin[EMAIL PROTECTED]
   \(   Austin, Texas 78712-1084 Phone:  (512) 232-2746
http://www.ma.utexas.edu/users/pgoetz



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

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

segmentation fault with g++/cygwin/mysql

[Mehdi Rachdi]

Hi all,

I hava a little problem for developping a windows mysql client program in
C++.
I compile it using cygwin. there is no problem during the compilation but
when I execute it, it seems that when I execute a select query and retrieve
the data, it access memory that it shouldn't. I tested my program under
linux and no problem.
So, if somebody have an explication...
I use Win 98 and cygwin 1.1.8



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

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: Java/Linux Mysql JDBC?

[Rohit Peyyeti]

Did you try using binary build? One which I use locally here, I just have to
un-tar
the tar file and then add the .jar file in the classpath!

You can try downloading binary build from this place:
http://mmmysql.sourceforge.net/

That's it!

...Rohit



- Original Message -
From: Nico D <[EMAIL PROTECTED]>
To: Rohit Peyyeti <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 03, 2001 1:32 PM
Subject: Re: Java/Linux Mysql JDBC?


> I've download the tar.gz file off of mysql.com, then I modified
> the Makefile for the mm.mysql.jdbc program so that it pointed
> to my java binary directory. When I run "make all" it gives
> me about 50 or so errors (one included as attachment) but
> basically consists of
>
> .PreparedStatement should be declared abstract; it does not define
> addBatch() in org.gjt.mm.mysql.PreparedStatement
>
> I'm running redhat 7.0 and redhat 7.1 on different boxes, both give the
> same errors. I've also installed the Java 1.3 binaries and SDK from sun's
> website. Java Standard Edition build 1.3.0
>
> Thankx guys!
>
> On Sun, 3 Jun 2001, Rohit Peyyeti wrote:
>
> > Can you tell us what exactly you are not able get it to work? What
> > error you are getting?
> >
> > ...Rohit
> >
> > - Original Message -
> > From: Nico D <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, June 03, 2001 11:08 AM
> > Subject: Java/Linux Mysql JDBC?
> >
> >
> > > Can anyone out there tell me how to use java and JDBC to connect to a
> > > MySQL db on a linux box, i've downloaded the api of the website but I
> > > can't get it working correctly. Could someone send me some sample code
> > > and/or tell me where to put the api and how to reference it?
> > >
> > > thankx alot!
> > > -nico
> > >
> > > --
> > > 
> > > Nico Darrow RHCE
> > > CEO DeckerNET LLC
> > > Network Engineer/Programmer
> > > email:[EMAIL PROTECTED]
> > > ph:706.254.2128
> > > 
> > >
> > > "The software said it worked with windows 95 or better, so I
> > > installed linux." - NA
> > >
> > > "I'm not saying Bill Gates is the devil, its just that if he ever
> > > went to hell, he wouldn't need a translator." -LJ
> > >
> > > "I'll do that just now." -nico
> > >
> > > "Never trust a engineer that tatoo's his IP address on his arm,
> > > especially if its DHCP." - /.
> > >
> > >
> > >
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php   (the manual)
> > >http://lists.mysql.com/   (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
> >
> >
>
> --
> 
> Nico Darrow RHCE
> CEO DeckerNET LLC
> Network Engineer/Programmer
> email:[EMAIL PROTECTED]
> ph:706.254.2128
> 
>
> "The software said it worked with windows 95 or better, so I
> installed linux." - NA
>
> "I'm not saying Bill Gates is the devil, its just that if he ever
> went to hell, he wouldn't need a translator." -LJ
>
> "I'll do that just now." -nico
>
> "Never trust a engineer that tatoo's his IP address on his arm,
> especially if its DHCP." - /.
>
>
>


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

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 in slackware trouble

[bulls]

dear everybody,
i've got  error message when test ./mysqladmin -u root
-h my-host version, but if ./mysql -u root -p , it's
ok.how to solution?.
tank you

=


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

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

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

Re: Bug: mysql uses temp filesort instead of index

[Sinisa Milivojevic]

Ben Escoto writes:
> Hi, I think I found a bug in mysql.  I tried the mysqlbug thing but it
> didn't work right away.  I hope this message will be detailed enough.
> I am not subscribed to the mailing list.
> 
> In the following sections are the output of, respectively:
> 
> mysql -e "SHOW VARIABLES"
> mysqldump sqmail sequence_data
> mysql -e "EXPLAIN SELECT * FROM sqmail.sequence_data WHERE sid = 16
> ORDER BY sid desc,id desc LIMIT 10"
> 
> The output of the last command contains "Using filesort" when it seems
> like it shouldn't.
> 
> Variable_name Value
> ansi_mode OFF
> back_log  50
> basedir   /usr/
> bdb_cache_size8388600
> bdb_log_buffer_size   32768
> bdb_home  /var/lib/mysql/
> bdb_max_lock  1
> bdb_logdir
> bdb_shared_data   OFF
> bdb_tmpdir/tmp/
> bdb_version   Sleepycat Software: Berkeley DB 3.2.9a: (May  9, 2001)
> binlog_cache_size 32768
> character_set latin1
> character_setslatin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia 
>euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 
>swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620
> concurrent_insert ON
> connect_timeout   5
> datadir   /var/lib/mysql/
> delay_key_write   ON
> delayed_insert_limit  100
> delayed_insert_timeout300
> delayed_queue_size1000
> flush OFF
> flush_time0
> have_bdb  YES
> have_gemini   NO
> have_innodb   NO
> have_isam YES
> have_raid NO
> have_ssl  NO
> init_file 
> interactive_timeout   28800
> join_buffer_size  131072
> key_buffer_size   8388600
> language  /usr/share/mysql/english/
> large_files_support   ON
> locked_in_memory  OFF
> log   OFF
> log_updateOFF
> log_bin   OFF
> log_slave_updates OFF
> long_query_time   10
> low_priority_updates  OFF
> lower_case_table_names0
> max_allowed_packet1048576
> max_binlog_cache_size 4294967295
> max_binlog_size   1073741824
> max_connections   100
> max_connect_errors10
> max_delayed_threads   20
> max_heap_table_size   16777216
> max_join_size 4294967295
> max_sort_length   1024
> max_user_connections  0
> max_tmp_tables32
> max_write_lock_count  4294967295
> myisam_recover_optionsOFF
> myisam_max_extra_sort_file_size   256
> myisam_max_sort_file_size 2047
> myisam_sort_buffer_size   8388608
> net_buffer_length 16384
> net_read_timeout  30
> net_retry_count   10
> net_write_timeout 60
> open_files_limit  0
> pid_file  /var/run/mysqld/mysqld.pid
> port  3306
> protocol_version  10
> record_buffer 131072
> query_buffer_size 0
> safe_show_databaseOFF
> server_id 0
> skip_locking  ON
> skip_networking   OFF
> skip_show_databaseOFF
> slow_launch_time  2
> socket/var/lib/mysql/mysql.sock
> sort_buffer   2097144
> table_cache   64
> table_typeMYISAM
> thread_cache_size 0
> thread_stack  65536
> transaction_isolation READ-COMMITTED
> timezone  PDT
> tmp_table_size1048576
> tmpdir/tmp/
> version   3.23.38
> wait_timeout  28800
> # MySQL dump 8.14
> #
> # Host: localhostDatabase: sqmail
> #
> # Server version  3.23.38
> 
> #
> # Table structure for table 'sequence_data'
> #
> 
> CREATE TABLE sequence_data (
>   sid int(10) unsigned NOT NULL default '0',
>   id int(10) unsigned NOT NULL default '0',
>   PRIMARY KEY  (sid,id)
> ) TYPE=MyISAM;
> 
> #
> # Dumping data for table 'sequence_data'
> #
> 
> INSERT INTO sequence_data VALUES (1,1);
> INSERT INTO sequence_data VALUES (1,2);
> 
> table typepossible_keys   key key_len ref rowsExtra
> sequence_data ref sidid   sidid   4   const   1   where used; Using 
>index; Using filesort


Hi!

MySQL is still using filesort, because of "ORDER BY sid desc,id desc".

Simply, setting DESC disables usage of index ...

MySQL 4.0 will fix this, however 


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, 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

Re: Server Config wait_timeout

[Sinisa Milivojevic]

Gary Huntress writes:
> Hi,
> 
> I've started mysql with the parameter -O wait_timeout=1000 and verified
> that it is set using show variables.  Yet I routinely see lingering
> processes with times over 1100 and higher.  I have about 1000 active
> database users at the moment, most are connecting via php pages and I had
> been running out of connections.   I could have increased the number of
> connections, but I chose rather to lower the wait_timeout instead.
> 
> Should I be expecting timeouts in excess of 100 seconds beyond the value
> that I set?That is, is wait_timeout more of a guideline than a hard
> limit?
> 
> 
> Regards,
> Gary "SuperID" Huntress
> ===
> FreeSQL.org offering free database hosting to developers
> Visit http://www.freesql.org
> 


Hi!

wait_timeout is a time in seconds that connection will spend in
'Sleep' time only (!) before being killed by the server.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, 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

Re: Flakey mysqld under OpenBSD

[Sinisa Milivojevic]

Chris Cameron writes:
> Hi,
> 
> Seems I've never had any luck with MySQL and OpenBSD, and I'm hoping I can
> finally get some help now that I've finally got around to recompiling it
> again.
> 
> I'm running OpenBSD 2.7 and am compiling MySQL 3.23.38. I'm using the
> configure options;
> "CXXFLAGS="-O6 -march=i586" CFLAGS="-O6 -march=i586" ./configure
> --with-unix-socket-path=/var/mysq/mysql.sock --with-mysqld-user=mysql
> --without-debug --low-memory --without-docs --without-bench
> --without-readline "
> When it stops on sql_yacc.cc, I just compile that seperately and
> everything finishes nicely.
> 
> Now, when I do a 'make test', I get exactly this (I appologize for the
> wrapping):
> 
> lt-mysqltest: At line 1576: query 'select
> companynr,count(price),sum(price),min(price),max(price),avg(price) from t3
> group by companynr ' failed: 2013: Lost connection to MySQL server during
> query real   148.53 user 0.28 sys  0.44
> Aborting. To continue, re-run with '--force'.
> 
> Ending Tests
> Shutting-down MySQL daemon
> 
> lt-mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/usr/src/mysql-3.23.38/mysql-test/var/tmp/mysql-master.sock' (61)'
> Check that mysqld is running and that the socket:
> '/usr/src/mysql-3.23.38/mysql-test/var/tmp/mysql-master.sock' exists!
> master not cooperating with mysqladmin, will try manual kill
> ./mysql-test-run[781]: kill: 15515: No such process
> master refused to die. Sending SIGKILL
> ./mysql-test-run[781]: kill: 15515: No such process
> Master shutdown finished
> Slave shutdown finished
> *** Error code 1
> 
> Stop in /usr/src/mysql-3.23.38 (line 499 of Makefile).
> 
> Almost every version of MySQL I've ever run on this machine has given me
> the error "Lost connection to MySQL server". The last version I was
> running worked fine for about 50 days straight until that's all it'd print
> out without a refresh every half day (MySQL 3.23.35).
> 
> -Any- help on this would be appreciated as all my other calls for help
> have gone unanswered.
> 
> Thanks,
> Chris
> 
> 


Hi!

You should follow other instructions for OpenBSD found in our manual,
includein "-felide-constructors -fno-rtti -fno-exceptions".

Also use gcc 2.95.2 compiler.

Before running make test, run make install as a root.

Last but not least, read a chapter on how to setup socket file
location.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, 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

Re: Question for a MYSQL expert (I assume this list has some)...

[jaab]

Dear Kenneth,

did you ever consider looking at other technologies than the database
driven one? Javaspaces seems to me a very interesting solution for
handling distributed storage, and your case seems to be difficult to
handle from a database-centric point of view.

If you're interested, these urls might give you some pointers.

http://www.j-spaces.com/ (a commercial implementation)
http://java.sun.com/products/javaspaces/ (Sun's own site)

Of course, you can/will have to connect database servers to the space for
persistent storage, but the importance for the database, a complex piece
of software, to be perfectly tuned is completely gone in such a model.

Sincerely,
Jan

--
Mr. Jan-Aage Bruvoll IT Project Manager
20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich
Office/fax: +44 2072408283   Mobile: +44 7740291600


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

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

JOIN-problems

[Ville Mattila]

Hi again,

(Posting this once again because I didn't ever get this back from list server)

I have five tables in the database: customers, orders, ordercontents, products and 
payments. The problem is that I should get a list which shows some kind of a ledger 
list (shows who has paid and so on).

My first try looks like this:
SELECT orders.OrderID, customers.Name, SUM(ordercontents.Amount * products.Price) AS 
TotalSum, SUM(payments.PaidFIM) AS TotalPaid FROM orders
LEFT JOIN customers ON (customers.CustID = orders.CustID)
LEFT JOIN payments ON (payments.OrderID = orders.OrderID)
LEFT JOIN ordercontents ON (ordercontents.OrderID = orders.OrderID)
LEFT JOIN products ON (products.ProdID = ordercontents.ProdID)
WHERE orders.Cancelled=0 AND ordercontents.Removed=0;

That's it... I hope that you understood the structure. Also there should be noticed 
that the order can have many different products ordered (listed on ordercontents 
-table) and also that there can be many separated payments for same order.

Now this query works, but it doesn't return correct amounts for TotalPaid and TotalSum 
-columns.

Thanks for help,
- Ville Mattila, Ikaalinen, Finland




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

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: Question for a MYSQL expert (I assume this list has some)...

[Jeremy Zawodny]

On Fri, Jun 01, 2001 at 11:43:25AM -0700, Kenneth Kopelson wrote:
>
> Thank you Steve, I appreciate your response :) I have considered
> modifying MySQL to do what I have asked for, but I didn't want to do
> that until I verified it wasn't already available somewhere.  I'll
> bet this feature is something that others would be interested in as
> well.
> 
> On the note of what eBay and others are using, do you have a
> suggestion of a database that would do what we are wanting, and also
> be as efficient as MySQL is?

Oh, so you want to eat your cake, too? :-)

> I really like MySQL's many features like regular expressions in
> queries, the fact that you can easily retrieve the auto-increment
> value that was used on an INSERT (not an easy task on others DBs I
> have used), and many other features.

And don't forget it's lack of BLOAT.

> Perhaps an open-source project to add "shared DB" capabilities would
> be something worth starting.  I myself am a C++ developer with over
> 23 years experience, so maybe I can join with some others who are
> interested, and we can start a project.  If anyone on this list
> would be interested in discussing the possibilities of joining in
> such an effort, please let me know.

That'd be an appropriate dicussion to conduct over on the
mysql-internals list. The folks there would be glad to discuss how and
where you'd need to code the changes that you might need.

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

MySQL 3.23.29: up 8 days, processed 51,023,731 queries (67/sec. avg)

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

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

RE: HELP ME PLEASE:MySQL said: Got error 127 from table handler

[Don Read]

On 03-Jun-01 Derby wrote:
> Dear Everybody,
> 
> Today  I received the following error message in my web site (which
> is in php with mySql in UNIX environment), but it worked half a year
> until Today: 


 
> 
> MySQL said: Got error 127 from table handler 
> 
> I suppose too many records are in the table.
> 4216, but it shouldn't be the reason :-(,

Nope, it's not.

> and unfortunately I am not allowed to delete any record from the
> database, because the records contain the information about
> subscripted users.
> 
> 1, Do you know what can cause this error message?
> 2, What is the related exact error message text?
> 3, Where can I check the error message text, which related to error
> 127? 

yes, & yes.

localhost.dread$ perror 127
Error code 127:  Unknown error: 127
127 = Record-file is crashed

Something about your table is confused.

> 4, How can I solve this problem?

copy the table files to another directory, then in order of 
increasing panic:

A. try droping & rebuilding your keys.
B. mysqldump --add-drop-table DB da_table > tbl.dmp
   if it dumps ok, then mysql DB < tbl.dmp
C. run repair table ...
D. re-read the manual, shutdown the server
   & then run myisamchk -r ...
E. restore from backup.

> 5, Do I have to change the mySql query, but how? And what is the
> reason that it worked half a year until now?

No, it's a valid query. it worked for months, right ? 
Besides I've never heard of a query that would crash a table.

> 6, It should be some
change in php or UNIX, but what?

No changes, always shutdown the server properly, & you'll need to 
learn how to backup and restore.

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do 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: information needed

[Jeremy Zawodny]

On Sat, Jun 02, 2001 at 04:30:29PM +0200, Nimeesh Patel wrote:

>  i want to know is there any size limit(no. of rows) for mysql
> created table.  In my case table contain only four cloumn
> date,ip_address(varchar[20],tx_bytes(integer),rx_bytes(integer).  i
> want to maintain a huge database of this format.

How many billion rows do you need to store? :-)
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 8 days, processed 50,975,287 queries (67/sec. avg)

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

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

Re: Question for a MYSQL expert (I assume this list has some)...

[Jeremy Zawodny]

On Fri, Jun 01, 2001 at 10:00:01AM -0700, Kenneth Kopelson wrote:
>
> I am hoping there are people who use MySQL for serious business
> applications on this list.

We're occasionally serious here. Other times, it just depends on the
sort of mood that people seem to be in. :-)

(I just think it's dangerous to equate "expert" and "serious business"
given what I've seen at some companies...)

> HERE IS MY QUESTION:
> 
> I have need for multiple servers to share the same database files.

Instead of replication?

Folks have done that before. Often times they'll put the data files on
a Netapp and point a cluster of MySQL servers at it. It's VERY
important, of course, to have really fast (switched) network
connections between the MySQL servers and the Netapp.

> We are implementing a site that will have hundreds of thousands of
> users at the same time, so we need a large pool of Linux servers
> that are load-balanced.

That is a lot of users. How many simultaneous MySQL sessions to you
think that will equate to? Will you have some sort of connection
pooling at the application layer?

> Then, all these servers, each of which will run Apache and MySQL (or
> another database if MySQL just can't handle the load), needs to
> access the single large RAID disk array through a giga-bit network
> connection.

Why not separate the Apache servers from the MySQL servers? It would
seem to be easier to scale that way.

> Certainly, this is not uncommon, as any large database driven
> website needs to have a similar setup (like eBay, Microsoft, Apple,
> Amazon, etc.).

You'd be surprised. Some rather high-traffic sites have been able to
get away with a single monster database server that had lots of
clients talking to it. I don't know that should say who this
particular example is, but they managed to handle a lot of traffic
using this model with [gasp!] Oracle.

> The servers need to be setup in a cluster to provide the required
> high-availability.  Also, replication will NOT work, as we need
> changes to the database to be immediately available to everyone
> else, and managing 100 or more replicated databases would be a
> nightmare.

You're going to really need 100 servers?

> So, how do we get support in MySQL so that multiple instances of the
> mysqld daemon running on separate machines can all access the same
> database files located on a central server?  I can see how the file
> system of the central database server could be exported through NFS
> (or something similar) so that all the machines in the cluster can
> access the database files.  I also imagine the daemons would need to
> have some sort of locking mechanism to avoid stepping on each other.

You'll find a very brief mention of what you need to know here:

  http://www.mysql.com/doc/S/y/System.html

What this documentation doesn't say, however, is that this model
really only works with MyISAM tables. I'm pretty sure it doesn't do
you any good with InnoDB, BDB, or Gemini tables. And those are the
ones whith more granular locking and better performance in heavy
update situations.

If you can tolerate a small amount of latency in propogating updates,
you could have a single (very beefy) master server which only gets the
update queries and many slaves which you can load balance the read
queries across. The master probably ought to be a many-CPU Solaris or
Linux box, given the sort of loads you're talking about.

If you can keep the updates on a single server, you'd be able to use
InnoDB or Gemini tables, which should give you good update
performance.

Just some ideas...

[Grr. ispell just decided not to work right. Sorry for any horrible
spelling in this note...]

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

MySQL 3.23.29: up 8 days, processed 50,950,321 queries (67/sec. avg)

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

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

Re: Java/Linux Mysql JDBC?

[Nico D]

I've download the tar.gz file off of mysql.com, then I modified
the Makefile for the mm.mysql.jdbc program so that it pointed
to my java binary directory. When I run "make all" it gives
me about 50 or so errors (one included as attachment) but
basically consists of 

.PreparedStatement should be declared abstract; it does not define
addBatch() in org.gjt.mm.mysql.PreparedStatement

I'm running redhat 7.0 and redhat 7.1 on different boxes, both give the
same errors. I've also installed the Java 1.3 binaries and SDK from sun's
website. Java Standard Edition build 1.3.0

Thankx guys!

On Sun, 3 Jun 2001, Rohit Peyyeti wrote:

> Can you tell us what exactly you are not able get it to work? What
> error you are getting?
> 
> ...Rohit
> 
> - Original Message -
> From: Nico D <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, June 03, 2001 11:08 AM
> Subject: Java/Linux Mysql JDBC?
> 
> 
> > Can anyone out there tell me how to use java and JDBC to connect to a
> > MySQL db on a linux box, i've downloaded the api of the website but I
> > can't get it working correctly. Could someone send me some sample code
> > and/or tell me where to put the api and how to reference it?
> >
> > thankx alot!
> > -nico
> >
> > --
> > 
> > Nico Darrow RHCE
> > CEO DeckerNET LLC
> > Network Engineer/Programmer
> > email:[EMAIL PROTECTED]
> > ph:706.254.2128
> > 
> >
> > "The software said it worked with windows 95 or better, so I
> > installed linux." - NA
> >
> > "I'm not saying Bill Gates is the devil, its just that if he ever
> > went to hell, he wouldn't need a translator." -LJ
> >
> > "I'll do that just now." -nico
> >
> > "Never trust a engineer that tatoo's his IP address on his arm,
> > especially if its DHCP." - /.
> >
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> 
> 

-- 

Nico Darrow RHCE
CEO DeckerNET LLC
Network Engineer/Programmer
email:[EMAIL PROTECTED]
ph:706.254.2128


"The software said it worked with windows 95 or better, so I
installed linux." - NA

"I'm not saying Bill Gates is the devil, its just that if he ever
went to hell, he wouldn't need a translator." -LJ

"I'll do that just now." -nico

"Never trust a engineer that tatoo's his IP address on his arm,
especially if its DHCP." - /.




org/gjt/mm/mysql/PreparedStatement.java:54: org.gjt.mm.mysql.PreparedStatement should 
be declared abstract; it does not define addBatch() in 
org.gjt.mm.mysql.PreparedStatement
public class PreparedStatement extends org.gjt.mm.mysql.Statement



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

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

HELP ME PLEASE:MySQL said: Got error 127 from table handler

[Derby]

Dear Everybody,

Today  I received the following error message in my web site (which is in php with 
mySql in UNIX environment), but it worked half a year until Today: 

Database allasajanlat 
Error 
SQL-query: 

SELECT TEHinserted, INFfoglalkozas, KEPmihezertek, KEPszakvizsgak, id FROM onelet 
WHERE TEHinserted >= '' AND (ELEemail != '' OR ELEurl != '' OR ELEtel != '' OR 
ELEfax != '') OR (INFfoglalkozas != '' OR KEPmihezertek != '' OR KEPszakvizsgak != '') 
ORDER BY TEHinserted DESC; 

MySQL said: Got error 127 from table handler 

I suppose too many records are in the table.
4216, but it shouldn't be the reason :-(,
and unfortunately I am not allowed to delete any record from the database, because the 
records contain the information about subscripted users.

1, Do you know what can cause this error message?
2, What is the related exact error message text?
3, Where can I check the error message text, which related to error 127? 
4, How can I solve this problem?
5, Do I have to change the mySql query, but how? And what is the reason that it worked 
half a year until now?
6, It should be some change in php or UNIX, but what?

Thank you very very much for your help in advance 
Derby


_
6 MB ingyen email [EMAIL PROTECTED] ---> 
http://www.allasajanlat.hu

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

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