RE: max_connections in 3.23.49

=...'. 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 mysql (set @max_connections=200). Thanks for any

max_connections in 3.23.49

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]

compilation of mysql-5.0.15 on Solaris 5.9

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

compilation problems with 4.1.10a on Tru64 5.1

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\

--with-mysqld-user=mysql: not found configure error on 4.0.13

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=$PORT\

RE: automatically incrementing an int value

B Jones Subject: RE: automatically incrementing an int value At 11:09 -0500 3/10/03, Douglas B. Jones wrote: Hi, Great! This works, I did not use the 'null' and that is where I had a problem. One other questions: is this atomic? If I have several processes trying to do this at one time

RE: automatically incrementing an int value

, 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 Subject: RE: automatically

RE: automatically incrementing an int value

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 emphatically not a valid thing to do. The data file is *not* a representation of the table displayed

RE: automatically incrementing an int value

: 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 value At 10:22 -0500 3/12/03, Douglas B. Jones wrote: Hi, I just tried the below

RE: automatically incrementing an int value

: 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) are way to high? Is this a bug

automatically incrementing an int value

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

RE: automatically incrementing an int value

(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 Cc: [EMAIL PROTECTED] 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

RE: installing mysql 3.23.43 - unrecognized option

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 At 9:51 AM -0500 10/30/01, Douglas B. Jones wrote

mysql 3.23.43

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