date:20010521


Well... I installed mysql in my D: drive (at home) and it works perfectly. I 
set in the control panel/services to have mysql started automatically when 
the server is started.

When I want to access it direct I just go to D:\Program Files\mysql\bin and 
type mysql.

Yesterday I tested a cgi script appending rows to a table and it worked good 
until I decided to install Oracle driver.

However in my job I installed first at C:, then at E: and then when I 
deleted the C: one I found problem trying to access the one that was in E:.

At home I never got this issue because the first time I installed at D:.

There is a note in mySQL guide that says that you should install it first at 
C: then move it to anotehr drive and the always start it making reference to 
the first location. Sorry I don't remember it exactly but the warning is in 
the manual. However I never followed this warning and at home it works 
perfectly.

Siomara


From: LE GAC [EMAIL PROTECTED]
Reply-To: LE GAC [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Installing mysql on another directory than c: with windows
Date: Mon, 21 May 2001 08:21:13 +0200

I can't manage to have an acces to my database with mysql installed on E: 
on a windows Nt server.
What can I do ?
Thanks

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


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

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

RE: my sql database and locking issues(URGENT)

2001-05-21 Thread Warren van der Merwe


 2.
 The following is the extract from mysql documentation:
 
 In MySQL Version 3.23.7 and above, you can insert rows
 into MyISAM tables at the same time other threads are
 reading from the table. Note that currently this only
 works if there are no holes after deleted rows in the
 table at the time the insert is made. 
 
 ACTUALLY,VERSION 3.23.7 IS NOT RELEASED.ARE THESE THE
 EXPECTED FEATURES IN THE COMING VERSION?
 

3.23.7 is long gone!   we know on 3.23.38

 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
 
 
 

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

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: The Syntax to Get JDBC Connection


I usually create a txt file like the following (I used Oracle but you can 
change to mysql stuffs):

jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.driverType=jdbc:oracle:thin:@
jdbc.host=prokids
jdbc.port=1521
jdbc.sid=orcl
jdbc.username=scott
jdbc.password=tiger


Then I have a manager class (such as CustomerManager or ProductManager,  
whatever) establhishing connection like the following:


cont...
  /
   * Establish a connection with the database
   /
  public void connectDB() {
try {
  Properties props = new Properties();
  FileInputStream dbPropFile = new 
FileInputStream(DBHomeProperties.txt);
  props.load(dbPropFile);
  this.dbConnection = new DBConnection(props.getProperty(jdbc.driver),
  props.getProperty(jdbc.driverType), props.getProperty(jdbc.host),
  props.getProperty(jdbc.port), props.getProperty(jdbc.sid),
  props.getProperty(jdbc.username), 
props.getProperty(jdbc.password));

} catch (Exception e) {
System.out.println(e);
}
  }


OR you can set it directly like:


  this.dbConnection = new DBConnection 
(oracle.jdbc.driver.OracleDriver,
jdbc:oracle:thin:@,prokids,1521, orcl,
scott, tiger);


And then in my DBConnection class I got the following:

/**
* Copyright (c) 2000 Objectry.com
* File Name:   DBConnection.java
* @dateOctober 2001
* @author  Siomara Pantarotto
* Description: Definition of DBConnection class.This class is
*  design to access Oracle database via drivers and
*  to acces SQL Server database via ODBC bridge.
**/

import java.io.*;
import java.sql.*;
import java.util.*;

public class DBConnection implements Serializable
{
  private Connection conn;
  private Statement stmt;
  private String driver;
  private String driverType;
  private String host;
  private String port;
  private String sid;
  private String username;
  private String password;

  
/
  // Constructors
  //

  // No argument constructor for Java Bean requirement
  public DBConnection() {
  }
  // For accessing Oracle via drivers
  public DBConnection(String driver, String driverType,
  String host, String port, String sid,
  String username, String password) {
setDriver(driver);
setDriverType(driverType);
setHost(host);
setPort(port);
setSid(sid);
setUsername(username);
setPassword(password);
connect();
  }
  // For accessing SQL Server via ODBC
  public DBConnection(String driver, String driverType) {
setDriver(driver);
setDriverType(driverType);
setHost();
setPort();
setSid();
setUsername();
setPassword();
connect();
  }

  
/
  // Establish connection to the database
  //
  public void connect() {
String url;
url = getDriverType();

if (getHost().length()  0) { url = url + getHost(); }
if (getPort().length()  0) { url = url + : + getPort(); }
if (getSid().length()  0)  { url = url + : + getSid();  }
System.out.println(url);
try {
Class.forName(driver);
}
catch(Exception e) {
System.err.print(ClassNotFoundException: );
System.err.println(e.getMessage());
}
try {
this.conn = DriverManager.getConnection(url,username, 
password);
this.stmt = conn.createStatement();
}
catch(SQLException ex) {
System.err.println(SQLException:  + ex.getMessage());
}
  }

  
/
  // Disconnect from the database
  //
  public void disconnect() {
try {
  this.stmt.close();
this.conn.close();
}
catch(SQLException ex) {
System.err.println(SQLException:  + ex.getMessage());
}
  }

  
/
  // Get connection
  //
  public Connection getConnection() {
  return conn;
  }

  
/
  // Get statement
  //
  public Statement getStatement() {
  return stmt;
  }

  
/
  // Set and get DRIVER attribute
  //
  public void setDriver(String newDriver) {
this.driver = newDriver;
  }
  public String getDriver() {
return driver;
  }

  
/
  // Set and get DRIVER TYPE attribute
  //
  public

table corruption during large import.

2001-05-21 Thread Larry Hotchkiss


I am having a heck of a time here. Im running RH 7.0 kernel 2.2.16 on a 
PII 300, 128meg RAM. Mysql 2.23.32, php 4.04. I have a DB set up that has 4 
tables. 3 of the four only have a couple thousand records, but one table 
will have somewhere between 80k to maybe as many as a million records.

The DB is a backend for a dynamic site and I have scripts to allow the 
uploading of files. These files are CVS and are handled by php scripts. 
Every night I plan on having a cron job run a script to copy the files to a 
working directory, deleting the originals and then processing the files one 
at a time, line by line and inserting them into the table in question. 
During testing I am using a data file that has 481 records. To mimick real 
scenario, I simply copy the file giving it a bunch of new names, but the 
content is identicle. Then I run my script to import the data. Everything 
seems fine upto about 200k records. After that things seems to go awry. At 
about 400k records the import runs fine, no erros and running CHECK TABLE 
shows no problems, however, if I try to do a select, I get an error 127. If 
I up the import to ver 1 million records for testing purposes my script 
actually aborts with error 127 and check table reports corruption.

I thought perhaps it was a bug so updated via the RH RPM to mysql 3.23.36. 
I still have the same problem and my performance on small tables seems 
greatly reduced. Does anyone have any ides why this at moderat record 
counts I get thie error even though check table reports no problems? And 
why does my script abort with a corrupt table when I break 1 million 
records?

P.S. I am no where close to OS file limitations, at 1.1 million records, my 
table is about 60 meg.

-
Larry Hotchkiss



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

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: which db server

2001-05-21 Thread Steve Brazill


Can you give more info on what type of system this is ??

Is this really a 'server' type machine,  or an HP Vectra PC ??  (of the
'XU' series ?)

Does it have the onboard SCSI controller (what size drives,  and are they
SCSI drives ?)
   - If they're SCSI,  you might want to get 4 drives,  and mirror the first
2 for the O/S and Program installations (and maybe the 'temp' spaces), and
the 2nd pair for the data partitions.

What type of network card(s) are you installing ??  (HP usually provides
crappy versions of 3com cards)

What O/S will you be installing on it ??
- If Linux,  have you tested the 2.4.x kernel to make sure that the SMP
kernel is compatible with the machine (on my ALR board,  I had to change the
SMP 'spec' to 1.1 from 1.4 to avoid crashing).

I myself have a couple of HP Vectra's running Redhat (6.2) on them.  But
they're 'small' installations, mainly serving as 'firewall/gateway' systems
with small implementations of Apache and stuff for home.  The one thing I
make sure of,  is that I have at least 2 drives installed, in order to
'mirror' the drive contents.

- Original Message -
From: Jacob Friis Larsen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 3:16 AM
Subject: which db server


 We are currently running a website witch both takes care of the database
and
 the application.

 We will buy a HP server, which will only be used as a db server.

 It will probably be a dual PIII 800mhz with 512mb ram and 3 physical
disks.
 We have the option of changing this a bit.

 What would give us the best performance ?
 More ram : how much ?
 more CPU's ?
 Any comments ?

 Please help us choose the right server.

 Best regards Jacob


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

 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: table corruption during large import.

2001-05-21 Thread Steve Brazill


Do you 'refresh' your tables before each test ?  If so,  is it possible that
you're writing over the same disk space each time (which would point to a
drive surface problem).   Is it possible that the larger runs of 'inserts'
are using more RAM than the smaller tests, and you're hitting a bad memory
chip ?

Are you running the tests at 'full speed',  and are your drives setup to
handle high levels of 'writes' ?  (are they 'striped' or are you writing to
1 disk ?)

- Original Message -
From: Larry Hotchkiss [EMAIL PROTECTED]
To: 'MySQL List' [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 10:05 AM
Subject: table corruption during large import.


 I am having a heck of a time here. Im running RH 7.0 kernel 2.2.16 on a
 PII 300, 128meg RAM. Mysql 2.23.32, php 4.04. I have a DB set up that has
4
 tables. 3 of the four only have a couple thousand records, but one table
 will have somewhere between 80k to maybe as many as a million records.

 The DB is a backend for a dynamic site and I have scripts to allow the
 uploading of files. These files are CVS and are handled by php scripts.
 Every night I plan on having a cron job run a script to copy the files to
a
 working directory, deleting the originals and then processing the files
one
 at a time, line by line and inserting them into the table in question.
 During testing I am using a data file that has 481 records. To mimick real
 scenario, I simply copy the file giving it a bunch of new names, but the
 content is identicle. Then I run my script to import the data. Everything
 seems fine upto about 200k records. After that things seems to go awry. At
 about 400k records the import runs fine, no erros and running CHECK TABLE
 shows no problems, however, if I try to do a select, I get an error 127.
If
 I up the import to ver 1 million records for testing purposes my script
 actually aborts with error 127 and check table reports corruption.

 I thought perhaps it was a bug so updated via the RH RPM to mysql 3.23.36.
 I still have the same problem and my performance on small tables seems
 greatly reduced. Does anyone have any ides why this at moderat record
 counts I get thie error even though check table reports no problems? And
 why does my script abort with a corrupt table when I break 1 million
 records?

 P.S. I am no where close to OS file limitations, at 1.1 million records,
my
 table is about 60 meg.

 -
 Larry Hotchkiss



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

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



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

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

mysql crash continued

2001-05-21 Thread Rui Barreiros



hi,

i've upgraded mysql server with 3.23.38 from mysql, and i have the same 
behaviour sinisa if you have some time i could give you access to one of the 
machines. :/

-- 
WEBSOLUT - Soluções Internet
Emailto: [EMAIL PROTECTED] 
Personal Info: http://websolut.net/people/rui.html

As informações contidas neste email são confidenciais
e destinam-se apenas à(s) pessoa(s) a quem foi enviado:
http://websolut.net/confidencialidade-responsabilidade.html

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

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

Re: mysql crash continued

2001-05-21 Thread Sinisa Milivojevic


Rui Barreiros writes:
 
 hi,
 
 i've upgraded mysql server with 3.23.38 from mysql, and i have the same 
 behaviour sinisa if you have some time i could give you access to one of the 
 machines. :/
 
 -- 
 WEBSOLUT - Soluções Internet
 Emailto: [EMAIL PROTECTED] 
 Personal Info: http://websolut.net/people/rui.html
 


Are tables OK ?? Corrupted tables can still crash sometimes MySQL.

If they are and that query or combination of queries always crashes
mysql, then please mail to the [EMAIL PROTECTED] so that we may
advise you where to upload your tables and queries that always crashes
MySQL.

Thank you in advance.


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: Results came from

2001-05-21 Thread Carl Schrader




Is there anyway to determine which part of the an sql query where blahblah
produced
the result?
ie. select Title from inv where Title LIKE '%Green' OR Title Like
'%Blue%'
I need to distinguish if the Title was like Green or Blue..



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

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: users and passwords...users and passwords...

2001-05-21 Thread Mark Rowlands


/mysql/bin/mysql_setpermission   can also be handy

but if you do stuff manually don't forget to do a 

/mysql/bin/mysqladmin flush-privileges


a bit of manual reading probably wouldn't go amiss either :-)



On Monday 07 May 2001 07:54, Daniel Goldin \(E-mail\) wrote:
 I've had similiatr problems setting passwords on my redhat box.

 Tried % mysql -p -u root mysql:

   Got error message:

   Access denied for user root@localhost (using password:YES)

 Help, please!!!

 -Original Message-
 From: Paul DuBois [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, May 06, 2001 6:36 PM
 To: Simon Chan; mysql Mail List
 Subject: Re: users and passwords...users and passwords...

 At 12:16 PM -0700 5/6/01, Simon Chan wrote:
 NEWBIE QUESTION
 Hello,
 
 Just installed mysql on a solaris2.7 sparc machine, but I don't seem
 to have permission to do
 anything!  I add a user by typing
 
 useradd username

 That creates a UNIX user account, not a MySQL user account.  They have
 nothing
 to do with each other.

 To create a MySQL user (and set the password), use the GRANT statement
 in the mysql program:

   % mysql -p -u root mysql

 Then enter the MySQL root user password when prompted and execute your
 GRANT statements.  See the MySQL Reference Manual for GRANT syntax.

 BUT HOW DO I SET THE PASSWORD?  Someone suggested doing this:
 
 mysqlinsert into user (host, user, password) values ('localhost',
 'myname' password('testpass');
 
 
 But that doesn't work for me!  It gives me the good ol' syntax error
 message.  I've also tried
 this:
 
 mysql insert into user (host, user, password) values ('localhost',
 'myname','testpass');
 
 
 But that gives a message saying that no database selected.
 
 Help!



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

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

question about replication under version 3.23.38 for Unix (database)

2001-05-21 Thread Joseph Chow


HI, everyone,

I met a problem about setting up replication(master/slave) of mysql sever on unix 
boxes.

Mysql servers are installed under /usr/local/ on master and slave and they can be 
run under /usr/local/mysql/bin.

It seems to me that I have three choices where to put my configuration files, my.cnf, 
after I modify them for master and slave respectively .
1)   /etc/my.cnf  (global options)
2)  DATADIR/my.cnf (Sever-specific option)
2)  ~/.my.cnf (User-specific option)

I have already tried all the three options, but only the first one worked.
For sever-specific option, DATADIR that I choose to use is /data/mysql on my unix.  
And for User-specific option, I have tried my home directory /home/joseph.
For either of these two cases, it is obvious that mysql server didnot read the 
modified configuration under these two directories, because I tried show master 
status and show slave status and find nothing happened.

Anyone can answer why and how to work it out under last two cases?

thank you,

Joseph

key_reads and opened_tables.

2001-05-21 Thread Larry Hotchkiss


In the manual, it states if Key_reads is big, then your key_cahce is 
probably too small.so what exactly is BIG???

Same thing for opened_tables, it states if opened_tables is big then your 
then your table_cache variable is probably too small. Can someone please 
define BIG

Im just using a default RH 7.1 install of mysql 3.23.36, no tweaks as of 
yet. PII 300 has 128 meg of RAM. My current opened_tables is 69 and my 
key_reads is 210251. My current db consists of 4 small tables.


-
Larry Hotchkiss



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

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 access to MySQL with MySQLGUI on Win32

2001-05-21 Thread Nicolas Verhaeghe


I am trying to see if I can communicate with a MySQL on Free BSD from the
MySQL GUI client on my Windows NT.

The GUI client cannot connect because the MySQL seems to be refusing this
connection. This does not seem to be server-related, but related to MySQL
itself, since, when I try to telnet in port 3306 on that server, I got the
error message:

Host my FQDN is not allowed to connect to this MySQL server

Do I have to modify something in the configuration file in that MySQL? And
where is that file on the FreeBSD install?

Thanks a lot if you can help!


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

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

Re: Results came from


What language are you using to prepare that query?

If it's perl, do something like if ($title =~ /Green/)
If it's php, do something like if (ereg(Green,$title))
If it's C, cycle the string finding that

This is a job for the client truthfully...but if you absolutly MUST do this
server side, here is your query:
select Title, IF(Title LIKE '%Green','Green','Blue') AS whatmatch

- Original Message -
From: Carl Schrader [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 10:56 AM
Subject: Re: Results came from


 

 Is there anyway to determine which part of the an sql query where blahblah
 produced
 the result?
 ie. select Title from inv where Title LIKE '%Green' OR Title Like
 '%Blue%'
 I need to distinguish if the Title was like Green or Blue..



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

 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

count(*) on different tables

2001-05-21 Thread Ansgar Becker


Hi,

is it possible to get *one* quick result with the rowcount of each table in
one database, without knowing the column-names?

this does *not* work:
 select count(t1.*), count(t2.*)
   from table1 t1, table2 t2

Manual doesn't say anything about that.

Greetings,
Ansgar Becker





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

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: Results came from

2001-05-21 Thread Carl Schrader


Eric,

I'm using php. The problem is that the where may have 100 or so conditions. I
was hoping that mysql had some built in function or variable that would return
this for me. I guess I'll have to code it in php.. argh.


Eric Fitzgerald wrote:

 What language are you using to prepare that query?

 If it's perl, do something like if ($title =~ /Green/)
 If it's php, do something like if (ereg(Green,$title))
 If it's C, cycle the string finding that

 This is a job for the client truthfully...but if you absolutly MUST do this
 server side, here is your query:
 select Title, IF(Title LIKE '%Green','Green','Blue') AS whatmatch

 - Original Message -
 From: Carl Schrader [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, May 21, 2001 10:56 AM
 Subject: Re: Results came from

  
 
  Is there anyway to determine which part of the an sql query where blahblah
  produced
  the result?
  ie. select Title from inv where Title LIKE '%Green' OR Title Like
  '%Blue%'
  I need to distinguish if the Title was like Green or Blue..
 
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  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

C API; queries within functions.

2001-05-21 Thread Seth Northrop



Hi!

This is probably more of a C inadequacy than a MySQL problem.  I'm playing
around with C with MySQL (I have to date only interfaced with it in
PHP) and I was curious if anyone had any example code which illustrates
how you would write functions which return mysql data.

For example, in PHP I might write a simple function  like this:

function get_specific_db_column($dbname, $tblname, $pk, 
$pk_val, $colname)
{

  $sql = SELECT $colname as val
FROM $dbname.$tblname
   WHERE $pk = '$pk_val';
  $r = mysql_query($sql);
  while ($row = mysql_fetch_array($r))
$array[] = $row;
  return $array;

}

But, in C I haven't figured out how to do things like navigate passing the
MYSQL *mysql init pointer into the function for mysql_query etc.

I can however get a program WITHOUT functions (ie, hardcode the
query) compiled and working:

// Simple test application
// for the C Mysql API

#include sys/time.h
#include stdio.h
#include mysql.h

#define def_host_name NULL
#define def_user_name root
#define def_password  NULL
#define def_db_name reflectivity

int main (char **arg)
{

  MYSQL_RES *result;
  MYSQL_ROW row;
  MYSQL *connection, mysql;
  int state;
  char colsize=10, rowsize=10;

  // connect to the mysql database on internal
  mysql_init(mysql);
  connection = mysql_real_connect(mysql, def_host_name,
 def_user_name,
 def_password,
 def_db_name,
 0, /*port defaut*/
 NULL,  /*socket default*/
 0);/*flag*/
  if (connection == NULL) // check for a connection error
  {
// print the error message
printf(mysql_error(mysql));
return 1;
  }
  state = mysql_query(connection,SELECT * from reflectivity.accounts);
  if (state != 0)
  {
printf(mysql_error(connection));
return 1;
  }
  // you must call mysql_store_result before we can issue anything else
  result = mysql_store_result(connection);
  printf(Rows: %d\n, mysql_num_rows(result));
  // process each row in the result set
  while ((row = mysql_fetch_row(result)) != NULL)
printf(%s - %s - %s - %s - %s\n,row[0],row[1],row[2],row[3],row[4]);
  // free some memory
  mysql_free_result(result);
  // close the mysql connection
  mysql_close(connection);
  printf(Done.\n);
}

Ny guess is that if I just see a couple of examples which mimic some of
the functionality of the above PHP function in C I'll be able to write
them without a problem.  

Any pointers on where to look?

Thanks!
Seth


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

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

Compute SQL Function Not Supported

2001-05-21 Thread Brandon Lewis


I take it the Computer SQL Function is not support by MySQL and if not is
there a substitute for it?

If you are unfamiliar with the command it works like this:

SELECT type, price
FROM products
ORDER BY type
COMPUTE SUM(price)

You will get a summary of prices by type in your results.

set options (not at safe_mysqld at startup)

2001-05-21 Thread Brian Warn


Hello All,

Is there some way, when mysql server is running, to change an option?  I want to 
change skip_networking to OFF without doing a server restart.

Thanks,
Brian

Fastest query ?

2001-05-21 Thread Jocelyn Fournier


Hi,

I wonder which of the following queries is faster :

$result=mysql_query(SELECT lastauteur FROM forum ORDER BY date DESC LIMIT 1);

or :

$max=mysql_query(SELECT max(date) FROM forum);
list($max)=mysql_fetch_row($max);
$result=mysql_query(SELECT lastauteur FROM forum WHERE date='max');

(column date is declare as datetime, and is a non unique index)

Any idee ?

Thanks,

Jocelyn Fournier
Presence-PC
www.presence-pc.com

Re: count(*) on different tables

2001-05-21 Thread Cal Evans


If you are using PHP (or anothe controlling language, you could take the
results of  SHOW TABLES and loop through it either doing a single select for
each table or building a select statement that UNIONs the results together.
i.e.

Select 'Table1' as tableName, count(*) as rowCount from table1
UNION
Select 'Table2' as tableName, count(*) as rowCount from table2
...
etc

Assuming that MySQL can use the UNION clause. (I haven't checked)

My DBA says that in MS T/SQL you can do this:

select  solcount = count( distinct s.solKey ), probcount = count( distinct
p.probKey )
from  sol s, prob p

where SOL and PROB are tables.

HTH,
Cal
http://www.calevans.com

- Original Message -
From: Ansgar Becker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 1:18 PM
Subject: count(*) on different tables


 Hi,

 is it possible to get *one* quick result with the rowcount of each table
in
 one database, without knowing the column-names?

 this does *not* work:
  select count(t1.*), count(t2.*)
from table1 t1, table2 t2

 Manual doesn't say anything about that.

 Greetings,
 Ansgar Becker





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

 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: CPU usage running mysql

2001-05-21 Thread Nemholt, Jesper Frank

 -Original Message-
 From: David Allen [mailto:[EMAIL PROTECTED]]
 Sent: lunes, 21 de mayo de 2001 14:36
 To: Simon Green; [EMAIL PROTECTED]
 Subject: Re: CPU usage running mysql

 Hello again!

 Do you know if there is any way I can see what the mysqld is 
 doing? If it is
 taking up 99% of the processor time, it is very busy doing 
 something! I
 installed the binary version and consequently only have the 
 tools available
 which came with that distribution.

First of all, compare with supported tools such as vmstat or ps to ensure
that top is correct. vmstat will not show the process itself but just total
usertime, systemtime and idletime.

You can also use Symbel ( www.setoolkit.com ), but I've experienced a bug in
this too related to cpu/process info on Solaris 6, 7 and possible also 8.
This is in all recent releases (3.0 - 3.2) and is present in toptool.se,
aw.se and infotool.se.

Tools in Symbel that will work and give you some info about mysqld is
/opt/RICHPse/examples/pea.se this however tends to loop if you pipe the
output to awk or another program. That's another bug ;-)

For default debugging tools shipped with a standard Solaris go to
/usr/proc/bin :

# ls -al /usr/proc/bin  
total 30
drwxr-xr-x   2 root bin  512 Dec 31 20:25 .
drwxr-xr-x   3 root bin  512 Dec 31 20:25 ..
lrwxrwxrwx   1 root root  15 Dec 31 20:25 pcred -
../../bin/pcred
lrwxrwxrwx   1 root root  16 Dec 31 20:25 pfiles -
../../bin/pfiles
lrwxrwxrwx   1 root root  16 Dec 31 20:25 pflags -
../../bin/pflags
lrwxrwxrwx   1 root root  14 Dec 31 20:25 pldd - ../../bin/pldd
lrwxrwxrwx   1 root root  14 Dec 31 20:25 pmap - ../../bin/pmap
lrwxrwxrwx   1 root root  14 Dec 31 20:25 prun - ../../bin/prun
lrwxrwxrwx   1 root root  14 Dec 31 20:25 psig - ../../bin/psig
lrwxrwxrwx   1 root root  16 Dec 31 20:25 pstack -
../../bin/pstack
lrwxrwxrwx   1 root root  15 Dec 31 20:25 pstop -
../../bin/pstop
lrwxrwxrwx   1 root root  15 Dec 31 20:25 ptime -
../../bin/ptime
lrwxrwxrwx   1 root root  15 Dec 31 20:25 ptree -
../../bin/ptree
lrwxrwxrwx   1 root root  15 Dec 31 20:25 pwait -
../../bin/pwait
lrwxrwxrwx   1 root root  14 Dec 31 20:25 pwdx - ../../bin/pwdx

There are man pages for all of them. They all give useful information about
what a given process is doing.

You can also use truss.

...ofcourse you can also get some info from MySQL itself with show
processlist

--  
Un saludo / Venlig hilsen / Regards

Jesper Frank Nemholt
Unix System Manager
Compaq Computer Corporation

Phone : +34 699 419 171
E-Mail: [EMAIL PROTECTED] 

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

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

Re: C API; queries within functions.


 Any pointers on where to look?

That line says it all really.  Your initiallizing connection as a pointer
(denoted by *), you have to treat it accordingly when passing it to
functions.  Your function init would look something like this:

MYSQL_RES doquery (MYSQL *connection, char query[100]) {
int state;
MYSQL_RES *result;
state = mysql_query(connection,query);
if (state != 0) {
printf(mysql_error(connection));
return NULL;
}
result = mysql_store_result(connection);
return result;
}

then, in your code, you would connect like normal, then call the function
like this:
MYSQL_RES *result;

result = doquery(connection, query);
- Original Message -
From: Seth Northrop [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 12:25 PM
Subject: C API; queries within functions.



 Hi!

 This is probably more of a C inadequacy than a MySQL problem.  I'm playing
 around with C with MySQL (I have to date only interfaced with it in
 PHP) and I was curious if anyone had any example code which illustrates
 how you would write functions which return mysql data.

 For example, in PHP I might write a simple function  like this:

 function get_specific_db_column($dbname, $tblname, $pk,
 $pk_val, $colname)
 {

   $sql = SELECT $colname as val
 FROM $dbname.$tblname
WHERE $pk = '$pk_val';
   $r = mysql_query($sql);
   while ($row = mysql_fetch_array($r))
 $array[] = $row;
   return $array;

 }

 But, in C I haven't figured out how to do things like navigate passing the
 MYSQL *mysql init pointer into the function for mysql_query etc.

 I can however get a program WITHOUT functions (ie, hardcode the
 query) compiled and working:

 // Simple test application
 // for the C Mysql API

 #include sys/time.h
 #include stdio.h
 #include mysql.h

 #define def_host_name NULL
 #define def_user_name root
 #define def_password  NULL
 #define def_db_name reflectivity

 int main (char **arg)
 {

   MYSQL_RES *result;
   MYSQL_ROW row;
   MYSQL *connection, mysql;
   int state;
   char colsize=10, rowsize=10;

   // connect to the mysql database on internal
   mysql_init(mysql);
   connection = mysql_real_connect(mysql, def_host_name,
  def_user_name,
  def_password,
  def_db_name,
  0, /*port defaut*/
  NULL,  /*socket default*/
  0);/*flag*/
   if (connection == NULL) // check for a connection error
   {
 // print the error message
 printf(mysql_error(mysql));
 return 1;
   }
   state = mysql_query(connection,SELECT * from reflectivity.accounts);
   if (state != 0)
   {
 printf(mysql_error(connection));
 return 1;
   }
   // you must call mysql_store_result before we can issue anything else
   result = mysql_store_result(connection);
   printf(Rows: %d\n, mysql_num_rows(result));
   // process each row in the result set
   while ((row = mysql_fetch_row(result)) != NULL)
 printf(%s - %s - %s - %s - %s\n,row[0],row[1],row[2],row[3],row[4]);
   // free some memory
   mysql_free_result(result);
   // close the mysql connection
   mysql_close(connection);
   printf(Done.\n);
 }

 Ny guess is that if I just see a couple of examples which mimic some of
 the functionality of the above PHP function in C I'll be able to write
 them without a problem.

 Any pointers on where to look?

 Thanks!
 Seth




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

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

Re: count(*) on different tables


Well ...

I don't know enough about mysql but it must allow you somehow to specify the 
column by number as in Oracle and other DBs

SQL select count(*) from product;

  COUNT(*)
--
10

SQL select count(1) from product;

  COUNT(1)
--
10

Once you just want to count the rows the performance of your select will be 
much better if you specify a column rather than *.

Siomara


From: Ansgar Becker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: count(*) on different tables
Date: Mon, 21 May 2001 20:18:35 +0200

Hi,

is it possible to get *one* quick result with the rowcount of each table in
one database, without knowing the column-names?

this does *not* work:
  select count(t1.*), count(t2.*)
from table1 t1, table2 t2

Manual doesn't say anything about that.

Greetings,
Ansgar Becker





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

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


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


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

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

MYSQL performance question

2001-05-21 Thread Shane Anderson


I would like to know the limitations of Mysql with extremely large tables. I
need to store 20+ million records. Each record would contain only 4-6 fields
and would not be longer than 128 bytes of information. The records could be
divided among several tables, but at what size is the performance hindered
enough to need to split records between several smaller tables? Any
information leading to an optimal solution would be greatly appreciated.
Thanks
Shane Anderson
Software Developer
Web Accessibility in Mind - http://www.WebAIM.org


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

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

Problems with MySQL and Poweredge 6450..

2001-05-21 Thread Cody Swanson

Hey,

We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our intention
is to move the database off a smaller machine and load it into this one. We
currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 with kernel
2.4.4. This is on a dual PIII650 with 1 gig of ram and it runs fine. Here is a
copy of a status readout in mysql:

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

Connection id: 232107
Current database:
Current user: root@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.38
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset:latin1
Server characterset:latin1
UNIX socket:/tmp/mysql.sock
Uptime: 1 day 19 hours 23 min 39 sec

Threads: 55 Questions: 70609984 Slow queries: 15 Opens: 203 Flush tables: 1
Open tables: 155 Queries per second avg: 451.994

As you can see we have quite a load on this poor machine, this is why we wanted
to move to a bigger badder machine so we could push more out of MySQL. Anyway,
as mentioned before, our machine is a Poweredge 6450 with 4 Xeon 750mhz
processors and 4gb of ram. We also have a dell 4 channel PercRaid card that does
a raid 5 onto 4 36gb scsi disks. So we loaded Mysql 3.23.38 onto the machine
with no extra tweeks, just with the raw install from dell, setup the Innobase
driver and imported our data. Once we moved the site onto the new server
everything worked great, we could do super heavy queries in no time, it was
great! Then a day later I was looking at the .err log and noticed that MySQL had
crashed several times! Each time it crashes it restarts itself and the innobase
tables fix themselves. Innobase is verry cool! But this is a real problem!

So I took the .err file and parsed the stack trace against the symbol file for
mysql like the manual says. Here is a copy of the .err file with the stack dump
from one crash. This one is from kernel 2.4.3:

mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died.
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x81c508a
0x80f4ca5
0x80f44d4
0x80f823e
0x80f4021
0x80caee6
0x80c4a2d
0x809bdbf
0x8097de1
0x8097522
0x8098177
0x80abede
0x8084967
0x80877fd
0x8082ba9
0x80820d6
Stack trace successful, trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd-query at 0xb91044a8 is invalid pointer
thd-thread_id = 6230
Successfully dumped variables, if you ran with --log,
take a look at the details of what thread 6230 did to cause the crash.
In some cases of really bad corruption, this value may be invalid
Please use the information above to create a repeatable
test case for the crash, and send it to [EMAIL PROTECTED]

Number of processes running now: 0
010516 15:55:52 mysqld restarted
InnoDB: 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 2512947858
InnoDB: Doing recovery: scanned up to log sequence number 0 2512963

Here is the results of running stackresolve:

[root@cobalt /tmp]# /usr/local/mysql/bin/resolve_stack_dump -s /tmp/mysqld.sym
-n /tmp/mysql.stack
0x81c508a pthread_sighandler + 150
0x80f4ca5 dict_col_add_to_cache + 153
0x80f44d4 dict_table_add_to_cache + 1128
0x80f823e dict_load_table + 3326
0x80f4021 dict_table_get + 169
0x80caee6 open__11ha_innobasePCciUi + 310
0x80c4a2d ha_open__7handlerPCcii + 33
0x809bdbf openfrm__FPCcT0UiUiUiP8st_table + 4959
0x8097de1 open_unireg_entry__FP3THDP8st_tablePCcN22b + 69
0x8097522 open_table__FP3THDPCcN21Pb + 950
0x8098177 open_ltable__FP3THDP13st_table_list13thr_lock_type + 71
0x80abede
mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15enum_duplicates13thr_lock_type
+ 302
0x8084967 mysql_execute_command__Fv + 5339
0x80877fd mysql_parse__FP3THDPcUi + 209
0x8082ba9 do_command__FP3THD + 1305
0x80820d6 handle_one_connection__FPv + 578

We have tried 2.2.x kernels and all kinds of memory configs but we are at a
loss for what to do. It seems to be a machine problem because the same data on a
different machine works fine. If anyone has any ideas I would love it! Thanks.

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

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

Re: count(*) on different tables

Actually, as far as performance goes, it depends on table types.  Most of
the MySQL table handlers keep an internal count of record numbers.  Thus, a
select count(*) from table; is as fast as it gets.

- Original Message -
From: Siomara Pantarotto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 12:26 PM
Subject: Re: count(*) on different tables

 Well ...

 I don't know enough about mysql but it must allow you somehow to specify
the
 column by number as in Oracle and other DBs

 SQL select count(*) from product;

   COUNT(*)
 --
 10

 SQL select count(1) from product;

   COUNT(1)
 --
 10

 Once you just want to count the rows the performance of your select will
be
 much better if you specify a column rather than *.

 Siomara

 From: Ansgar Becker [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Subject: count(*) on different tables
 Date: Mon, 21 May 2001 20:18:35 +0200

 Hi,

 is it possible to get *one* quick result with the rowcount of each table
in
 one database, without knowing the column-names?

 this does *not* work:
   select count(t1.*), count(t2.*)
 from table1 t1, table2 t2

 Manual doesn't say anything about that.

 Greetings,
 Ansgar Becker

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

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

 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

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

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: Compute SQL Function Not Supported

2001-05-21 Thread Brandon Lewis


Okay I may have been a bit vague on my description.
 SELECT location, date, type, price,
FROM products
ORDER BY location, type, date
Group By location, type
COMPUTE SUM(price)

Is there something similar for compute?


-Original Message-
From: Chris Bolt [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 1:07 PM
To: [EMAIL PROTECTED]
Subject: RE: Compute SQL Function Not Supported

SELECT type, sum(price) FROM products GROUP BY type ORDER BY type

 I take it the Computer SQL Function is not support by MySQL and if not is
 there a substitute for it?

 If you are unfamiliar with the command it works like this:

 SELECT type, price
 FROM products
 ORDER BY type
 COMPUTE SUM(price)

 You will get a summary of prices by type in your results.

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

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

Change port #

2001-05-21 Thread Mike Tiffee


my ISP firewall dosen't allow access to port 3306.   How can I change this 
port assignment?  I saw this in the doc but I couldn't find the my.ini 
file.  What affect other than remote access will changing the port have?  I 
need to change it to port 21, or something.
mysql






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

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

Re: MYSQL and the Macintosh

2001-05-21 Thread Zachary Burnham


Hmm.  One way might be to use MacPerl to generate tab delimited files 
that you could then use to create an Excel document, then mail merge 
into your Word doc.  I could have sworn that there was some kind of ODBC 
setup with Mac Office, though..

Z
On Monday, May 21, 2001, at 02:17 AM, Ray Smith wrote:

 Hi all,

 I would like to try and create a database that can be used for 
 report/letter generation on both IBM and Macs, and eventually emails. I 
 have success on the IBM simply using ODBC and Office, and was wondering 
 how one would go about the same process on the Mac. The advantage of 
 using Office was simply that templates already existed. I have had a 
 look through the archives but only found references to FileMaker. Is 
 this the only way to go on the Mac? Any suggestions?


 Ray.

 -
 Ray Smith
 Centre for Musculoskeletal Studies
 Department of Surgery
 University of Western Australia
 Royal Perth Hospital
 Medical Research Foundation Bldg
 Rear 50 Murray St, Perth, Western Australia, 6000
 Ph: +61 8 9224 0307
 Fax:+61 8 9224 0204
 Email:  [EMAIL PROTECTED]


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

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail mysql-unsubscribe-
 [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: Compute SQL Function Not Supported

2001-05-21 Thread Brandon Lewis


Please strike previous message the query should be:
 SELECT location, date, type, price,
FROM products
ORDER BY location, date, type
Group By location, date, type
COMPUTE SUM(price)

-Original Message-
From: Brandon Lewis [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 2:14 PM
To: Chris Bolt; [EMAIL PROTECTED]
Subject: RE: Compute SQL Function Not Supported

Okay I may have been a bit vague on my description.


Is there something similar for compute?


-Original Message-
From: Chris Bolt [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 1:07 PM
To: [EMAIL PROTECTED]
Subject: RE: Compute SQL Function Not Supported

SELECT type, sum(price) FROM products GROUP BY type ORDER BY type

 I take it the Computer SQL Function is not support by MySQL and if not is
 there a substitute for it?

 If you are unfamiliar with the command it works like this:

 SELECT type, price
 FROM products
 ORDER BY type
 COMPUTE SUM(price)

 You will get a summary of prices by type in your results.

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

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: Problems with MySQL and Poweredge 6450..

2001-05-21 Thread Sasha Pachev

On Monday 21 May 2001 13:50, Cody Swanson wrote:
Hey,

We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our
intention
is to move the database off a smaller machine and load it into this one. We
currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 with
kernel
2.4.4. This is on a dual PIII650 with 1 gig of ram and it runs fine. Here
is a
copy of a status readout in mysql:

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

Connection id:232107
Current database:
Current user: root@localhost
Current pager:stdout
Using outfile:''
Server version: 3.23.38
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 1 day 19 hours 23 min 39 sec

Threads: 55 Questions: 70609984 Slow queries: 15 Opens: 203 Flush
tables: 1
Open tables: 155 Queries per second avg: 451.994

As you can see we have quite a load on this poor machine, this is why we
wanted
to move to a bigger badder machine so we could push more out of MySQL.
Anyway,
as mentioned before, our machine is a Poweredge 6450 with 4 Xeon 750mhz
processors and 4gb of ram. We also have a dell 4 channel PercRaid card that
does
a raid 5 onto 4 36gb scsi disks. So we loaded Mysql 3.23.38 onto the machine
with no extra tweeks, just with the raw install from dell, setup the
Innobase
driver and imported our data. Once we moved the site onto the new server
everything worked great, we could do super heavy queries in no time, it was
great! Then a day later I was looking at the .err log and noticed that
MySQL had
crashed several times! Each time it crashes it restarts itself and the
innobase
tables fix themselves. Innobase is verry cool! But this is a real problem!

So I took the .err file and parsed the stack trace against the symbol file
for
mysql like the manual says. Here is a copy of the .err file with the stack
dump
from one crash. This one is from kernel 2.4.3:

Here is the results of running stackresolve:

mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15enum_duplicates13thr_lock_type
+ 302
0x8084967 mysql_execute_command__Fv + 5339
0x80877fd mysql_parse__FP3THDPcUi + 209
0x8082ba9 do_command__FP3THD + 1305
0x80820d6 handle_one_connection__FPv + 578

We have tried 2.2.x kernels and all kinds of memory configs but we are at a
loss for what to do. It seems to be a machine problem because the same data
on a
different machine works fine. If anyone has any ideas I would love it!
Thanks.

Thanks for a good bug report. Looks like you are using InnoDB tables. Please
be aware that although we have tested them, they are not quite 100%
production ready, although they are getting better and better. Let's hope

Telnet into MySQL

2001-05-21 Thread Tim Thorburn


Hello,

Can someone here recommend a good Telnet program (with SSH) that I can use 
to connect to my servers MySQL database?

Preferably something shareware/freeware - but if it must be purchased, I'm 
not against that.

Thank you

-Tim


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

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

Re: count(*) on different tables


Cool  but how about if you put a where clause to your select??

SQL select count(1) from product where productid 3;

  COUNT(1)
--
 7

Would count(*) show the same performance as count(1)???

Siomara


From: Eric Fitzgerald [EMAIL PROTECTED]
To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: count(*) on different tables
Date: Mon, 21 May 2001 13:11:38 -0700

Actually, as far as performance goes, it depends on table types.  Most of
the MySQL table handlers keep an internal count of record numbers.  Thus, a
select count(*) from table; is as fast as it gets.

- Original Message -
From: Siomara Pantarotto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 12:26 PM
Subject: Re: count(*) on different tables


  Well ...
 
  I don't know enough about mysql but it must allow you somehow to specify
the
  column by number as in Oracle and other DBs
 
  SQL select count(*) from product;
 
COUNT(*)
  --
  10
 
  SQL select count(1) from product;
 
COUNT(1)
  --
  10
 
  Once you just want to count the rows the performance of your select will
be
  much better if you specify a column rather than *.
 
  Siomara
 
 
  From: Ansgar Becker [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Subject: count(*) on different tables
  Date: Mon, 21 May 2001 20:18:35 +0200
  
  Hi,
  
  is it possible to get *one* quick result with the rowcount of each 
table
in
  one database, without knowing the column-names?
  
  this does *not* work:
select count(t1.*), count(t2.*)
  from table1 t1, table2 t2
  
  Manual doesn't say anything about that.
  
  Greetings,
  Ansgar Becker
  
  
  
  
  
  -
  Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
  
 
  
_
  Get Your Private, Free E-mail from MSN Hotmail at 
http://www.hotmail.com.
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail 
[EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 


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

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


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


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

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

RE: Telnet into MySQL

2001-05-21 Thread Angerer, Chad

go to www.ssh.com .. I beleieve there a few nice clients there.

Chad

-Original Message-
From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 3:21 PM
To: [EMAIL PROTECTED]
Subject: Telnet into MySQL

Hello,

Can someone here recommend a good Telnet program (with SSH) that I can use 
to connect to my servers MySQL database?

Preferably something shareware/freeware - but if it must be purchased, I'm 
not against that.

Thank you

-Tim

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

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

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

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: Telnet into MySQL

2001-05-21 Thread Carl Schrader


CRT (www.vandyke.com)

Tim Thorburn wrote:

 Hello,

 Can someone here recommend a good Telnet program (with SSH) that I can use
 to connect to my servers MySQL database?

 Preferably something shareware/freeware - but if it must be purchased, I'm
 not against that.

 Thank you

 -Tim

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

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


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

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

Re: count(*) on different tables


Well, let's do a test:

mysql CREATE TABLE testcount (product INT NOT NULL AUTO_INCREMENT PRIMARY
KEY, description VARCHAR(50));
Query OK, 0 rows affected (0.00 sec)

**Ran perl script here to populate the table**
mysql SELECT * FROM testcount LIMIT 10;
+-+---+
| product | description   |
+-+---+
|   1 | Decription 1  |
|   2 | Decription 2  |
|   3 | Decription 3  |
|   4 | Decription 4  |
|   5 | Decription 5  |
|   6 | Decription 6  |
|   7 | Decription 7  |
|   8 | Decription 8  |
|   9 | Decription 9  |
|  10 | Decription 10 |
+-+---+
10 rows in set (0.03 sec)

mysql SELECT COUNT(*) FROM testcount;
+--+
| COUNT(*) |
+--+
|   10 |
+--+
1 row in set (0.00 sec)

mysql SELECT COUNT(1) FROM testcount;
+--+
| COUNT(1) |
+--+
|   10 |
+--+
1 row in set (0.00 sec)

mysql SELECT COUNT(2) FROM testcount;
+--+
| COUNT(2) |
+--+
|   10 |
+--+
1 row in set (0.00 sec)

mysql SELECT COUNT(*) FROM testcount WHERE product  10;
+--+
| COUNT(*) |
+--+
|0 |
+--+
1 row in set (0.32 sec)

mysql SELECT COUNT(1) FROM testcount WHERE product  10;
+--+
| COUNT(1) |
+--+
|0 |
+--+
1 row in set (0.32 sec)

mysql


As you can see, it really makes no difference to MySQL.

- Original Message -
From: Siomara Pantarotto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 1:48 PM
Subject: Re: count(*) on different tables


 Cool  but how about if you put a where clause to your select??

 SQL select count(1) from product where productid 3;

   COUNT(1)
 --
  7

 Would count(*) show the same performance as count(1)???

 Siomara


 From: Eric Fitzgerald [EMAIL PROTECTED]
 To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: Re: count(*) on different tables
 Date: Mon, 21 May 2001 13:11:38 -0700
 
 Actually, as far as performance goes, it depends on table types.  Most of
 the MySQL table handlers keep an internal count of record numbers.  Thus,
a
 select count(*) from table; is as fast as it gets.
 
 - Original Message -
 From: Siomara Pantarotto [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, May 21, 2001 12:26 PM
 Subject: Re: count(*) on different tables
 
 
   Well ...
  
   I don't know enough about mysql but it must allow you somehow to
specify
 the
   column by number as in Oracle and other DBs
  
   SQL select count(*) from product;
  
 COUNT(*)
   --
   10
  
   SQL select count(1) from product;
  
 COUNT(1)
   --
   10
  
   Once you just want to count the rows the performance of your select
will
 be
   much better if you specify a column rather than *.
  
   Siomara
  
  
   From: Ansgar Becker [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Subject: count(*) on different tables
   Date: Mon, 21 May 2001 20:18:35 +0200
   
   Hi,
   
   is it possible to get *one* quick result with the rowcount of each
 table
 in
   one database, without knowing the column-names?
   
   this does *not* work:
 select count(t1.*), count(t2.*)
   from table1 t1, table2 t2
   
   Manual doesn't say anything about that.
   
   Greetings,
   Ansgar Becker
   
   
   
   
   
   -
   Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)
   
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
   [EMAIL PROTECTED]
   Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
   
  
  
 _
   Get Your Private, Free E-mail from MSN Hotmail at
 http://www.hotmail.com.
  
  
   -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
 [EMAIL PROTECTED]
   Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
  
  
  
 
 
 -
 Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.





-
Before posting, please check:

Re: Telnet into MySQL

2001-05-21 Thread Peter L. Berghold


On Mon, May 21, 2001 at 03:21:10PM -0500, Tim Thorburn spake thusly:
*] Can someone here recommend a good Telnet program (with SSH) that I can use 
*] to connect to my servers MySQL database?
*] 
Tim,

You don't use telnet to connect to the MySQL database... You use the 
mysql client

-- 
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Peter L. Berghold[EMAIL PROTECTED]
Schooner Technology Consulting   http://www.berghold.net
Unix Professional ServicesPerl Perl/CGI mod_perl 

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

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

About MyODBC Some Common Errors

2001-05-21 Thread Avukatpro Limited Sirketi


In ODBC documents some common error section is says
- If you are connecting to a server with a character set that isn't compiled
  into the MySQL client library (the defaults are:
  latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis
  ) then you need to install the mysql character definitions from the
  charsets directory into the c:\mysql\share\charsets.
Is it possible to read it from my.ini or
is it possible to recompile it with the recent charsets Index file (from 1
to 30)

Regards
Yusuf INCEKARA



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

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: Telnet into MySQL

2001-05-21 Thread harm


On Mon, May 21, 2001 at 05:13:44PM -0400, Peter L. Berghold wrote:
 On Mon, May 21, 2001 at 03:21:10PM -0500, Tim Thorburn spake thusly:
 *] Can someone here recommend a good Telnet program (with SSH) that I can use 
 *] to connect to my servers MySQL database?
 *] 

Seeing your mailclient (X-Mailer: QUALCOMM Windows Eudora Version 5.1) you
probably want one for a windows box :)
Try Putty:
http://www.google.com/search?q=putty.exe
small and light. 

 Tim,
 
 You don't use telnet to connect to the MySQL database... You use the 
 mysql client

Well yeah. Asking the right question is an art ;)


Good luck,



-- 
The Moon is Waning Crescent (2% of Full)
  nieuw.nl - 2dehands.nl

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

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

Re: Telnet into MySQL

2001-05-21 Thread Paul DuBois


At 3:21 PM -0500 5/21/01, Tim Thorburn wrote:
Hello,

Can someone here recommend a good Telnet program (with SSH) that I 
can use to connect to my servers MySQL database?

Preferably something shareware/freeware - but if it must be 
purchased, I'm not against that.

Thank you

-Tim

Unless you're thinking about some kind of Telnet program that you can use
to set up an SSH forwarder, this won't work.  You don't Telnet directly to the
MySQL server; it speaks a binary protocol.


-- 
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: Telnet into MySQL

2001-05-21 Thread massey



Any good ones for the Windozes version..When I use just regular ol Telnet I get Smiley 
and clovers and hearts and the version.

Cheers

-Original Message-
FROM: Eric Fitzgerald
TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED]
DATE: Mon 5/21/01 15:58
SUBJECT: Re: Telnet into MySQL

I really prefer SecureCRT from VanDyke software myself.  Perfect blend of
features and simplicity for my needs.  It has a shareware version that does
expire, but the license is cheap for it.  Go to www.vandyke.com and download
the shareware version to give it a try.
- Original Message -
From: Angerer, Chad [EMAIL PROTECTED]
To: 'Tim Thorburn' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 1:58 PM
Subject: RE: Telnet into MySQL


 go to www.ssh.com .. I beleieve there a few nice clients there.

 Chad

 -Original Message-
 From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
 Sent: Monday, May 21, 2001 3:21 PM
 To: [EMAIL PROTECTED]
 Subject: Telnet into MySQL


 Hello,

 Can someone here recommend a good Telnet program (with SSH) that I can use
 to connect to my servers MySQL database?

 Preferably something shareware/freeware - but if it must be purchased, I'm
 not against that.

 Thank you

 -Tim


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

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

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

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





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

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



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

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

Re[2]: Telnet into MySQL

2001-05-21 Thread Olexandr Vynnychenko


Hello Eric,

Tuesday, May 22, 2001, 12:23:24 AM, you wrote:

EF I really prefer SecureCRT from VanDyke software myself.  Perfect blend of
EF features and simplicity for my needs.  It has a shareware version that does
EF expire, but the license is cheap for it.  Go to www.vandyke.com and download
EF the shareware version to give it a try.
EF - Original Message -
EF From: Angerer, Chad [EMAIL PROTECTED]
EF To: 'Tim Thorburn' [EMAIL PROTECTED]; [EMAIL PROTECTED]
EF Sent: Monday, May 21, 2001 1:58 PM
EF Subject: RE: Telnet into MySQL


 go to www.ssh.com .. I beleieve there a few nice clients there.

 Chad

 -Original Message-
 From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
 Sent: Monday, May 21, 2001 3:21 PM
 To: [EMAIL PROTECTED]
 Subject: Telnet into MySQL


 Hello,

 Can someone here recommend a good Telnet program (with SSH) that I can use
 to connect to my servers MySQL database?

 Preferably something shareware/freeware - but if it must be purchased, I'm
 not against that.

 Thank you

 -Tim


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

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

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

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





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

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

The best is PuTTY http://www.chiark.greenend.org.uk/~sgtatham/putty.
It's absolutely free.

-- 
Best regards,
 Olexandrmailto:[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: Compute SQL Function Not Supported

2001-05-21 Thread Chris Bolt


In your original message, you said You will get a summary of prices by type
in your results. and that is what my query gives you. It returns the sum of
the price columns from any rows that are eliminated by the GROUP BY clause.
What do you want it to return?

 Please strike previous message the query should be:
  SELECT location, date, type, price,
 FROM products
 ORDER BY location, date, type
 Group By location, date, type
 COMPUTE SUM(price)

 SELECT type, sum(price) FROM products GROUP BY type ORDER BY type


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

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

Re: count(*) on different tables


That's really cool

Thanks

siomara


From: Eric Fitzgerald [EMAIL PROTECTED]
To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: count(*) on different tables
Date: Mon, 21 May 2001 14:08:00 -0700

Well, let's do a test:

mysql CREATE TABLE testcount (product INT NOT NULL AUTO_INCREMENT PRIMARY
KEY, description VARCHAR(50));
Query OK, 0 rows affected (0.00 sec)

**Ran perl script here to populate the table**
mysql SELECT * FROM testcount LIMIT 10;
+-+---+
| product | description   |
+-+---+
|   1 | Decription 1  |
|   2 | Decription 2  |
|   3 | Decription 3  |
|   4 | Decription 4  |
|   5 | Decription 5  |
|   6 | Decription 6  |
|   7 | Decription 7  |
|   8 | Decription 8  |
|   9 | Decription 9  |
|  10 | Decription 10 |
+-+---+
10 rows in set (0.03 sec)

mysql SELECT COUNT(*) FROM testcount;
+--+
| COUNT(*) |
+--+
|   10 |
+--+
1 row in set (0.00 sec)

mysql SELECT COUNT(1) FROM testcount;
+--+
| COUNT(1) |
+--+
|   10 |
+--+
1 row in set (0.00 sec)

mysql SELECT COUNT(2) FROM testcount;
+--+
| COUNT(2) |
+--+
|   10 |
+--+
1 row in set (0.00 sec)

mysql SELECT COUNT(*) FROM testcount WHERE product  10;
+--+
| COUNT(*) |
+--+
|0 |
+--+
1 row in set (0.32 sec)

mysql SELECT COUNT(1) FROM testcount WHERE product  10;
+--+
| COUNT(1) |
+--+
|0 |
+--+
1 row in set (0.32 sec)

mysql


As you can see, it really makes no difference to MySQL.

- Original Message -
From: Siomara Pantarotto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 1:48 PM
Subject: Re: count(*) on different tables


  Cool  but how about if you put a where clause to your select??
 
  SQL select count(1) from product where productid 3;
 
COUNT(1)
  --
   7
 
  Would count(*) show the same performance as count(1)???
 
  Siomara
 
 
  From: Eric Fitzgerald [EMAIL PROTECTED]
  To: Siomara Pantarotto [EMAIL PROTECTED], 
[EMAIL PROTECTED]
  Subject: Re: count(*) on different tables
  Date: Mon, 21 May 2001 13:11:38 -0700
  
  Actually, as far as performance goes, it depends on table types.  Most 
of
  the MySQL table handlers keep an internal count of record numbers.  
Thus,
a
  select count(*) from table; is as fast as it gets.
  
  - Original Message -
  From: Siomara Pantarotto [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Monday, May 21, 2001 12:26 PM
  Subject: Re: count(*) on different tables
  
  
Well ...
   
I don't know enough about mysql but it must allow you somehow to
specify
  the
column by number as in Oracle and other DBs
   
SQL select count(*) from product;
   
  COUNT(*)
--
10
   
SQL select count(1) from product;
   
  COUNT(1)
--
10
   
Once you just want to count the rows the performance of your select
will
  be
much better if you specify a column rather than *.
   
Siomara
   
   
From: Ansgar Becker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: count(*) on different tables
Date: Mon, 21 May 2001 20:18:35 +0200

Hi,

is it possible to get *one* quick result with the rowcount of each
  table
  in
one database, without knowing the column-names?

this does *not* work:
  select count(t1.*), count(t2.*)
from table1 t1, table2 t2

Manual doesn't say anything about that.

Greetings,
Ansgar Becker






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

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

   
   
  
 _
Get Your Private, Free E-mail from MSN Hotmail at
  http://www.hotmail.com.
   
   

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)
   
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
  [EMAIL PROTECTED]
Trouble unsubscribing? Try: 
http://lists.mysql.com/php/unsubscribe.php
   
   
   
  
  
  -
  Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]

Re: Telnet into MySQL

2001-05-21 Thread Colin Faber


hahah

Check out SecureCRT it's a wonderful product and well worth the price.


[EMAIL PROTECTED] wrote:
 
 Any good ones for the Windozes version..When I use just regular ol Telnet I get 
Smiley and clovers and hearts and the version.
 
 Cheers
 
 -Original Message-
 FROM: Eric Fitzgerald
 TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED]
 DATE: Mon 5/21/01 15:58
 SUBJECT: Re: Telnet into MySQL
 
 I really prefer SecureCRT from VanDyke software myself.  Perfect blend of
 features and simplicity for my needs.  It has a shareware version that does
 expire, but the license is cheap for it.  Go to www.vandyke.com and download
 the shareware version to give it a try.
 - Original Message -
 From: Angerer, Chad [EMAIL PROTECTED]
 To: 'Tim Thorburn' [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Monday, May 21, 2001 1:58 PM
 Subject: RE: Telnet into MySQL
 
  go to www.ssh.com .. I beleieve there a few nice clients there.
 
  Chad
 
  -Original Message-
  From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
  Sent: Monday, May 21, 2001 3:21 PM
  To: [EMAIL PROTECTED]
  Subject: Telnet into MySQL
 
 
  Hello,
 
  Can someone here recommend a good Telnet program (with SSH) that I can use
  to connect to my servers MySQL database?
 
  Preferably something shareware/freeware - but if it must be purchased, I'm
  not against that.
 
  Thank you
 
  -Tim
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

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

Re: Telnet into MySQL

2001-05-21 Thread Brian Warn

I vote for VanDyke's CRT as well -- lots of features and ~ $30 (US) for the
license.

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 3:04 PM
Subject: Re: Telnet into MySQL

 Any good ones for the Windozes version..When I use just regular ol Telnet
I get Smiley and clovers and hearts and the version.

 Cheers

 -Original Message-
 FROM: Eric Fitzgerald
 TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED]
 DATE: Mon 5/21/01 15:58
 SUBJECT: Re: Telnet into MySQL

 I really prefer SecureCRT from VanDyke software myself.  Perfect blend of
 features and simplicity for my needs.  It has a shareware version that
does
 expire, but the license is cheap for it.  Go to www.vandyke.com and
download
 the shareware version to give it a try.
 - Original Message -
 From: Angerer, Chad [EMAIL PROTECTED]
 To: 'Tim Thorburn' [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Monday, May 21, 2001 1:58 PM
 Subject: RE: Telnet into MySQL

  go to www.ssh.com .. I beleieve there a few nice clients there.

  Chad

  -Original Message-
  From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
  Sent: Monday, May 21, 2001 3:21 PM
  To: [EMAIL PROTECTED]
  Subject: Telnet into MySQL

  Hello,

  Can someone here recommend a good Telnet program (with SSH) that I can
use
  to connect to my servers MySQL database?

  Preferably something shareware/freeware - but if it must be purchased,
I'm
  not against that.

  Thank you

  -Tim

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

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

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

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

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

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

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

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

_
Do You Yahoo!?
Get your free @yahoo.com address at http://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: Telnet into MySQL

2001-05-21 Thread Paul DuBois


At 4:04 PM -0600 5/21/01, [EMAIL PROTECTED] wrote:
Any good ones for the Windozes version..When I use just regular ol 
Telnet I get Smiley and clovers and hearts and the version.

That's exactly why you don't Telnet to the MySQL server.  You're seeing
information that's part of the binary client-server protocol.  Use the
mysql program instead.


Cheers

-Original Message-
FROM: Eric Fitzgerald
TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED]
DATE: Mon 5/21/01 15:58
SUBJECT: Re: Telnet into MySQL

I really prefer SecureCRT from VanDyke software myself.  Perfect blend of
features and simplicity for my needs.  It has a shareware version that does
expire, but the license is cheap for it.  Go to www.vandyke.com and download
the shareware version to give it a try.
- Original Message -
From: Angerer, Chad [EMAIL PROTECTED]
To: 'Tim Thorburn' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 1:58 PM
Subject: RE: Telnet into MySQL


  go to www.ssh.com .. I beleieve there a few nice clients there.

  Chad

  -Original Message-
  From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
  Sent: Monday, May 21, 2001 3:21 PM
  To: [EMAIL PROTECTED]
  Subject: Telnet into MySQL


  Hello,

  Can someone here recommend a good Telnet program (with SSH) that I can use
  to connect to my servers MySQL database?

  Preferably something shareware/freeware - but if it must be purchased, I'm
  not against that.

  Thank you

  -Tim


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

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

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

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





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

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



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

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


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

My sql and myISAM

2001-05-21 Thread VVM Ravikumar Sarma Chengalvala


Hi,
Do someone have answers to these questions:
1.
Maximum table size myISAM type tabes can handle?
2.
Default maximum database size for a particular
database.

Your help will be highly appreciated.

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

Re: Telnet into MySQL

2001-05-21 Thread massey



Ahh come on.. I want to make things difficultG Normaly I never think about Telnet 
but for Fun on a borring Monday I decided hmmm let's play.

If I do any thing it normaly through an ASTA Server and Client. Cool stuff.


Cheers

 
-Original Message-
FROM: Paul DuBois
TO: [EMAIL PROTECTED], [EMAIL PROTECTED]
DATE: Mon 5/21/01 16:46
SUBJECT: Re: Telnet into MySQL

At 4:04 PM -0600 5/21/01, [EMAIL PROTECTED] wrote:
Any good ones for the Windozes version..When I use just regular ol 
Telnet I get Smiley and clovers and hearts and the version.

That's exactly why you don't Telnet to the MySQL server.  You're seeing
information that's part of the binary client-server protocol.  Use the
mysql program instead.


Cheers

-Original Message-
FROM: Eric Fitzgerald
TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED]
DATE: Mon 5/21/01 15:58
SUBJECT: Re: Telnet into MySQL

I really prefer SecureCRT from VanDyke software myself.  Perfect blend of
features and simplicity for my needs.  It has a shareware version that does
expire, but the license is cheap for it.  Go to www.vandyke.com and download
the shareware version to give it a try.
- Original Message -
From: Angerer, Chad [EMAIL PROTECTED]
To: 'Tim Thorburn' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 1:58 PM
Subject: RE: Telnet into MySQL


  go to www.ssh.com .. I beleieve there a few nice clients there.

  Chad

  -Original Message-
  From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
  Sent: Monday, May 21, 2001 3:21 PM
  To: [EMAIL PROTECTED]
  Subject: Telnet into MySQL


  Hello,

  Can someone here recommend a good Telnet program (with SSH) that I can use
  to connect to my servers MySQL database?

  Preferably something shareware/freeware - but if it must be purchased, I'm
  not against that.

  Thank you

  -Tim


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

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

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

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





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

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



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

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


-- 
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: count(*) on different tables

2001-05-21 Thread ryc


As far as I know, they should be the same. The only case in which I can see
count(colname) would be slower is if it doesnt count rows that contain null
values for that column (this is only a guess, I dont know if count does that
or not).

ryan

 Would count(*) show the same performance as count(1)???

 Siomara

 Actually, as far as performance goes, it depends on table types.  Most of
 the MySQL table handlers keep an internal count of record numbers.  Thus,
a
 select count(*) from table; is as fast as it gets.
 
   Well ...
  
   I don't know enough about mysql but it must allow you somehow to
specify
 the
   column by number as in Oracle and other DBs
  
   SQL select count(*) from product;
  
 COUNT(*)
   --
   10
  
   SQL select count(1) from product;
  
 COUNT(1)
   --
   10
  
   Once you just want to count the rows the performance of your select
will
 be
   much better if you specify a column rather than *.
  
   Siomara
  
   Hi,
   
   is it possible to get *one* quick result with the rowcount of each
 table
 in
   one database, without knowing the column-names?
   
   this does *not* work:
 select count(t1.*), count(t2.*)
   from table1 t1, table2 t2
   
   Manual doesn't say anything about that.
   
   Greetings,
   Ansgar Becker
   



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

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

sql to select 2 entries/name?

2001-05-21 Thread Tyler Longren


Hello list,

I have a table in a database that has a field named 'artist'.  There are multiple 
entries of the same artist/band.  Example:
deftones
iggy pop
kiss
deftones
glassjaw
deftones
kiss
new found glory
kiss

There's 3 entries for deftones and 4 entries for kiss.  What I need to do is select a 
maximum of 2 entries for each artist.  I've tried a few different things, but nothing 
has given me what I need.  Is there any way to do this?

Thanks everyone,
Tyler Longren

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

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: Telnet into MySQL

2001-05-21 Thread Steve Brazill


Before you listen to anyone else (and spend any money on a commercial SSH client)
download and try PuttySSH,  which is a free 'telnet like' SSH client (it WILL
do straight telnet if you want it to) that works fabulously (at least for me at
home and work for the past year).   You can also download SCP (secure copy) and
other utilities (i.e. SFTP) from the website:

http://www.chiark.greenend.org.uk/~sgtatham/putty/

Even if you're actually trying to connect to the MySQL 'service' with this
utility (which would be pointless) you should still download it,  since using
Telnet and/or FTP for communicating with your servers is suicidal...


j.urban wrote:

 Take a look at the posts from Paul and others...  You can't connect
 directly to MySQL using telnet without knowning the MySQL communication
 protocol...

 There are many MySQL client programs -- a good one for Windows
 is urSQL available from http://www.urbanresearch.com/ursql

 You might also want to have a look at the MySQL manual at
 http://www.mysql.com/doc/

 Good luck.

 On Mon, 21 May 2001 [EMAIL PROTECTED] wrote:

 
  Any good ones for the Windozes version..When I use just regular ol
  Telnet I get Smiley and clovers and hearts and the version.
 
  Cheers
 
  -Original Message-
  FROM: Eric Fitzgerald
  TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED]
  DATE: Mon 5/21/01 15:58
  SUBJECT: Re: Telnet into MySQL
 
  I really prefer SecureCRT from VanDyke software myself.  Perfect blend of
  features and simplicity for my needs.  It has a shareware version that does
  expire, but the license is cheap for it.  Go to www.vandyke.com and download
  the shareware version to give it a try.
  - Original Message -
  From: Angerer, Chad [EMAIL PROTECTED]
  To: 'Tim Thorburn' [EMAIL PROTECTED]; [EMAIL PROTECTED]
  Sent: Monday, May 21, 2001 1:58 PM
  Subject: RE: Telnet into MySQL
 
 
   go to www.ssh.com .. I beleieve there a few nice clients there.
  
   Chad
  
   -Original Message-
   From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
   Sent: Monday, May 21, 2001 3:21 PM
   To: [EMAIL PROTECTED]
   Subject: Telnet into MySQL
  
  
   Hello,
  
   Can someone here recommend a good Telnet program (with SSH) that I can use
   to connect to my servers MySQL database?
  
   Preferably something shareware/freeware - but if it must be purchased, I'm
   not against that.
  
   Thank you
  
   -Tim
  
  
   -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
   [EMAIL PROTECTED]
   Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
  
   -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail [EMAIL PROTECTED]
   Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
  
  
  
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

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

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

secure connection (SSL/SSH tunneling) with windows client

2001-05-21 Thread cedric



Hi,

   I know this has been discussed a lot. I did read the mail archive and
found lots of interesting info. Although I have a problem. We're developing
a windows software that has to exchange sensitive data with a mySQL server.
I read about implementing a SSH tunnel. It works well, although I have not
found a free ssh client for windows. Even if I did, it would not be really
helpful as we don't want to explain to our users they have to install a
third party software that does IP tunneling in order to transmit data
securely. Any suggestions? 

   Even if SSL support was added to mySQL, I guess I'd still have to wait
for SSL support in the client libs we use on windows (ZeosLib)...

   I am ready to encrypt every sensitive fields in the database, although I
am wondering if the username and password will be transferred in plain
text. I've seen somewhere that it isn't, but what kind of
security/encryption is used and can we consider it safe?

Any suggestions greatly appreciated.


Cedric

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

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

unaunthenticated user?

2001-05-21 Thread Heo, Jungsu Mr.


Hi~~~

My SHOW PROCESSLIST's output

| 22  | unauthenticated user | 10.169.xxx.xxx || Connect |  | login | 
what 'unauthenticated user' means?

who is he?

anonymous user?

Thank you for your advanced answer!

database



--MIME Multi-part separator--


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

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: Telnet into MySQL

2001-05-21 Thread Tim Thorburn


Okok, my bad!!

What I meant to say was that I needed a Telnet program with SSH so that I 
could log into the shell of my web hosting provider and thereby access 
MySQL from shell.



At 05:46 PM 5/21/2001 -0500, you wrote:
At 4:04 PM -0600 5/21/01, [EMAIL PROTECTED] wrote:
Any good ones for the Windozes version..When I use just regular ol Telnet 
I get Smiley and clovers and hearts and the version.

That's exactly why you don't Telnet to the MySQL server.  You're seeing
information that's part of the binary client-server protocol.  Use the
mysql program instead.


Cheers

-Original Message-
FROM: Eric Fitzgerald
TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED]
DATE: Mon 5/21/01 15:58
SUBJECT: Re: Telnet into MySQL

I really prefer SecureCRT from VanDyke software myself.  Perfect blend of
features and simplicity for my needs.  It has a shareware version that does
expire, but the license is cheap for it.  Go to www.vandyke.com and download
the shareware version to give it a try.
- Original Message -
From: Angerer, Chad [EMAIL PROTECTED]
To: 'Tim Thorburn' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 1:58 PM
Subject: RE: Telnet into MySQL


  go to www.ssh.com .. I beleieve there a few nice clients there.

  Chad

  -Original Message-
  From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
  Sent: Monday, May 21, 2001 3:21 PM
  To: [EMAIL PROTECTED]
  Subject: Telnet into MySQL


  Hello,

  Can someone here recommend a good Telnet program (with SSH) that I can use
  to connect to my servers MySQL database?

  Preferably something shareware/freeware - but if it must be purchased, I'm
  not against that.

  Thank you

  -Tim


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

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

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

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



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

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



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

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


--
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: MYSQL performance question


Shane Anderson wrote:
 
 I would like to know the limitations of Mysql with extremely large tables. I
 need to store 20+ million records. Each record would contain only 4-6 fields
 and would not be longer than 128 bytes of information. The records could be
 divided among several tables, but at what size is the performance hindered
 enough to need to split records between several smaller tables? Any
 information leading to an optimal solution would be greatly appreciated.

MySQL doesn't have a real limitation on the # of records, but I speak
only from 1/2 million record table experience.  But there is a point 
to that, I split my tables to have no more than that number because
I don't want to take my system offline for very long if I want to
add an index, or recover my database from a server crash.  MERGE tables 
might allow you to break up your large tables nicely. 

But what I'm saying is true for any database, that if you have 20 million
rows, your database maintenance window has to be a lot bigger, so while 
the query speed may be great on myisam with 20 millions rows, your 
DBA ( or you? ) may be none too happy when adding that new index.

Comparing Oracle vs. MySQL myisam tables, MySQL will save disk space, 
and provide you with much faster queries, but you have to be aware of the 
table locking issues if you are doing updates/inserts/deletes mixed
with reads.

--Josh

_
Joshua Chamas   Chamas Enterprises Inc.
NodeWorks  free web link monitoring   Huntington Beach, CA  USA 
http://www.nodeworks.com1-714-625-4051

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

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: Fastest query ?


Jocelyn Fournier wrote:
 
 Hi,
 
 I wonder which of the following queries is faster :
 
 $result=mysql_query(SELECT lastauteur FROM forum ORDER BY date DESC LIMIT 1);
 
 or :
 
 $max=mysql_query(SELECT max(date) FROM forum);
 list($max)=mysql_fetch_row($max);
 $result=mysql_query(SELECT lastauteur FROM forum WHERE date='max');
 
 (column date is declare as datetime, and is a non unique index)

I'd bet the all-in-one solution behind door #1.
  SELECT lastauteur FROM forum ORDER BY date DESC LIMIT 1  # very elegant

If not, I'd use explain on the select to see whether it's picking
up your index on date.  When it comes down to it, doing your own benchmark
of each method will always be better than what anyone might think.

--Josh

_
Joshua Chamas   Chamas Enterprises Inc.
NodeWorks  free web link monitoring   Huntington Beach, CA  USA 
http://www.nodeworks.com1-714-625-4051

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

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: copy from one db's table to another


Jeff Shipman - SysProg wrote:
 
 I have two databases that have identical table
 structures. I would like to copy all data from
 the 'tickets' and 'notes' in one db to the
 'tickets' and 'notes' field in the other. How
 could I do this?
 

You could try the lock/flush strategies employed
by the script mysqlhotcopy, and copy the raw
data files at the OS level.  You could also try
this SQL:

  # uncomment if you are purging first 
  # delete from dest.notes;

  insert into dest.notes select * from source.notes;

--Josh

_
Joshua Chamas   Chamas Enterprises Inc.
NodeWorks  free web link monitoring   Huntington Beach, CA  USA 
http://www.nodeworks.com1-714-625-4051

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

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: my sql and memory--A confusing issue for a newbie


VVM Ravikumar Sarma Chengalvala wrote:
 
 Hi,
 1.
 How much memory does mysql allocate by default to a
 database?Any default table wise memory limitations as
 well?

Its doesn't allocated very much by default (  10M ? ), 
and there is no per table memory allocation.

 2.
 Is mysql's memory management and Oracle's memory
 management similar?Or altogeather different?
 

They both have things like key buffers  sort buffers
that you can explicitly size, but MySQL doesn't have a 
db_block_buffer kind of thing that Oracle has. Rather, 
it lets your OS cache the data file, which works very 
well in Linux  just fine on WinNT.

--Josh

_
Joshua Chamas   Chamas Enterprises Inc.
NodeWorks  free web link monitoring   Huntington Beach, CA  USA 
http://www.nodeworks.com1-714-625-4051

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

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

Auto Increment

2001-05-21 Thread Asaf Maruf Ali



Dear All

I am inputting data into a MySQL database where i have set the primary key as the ID 
and it is auto-incrementing. I make sure that my input file contains a null or 0 value 
where it should be auto- incrementing. While entering data using LOAD command, my 
input file had an error with the result that erroneous values were entered. I deleted 
them no problem. However, this disturbed the sequence of the db.

Suppose, my records were at 100 and i entered data of 50 lines then my ID starts from 
150 instead of 101.

How can i reverse the count so that my ID starts from 101 with the good data.


Thanks in advance

Asaf Maruf
[EMAIL PROTECTED]

Re: key_reads and opened_tables.