Thanks.
Since i use Innodb, i decrease the value of all variables affected
myisam table
Thx
[EMAIL PROTECTED] wrote:
Lowering your sort_buffer and read_buffer to 512K should help (there are
allocated for each connection, and (12+12)*910 is a lot more than what
your system can handle).
Yes it's 32 bit System (Double XEON - Intel(R) Xeon(TM) CPU 3.00GHz)
Any solutions for this Joce?
[EMAIL PROTECTED] wrote:
Hi,
If it's a 32 bits machine, I don't think you can adress more than 2 GB for
1 MySQL process.
Jocelyn
Make sense,
Kayra, this is my.cnf for my mysql
-
Make sense,
Kayra, this is my.cnf for my mysql
cut here ---
[client]
port= 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
#thread_stack=128KB
#set-variable = table-type=innodb
default-table-type = innodb
port
[client]
port= 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
#thread_stack=128KB
#set-variable = table-type=innodb
default-table-type = innodb
port = 3306
socket = /var/lib/mysql/mysql.sock
max_connections= 910
max_connect_
It can be both Linux kernel setting and MySQL configuration issue.
It can be a kernel issue since:
- Although you have 4G on your machine your kernel may set to let only
2G to a user space process. You may need to upgrade your kernel to a
'hugemem' kernel which gives you either 3/1 or 4/4 (you nee
Can you tell us about your config parameters?
Probably you must set up your max_connections, max_user_connections
http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
Ady Wicaksono escribió:
I have MySQL 5 installed on My Machine,
But it could handle only max about 350 concurren
I have MySQL 5 installed on My Machine,
But it could handle only max about 350 concurrent mysql connection
Unbelieveable, i have 4 Gbytes, but on the next 351 connection i always
got Can't create a new thread (errno 12); if you are not out of
available memory, you can consult the manual for
a
It looks like mysql does not own the data directory.
[EMAIL PROTECTED] wrote:
Hello List,
I have done some googling around but can't find an answer to this one. Brand new box,
installed with RedHat 9 and trying to run 4.1.2. This is what I get.
--ja
[EMAIL PROTECTED] mysql]# sc
Hello List,
I have done some googling around but can't find an answer to this one. Brand new box,
installed with RedHat 9 and trying to run 4.1.2. This is what I get.
--ja
[EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user mysql --log
Installing all prepared tables
040618 11:
hmed wrote:
All,
I am looking for a stepwise installation of mysql-3.23.58 on Redhat 9.
and have a hard time finding it on the MySql web site. Could someone
e-mail me the steps, please.
There should also be a section on installing databases, in order to make
sure that MySql is running and is opera
All,
I am looking for a stepwise installation of mysql-3.23.58 on Redhat 9.
and have a hard time finding it on the MySql web site. Could someone
e-mail me the steps, please.
There should also be a section on installing databases, in order to make
sure that MySql is running and is operational
]
Subject: 3.23 redhat 9 server install
hi,
i have installed the redhat 9 server with php, apache 2, perl and of
course mysql 3.23.54. my problem is i can't access it or start it or
anything. so i tried to reinstall and it says its already there.
find /usr/ -name mysql_safe tried this and
]
Subject: 3.23 redhat 9 server install
hi,
i have installed the redhat 9 server with php, apache 2, perl and of course
mysql 3.23.54. my problem is i can't access it or start it or anything. so i
tried to reinstall and it says its already there.
find /usr/ -name mysql_safe tried this and
hi,
i have installed the redhat 9 server with php, apache 2, perl and of course
mysql 3.23.54. my problem is i can't access it or start it or anything. so i
tried to reinstall and it says its already there.
find /usr/ -name mysql_safe tried this and i get nothing
tried this
start mysql s
On Wednesday 21 January 2004 10:20, naga rajan wrote:
> hi,
> i am trying to install Mysql in RH-9.I follow your
> instructions .But when i typed
Since you have RedHat, might I suggest that you use the RPM versions, which
are pre-compiled and should set everything up properly for you.
--
MySQ
hi,
i am trying to install Mysql in RH-9.I follow your
instructions .But when i typed
./configure --prefix=/usr/local/mysql
after some screens it displays
Starting mysqld daemonwith databases
from/usr/local/src/mysql-standard-4.0.17-pc-linux-i686/data
040121 11:55:41 mysqld ended
after th
rpm -i MySQL-Max.rpm
solved it
On Sun, 23 Nov 2003, Jason Pyeron wrote:
> Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out.
> This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes.
>
> On Sun, 23 Nov 2003, Jason Pyeron wrote:
>
> >
> > I have never seen an error like this one,
Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out.
This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes.
On Sun, 23 Nov 2003, Jason Pyeron wrote:
>
> I have never seen an error like this one, are the RPMs setup for dynamic
> libraries?
>
> ERROR 1126: Can't open shared library
I have never seen an error like this one, are the RPMs setup for dynamic
libraries?
ERROR 1126: Can't open shared library 'diff.so' (errno: 0
/lib/tls/libc.so.6: unexpected reloc type 0x0$ôç¿_½)
Sincerely,
Jason Pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
Thank you.
Now I read tutorials at the new PHP web site, so my
old
scripts are refurbished and are functional.
I initialize every variable like this:
$var1 = $_POST['var1'];
for example, and values are correctly passed.
Mario
--- Chris <[EMAIL PROTECTED]> wrote:
> You could try http://us2.php.
Thank you. It was the king of advice that I needed,
because I was unaware of the existence of this
parameter.
I was struggling with the lack of mysql support when I
tried
to use the new RedHat 9. When I finally solved that
problem, I became confused with the inability to
transmit
variable values
nge $PHP_SELF to
$_SERVER['PHP_SELF'] (recommended) or turn register_globals on.
http://us3.php.net/manual/en/reserved.variables.php
Chris
-Original Message-
From: Mario Miyojim [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 10:18 PM
To: [EMAIL PROTECTED]
Subject: Needi
Mario Miyojim wrote:
I am trying to revive an existing LAMP system.
I recently installed RedHat9. I had several LAMP
applications
working under RedHat 7.1, but now they don't function
properly. For instance, I have many scripts that use
the
construct, but they are not working as they should.
I tr
I am trying to revive an existing LAMP system.
I recently installed RedHat9. I had several LAMP
applications
working under RedHat 7.1, but now they don't function
properly. For instance, I have many scripts that use
the
construct, but they are not working as they should.
I tried to get help from
I am new to SAPDB and install it on Red Hat 9 ...When I wanted to start an
instance ,I encounter with error
24994 runtime environment error [db_online -s] check knldiag ,kernel
died before reaching admin state
and in knldiag i see :
ERR 11330 Corehand Aborting due to Signal 11
For solvin
ect: RE: Compling on RedHat 9
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 11 Sep 2003, Peter Koutsoulias wrote:
> OK, here are the last few lines from make. I configured using the
> following:
>
> ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
>
&g
om> cc: [EMAIL PROTECTED]
Subject: Re: Compling on RedHat 9
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 11 Sep 2003, Peter Koutsoulias wrote:
> OK, here are the last few lines from make. I configured using the
> following:
>
> ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
>
> errors:
>
> libmysql.c: In function `mysql_real
gt; make: *** [all] Error 2
>
> I tried ./configure without the --with-mysqld-user flag. still the
> same errors.
>
If i get it i'll let you know, all i know is a fresh install of rh is
missing alot of libraries therefore its breaks on compiling stuff.
> Coincidently, I spent th
lag. still the same
errors.
Coincidently, I spent the entire day trying to figure out why I couldn't
compile qmail on my RedHat 9 box and found the answer. Apparently, do to
changes in the new glibc, some older practices become incompatible with
glibc and cause a compile error. With qmail,
At 10:22 AM -0400 9/11/03, Peter Koutsoulias wrote:
I couldn't find an appropriate mailing list for compiling MySQL, so I
thought I'd try here.
anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
libmysql.c during the make step. Google doesn't reveal a
;> I couldn't find an appropriate mailing list for compiling MySQL, so I
>> thought I'd try here.
>>
>> anyone successfully compile MySQL 4 on RedHat 9? I keep getting
>> errors on libmysql.c during the make step. Google doesn't reveal a
>> whole l
On Thu, Sep 11, 2003 at 10:22:13AM -0400, Peter Koutsoulias wrote:
> I couldn't find an appropriate mailing list for compiling MySQL, so I
> thought I'd try here.
>
> anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
> libmysql.c during the m
I couldn't find an appropriate mailing list for compiling MySQL, so I
thought I'd try here.
anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
libmysql.c during the make step. Google doesn't reveal a whole lot about
compiling MySQL on RedHat which leave
Hello,
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them.
Thanks Anticipated,
Iulian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
mysqld_multi doesn't start the two groups from my.cnf if I give the start
command immediately after stopping them.
How can I safely start the groups with mysqld_multi anytime (including
immediately after stopping them)?
Thanks Anticipated,
Iulian
--
MySQL General Mailing
Hello,
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them. It will start only one group.
I'm working on Linux RedHat 9 MySQL 4.0.14.
How can I solve this problem, please?
Thanks Anticipated,
Iulian
--
MySQL General Mailing Lis
Hello,
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them.
Thanks Anticipated,
Iulian
.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry for was sending HTML. I didn't noticed it. My default was TEXT and now
I found HTML in the settings ... maybe because of international chars. I
turned it back to TEXT.
Hello,
I installed MySQL 4.0.14 on a new Linux machine unde the form of two
servers: one master and one slave.
I met ma
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 2 Jul 2003, Paul DuBois wrote:
> At 11:33 -0400 7/2/03, Andrew Pierce wrote:
> >I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
> >go from the version that came with the distro (version 3.23.54) t
At 11:33 -0400 7/2/03, Andrew Pierce wrote:
I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
go from the version that came with the distro (version 3.23.54) to the
latest (verion 4.0).
Just thought I'd post to get a heads-up on any known issues or
prerequisites. I just
I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
go from the version that came with the distro (version 3.23.54) to the
latest (verion 4.0).
Just thought I'd post to get a heads-up on any known issues or
prerequisites. I just hate it when I try something like thi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 25 Jun 2003, Luc Foisy wrote:
> Something interesting that may be my problem
> This is a known working install
> # mysql --version
> mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686)
> # find /etc/rc.d -name *mysql
> /etc/rc.d/init.d/
Something interesting that may be my problem
This is a known working install
# mysql --version
mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686)
# find /etc/rc.d -name *mysql
/etc/rc.d/init.d/mysql
/etc/rc.d/rc0.d/K90mysql
/etc/rc.d/rc1.d/K90mysql
/etc/rc.d/rc2.d/S90mysql
/etc/rc.d/rc3.d/S
Hi Christoph,
O.K, what I can say already from your enclosed print is that the server mysqld
is ignoring your settings.
Lets find out why.
Check how your mysql server is started (as mysqld or safe_mysqld) :
ps ax |grep mysql
see that in my case a script is starting mysql-max (Suse Linux)
694
I did find out :-)
I had to edit the mysqld in /etc/rc.d/init.d
It's can be done on a linux partition without problem.
;-)
Jean Christophe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sql running on a redhat-9. (rpm files)
I tried to change the datadir from /etc/my.conf without succes.
What do I have to do to change the directory of my databases from
/var/lib/mysql (default) to /mnt/data/mysql ?
is the fact that /mnt/data a vfat partition a problem (if it is, I can
make it to a
Hi,
I have mysql running on a redhat-9. (rpm files)
I tried to change the datadir from /etc/my.conf without succes.
What do I have to do to change the directory of my databases from
/var/lib/mysql (default) to /mnt/data/mysql ?
is the fact that /mnt/data a vfat partition a problem (if it is, I
48 matches
Mail list logo
