Re: MySQL load problems.

Hi Maximo, > How should I set my memory usage in my.cnf I have a hard time > understanding how MySQL works with memory, how it manages it, etc. What > should I consider when setting my memory settings??? I have included a > paste of my.cnf > > # The MySQL server > [mysqld] > port

Re: MySQL load problems.

Maximo, - Original Message - From: "Maximo Migliari" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, November 13, 2002 11:31 PM Subject: MySQL load problems. > Hello all, > > I've been having some problems with MySQL crashing. I

MySQL load problems.

Hello all, I've been having some problems with MySQL crashing. I use a mixture of MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My web applications all do relatively complex join queries. Almost all fields in the WHERE clauses of queries are indexed. I'm running Red

MySQL load problems.... almost forgot

Almost forgot to say, I'm running mysql with the following command: ./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries - Before posting, please check: http://www.mysql.com/manual.php (the manual)

MySQL load problems.

Hello all, I've been having some problems with MySQL crashing. I use a mixture of MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My web applications all do relatively complex join queries. Almost all fields in the WHERE clauses of queries are indexed. I'm running Red

MySQL load problems.... almost forgot

Almost forgot to say, I'm running mysql with the following command: ./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: MySQL load problems - gcc-2.96?

[EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: > FWIW, reproducible testcases are good... all complex software products > have bugs (MySQL, gcc 2.95.x, gcc 2.96RH, gcc 3.0.x, egcs), often in > interaction with oneanother (e.g. timing/locking issues), so > reproducible testcases are a necessity

Re: MySQL load problems - gcc-2.96?

"Mike Robinson" <[EMAIL PROTECTED]> writes: > Thanks for your note. > > You wrote: > > > > > There are known problems with gcc-2.96 which comes with RH 7.2 > > distribution. There is disclaimer about it at > > www.mysql.com/downloads/mysql-3.23.html as you noticed. > > There is much reading

Re: MySQL load problems - gcc-2.96?

Mike, BTW, have you been able to build Mysql 4.0 under RH7.x from the development tree lately? I keep getting some missing definitions messages as of last week, when I performed a regular 'bk resync'. Prior to that, all had been just fine. TIA, Vadim P. Mike Robinson wrote: > > Hello to all,

RE: MySQL load problems - gcc-2.96?

Vadim P. writes: > Mike, what kind of problem? What exactly goes wrong with PHP4? > > Thanks, > Vadim > > Mike Robinson wrote: > > > > > I am able to reproduce this problem very easily, including on > > Redhat-7.2. Basically, any app using the libmysqlclient.so > > compiled with gcc-2.96 connecti

Re: MySQL load problems - gcc-2.96?

Mike, what kind of problem? What exactly goes wrong with PHP4? Thanks, Vadim Mike Robinson wrote: > > I am able to reproduce this problem very easily, including on > Redhat-7.2. Basically, any app using the libmysqlclient.so > compiled with gcc-2.96 connecting to a server compiled with > gcc-2

RE: MySQL load problems - gcc-2.96?

Thanks for your note. You wrote: > > There are known problems with gcc-2.96 which comes with RH 7.2 > distribution. There is disclaimer about it at > www.mysql.com/downloads/mysql-3.23.html as you noticed. There is much reading on the GCC 2.96 issue. There seems to be two paths of dicussion.

Re: MySQL load problems - gcc-2.96?

Hello, Mike Robinson wrote: > Hello to all, > > I've had some severe issues on redhat-7.x boxes and > mysql compiled from source with gcc-2.96 much like > the warning states on the download page. On these boxes, > more than say 20-25 concurrent or near-concurrent connects > produced unexpected re

Re: MySQL load problems - gcc-2.96?

On Sun, May 12, 2002 at 12:06:33PM -0400, Mike Robinson wrote: > Hello to all, > > I've had some severe issues on redhat-7.x boxes and mysql compiled > from source with gcc-2.96 much like the warning states on the > download page. On these boxes, more than say 20-25 concurrent or > near-concurren

MySQL load problems - gcc-2.96?

Hello to all, I've had some severe issues on redhat-7.x boxes and mysql compiled from source with gcc-2.96 much like the warning states on the download page. On these boxes, more than say 20-25 concurrent or near-concurrent connects produced unexpected results with PHP4. Replacing the binaries c