Max,
----- Original Message ----- From: "Deluxe Web" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, February 28, 2005 11:44 AM
Subject: Re: Mysql tuning - server Crash 1
Hi I understand.. I should switch to debian :) but in the meantime what about the innodb buffer pull size Have you seen my variables. I had 8M? Can this be the bottle neck?
yes it may be. Please see:
http://dev.mysql.com/doc/mysql/en/innodb-configuration.html
--Heikki
On Mon, 28 Feb 2005 11:34:31 +0200, Heikki Tuuri <[EMAIL PROTECTED]> wrote: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]
--
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]
