; or 'set global variable=...'. See:
http://dev.mysql.com/doc/refman/4.1/en/system-variables.html
I strongly recommend you to upgrade.
Douglas B. Jones wrote:
> How do you up max_connections on 3.23.29 mysql? I
> have tried in the my.cnf file, command line and
> in
How do you up max_connections on 3.23.29 mysql? I
have tried in the my.cnf file, command line and
in mysql (set @max_connections=200). Thanks for
any help!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to compile mysql-5.0.15 on Solaris 5.9 with the
following options:
CC=cc;export CC
CFLAGS="-Xa -fast -native -xstrconst -mt -xarch=v9";export CFLAGS
CXX=CC;export CXX
CXXFLAGS="-noex -mt -xarch=v9" ASFLAGS="-xarch=v9";export CXXFLAGS
./configure --prefix=/usr/local/mysql --enable-asse
Here is the script to compile 4.1.10a, it worked compiled fine
with the directory changed on 4.0.23a and before:
#!/usr/bin/ksh
PATH=/usr/local/bin:"$PATH"
export PATH
echo $PATH
D=mysql-4.1.10a
CC="cc"
export CC
CXX="cxx -O"
export CXX
cd $D
./configure \
--prefix=/usr/local/mysql-test\
Hi,
My configure/compilation script is:
--
#!/usr/bin/ksh
D=mysql-4.0.13
#PORT=3306
PORT=3406
H=/usr/local/mysql-4-test
CC="cc -pthread"
export CC
CXX="cxx -pthread -O"
export CXX
cd $D
./configure \
--prefix=$H
--with-mysqld-user=mysql\
--with-tcp-port=$POR
: Douglas B Jones
Subject: RE: automatically incrementing an int value
On 12 Mar 2003, at 10:22, Douglas B. Jones wrote:
> INSERT INTO virus VALUES (91207,'VBS/Kakworm');
> INSERT INTO virus VALUES (117623,'VBS/Redlof-A');
>
> As you can see, the numbers (n field
ld not be so resource expensive.
Thanks,
Cheers,
Douglas
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 11:29 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Douglas B Jones
Subject: RE: automatically incrementing an int
TED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 10:58 AM
To: [EMAIL PROTECTED]
Cc: Douglas B Jones; [EMAIL PROTECTED]; 'Paul DuBois'
Subject: RE: automatically incrementing an int value
If I understand correctly, you are trying to grep the SQL data file.
This
is emphati
ks,
Cheers,
Douglas
mysql Ver 11.16 Distrib 3.23.49, for dec-osf5.1 (alphaev6)
-Original Message-----
From: Douglas B. Jones [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 10:22 AM
To: 'Paul DuBois'; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Douglas B Jones
Subjec
l as the db, still get the same results.
Any ideas?
Thanks,
Cheers,
Douglas
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 11:14 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Douglas B Jones
Subject: RE: automatically incr
e part: unique (name(100)),
what does the 100 do here? Is that saying the first 100 chars
are considered unique?
Thanks,
Cheers,
Douglas
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 10, 2003 10:36 AM
> To: Douglas B Jones
>
Hi,
First, the version: 3.23.49
If I have a table with two elements: name char(128), n int
how do I have it so that n will increment each time?
I take it that name needs to be a primary key. How do I get
n to increment in vaue each time. This is not auto_increment.
I want name to be in the tab
h the same idea.
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 30, 2001 10:10 AM
> To: Douglas B. Jones; [EMAIL PROTECTED]
> Cc: Douglas B Jones
> Subject: Re: installing mysql 3.23.43 - unrecognized option
>
>
>
Hi,
On Tru64 5.1, I am trying to install mysql 3.23.43. I follow
the steps in section 2.3 of running scripts/mysql_install_db.
It comes back with the error:
/usr/local/mysql-test/libexec/mysqld: unrecognized option `--password=reqid'
a password I never typed in. After that, it gives the usage
Hi,
On Tru64 5.1, I am trying to install mysql 3.23.43. I follow
the steps in section 2.3 of running scripts/mysql_install_db.
It comes back with the error:
/usr/local/mysql-test/libexec/mysqld: unrecognized option `--password=reqid'
a password I never typed in. After that, it gives the usage
15 matches
Mail list logo
