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]
