Max,
maybe the 640 connection piled up because mysqld was hung?
It is not very likely that all those threads would have taken > 3 MB of memory. Usually they take much less.
The best advice is to upgrade to a recent 4.0.xx or 4.1.xx version of MySQL, which may print more info in a hang.
An upgrade to a more recent Fedora Core might also help.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
----- Original Message ----- From: "Deluxe Web" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, February 28, 2005 9:13 AM
Subject: Re: Mysql tuning - server Crash 1
In my .err. file I have ---------------- key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=652 max_connections=1000 threads_connected=640 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2184184 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. ---------------
With my 2GB RAM I think I reached the maximum. Shall I consider linux swap memory, which is of 2GB? Please advise. Can you help me undertand if an increase of RAM will fix the problem.
On Sun, 27 Feb 2005 18:00:29 -0600, Donny Simonton <[EMAIL PROTECTED]> wrote:Heikki, I sent this to a few friends of mine who work on fedora quite a bit.
> As a general note, Fedora Cores are not considered stable.
None of them wanted to officially comment, but just asked that you show proof. Especially since most of RH4 is Fedora.
I know I've used FC1, FC2, and FC3. And on fc2 and fc3 the 32 and 64 bit versions. And besides certain ide problems which I would never use on a mysql server anyway, we've never had any problems with fedora at all.
They wanted me to send you some of the benchmarks comparing Fedora, Suse,
and some of the other distros using mysql. But the site they sent me which
shows fedora beating all of them is currently down.
Oh well.
Donny
> -----Original Message-----
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 27, 2005 2:58 PM
> To: mysql@lists.mysql.com
> Subject: Re: Mysql tuning - server Crash 1
>
> Max,
>
> ----- Original Message -----
> From: "Deluxe Web" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Sunday, February 27, 2005 2:17 PM
> Subject: Re: Mysql tuning - server Crash 1
>
>
> > Hi Heikki,
> >
> > http://lists.mysql.com/mysql/180583
> > http://lists.mysql.com/mysql/180581
> >
> > Running fedora core1
> > Mysql: 4.0.16-Max-log
> >
> > If you check http://lists.mysql.com/mysql/180583 (.err) you will see
> > errors.
>
> does that contain ALL relevant info?
>
> > Let me know if you have any questions.
>
> You should upgrade to 4.1.10. We might get better error diagnostics > then.
>
> As a general note, Fedora Cores are not considered stable.
>
> > Thank you.
> > I appreciate your help!!
> >
> > Max
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> Foreign keys, transactions, and row level locking for MySQL
> InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
> MyISAM
> tables
> http://www.innodb.com/order.php
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Deluxe Web [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
