Hi, I'm using: Tyan m/b, 2x U160 scsi disks, dual Athlon MP CPUs, 2Gb RAM + 2GB swap RH 7.3, 2.4.18-5smp kernel MySQL 3.23.51 (MySQL Linux tar.gz) binary used based on the comments on the download page about gcc 2.96 compiled versions resulting table corruptions, etc.
I have a couple of questions: Does anyone have any more information about gcc 2.96 on the x86 Linux platform? Has anyone been able to duplicate the problems themselves or understand their exact cause? Is the binary optimised for SMP systems? I've searched for more information on these issues, without luck. The system randomly spirals out of control - load avg increases very rapidly, resulting in loads of 200-300 in 2/3 minutes. At other times the server is fine, handling the busiest loads. It doen't appear to be using any swap space at all (0K) - the 'mysqld' process size gradually has grown to the point where no free RAM was available and 'spiralled' , but that isn't the general case. Restarting MySQL cures the problem, although system memory isn't being reclaimed (see below) I also have a memory related problem - the system doesn't free memory when MySQL is stopped and started. (I suspect this may be a kernel related issue) RH have released a kernel update 2.4.18-10, which apparently fixes a problem with the filesystem cache - could this be related? (Again, I've been unable to find more information on the subject) As a result I'm tempted to try a compiled version (all tests ran fine, as did MySQL 3.22 in the past) Is a stability/corruption free MySQL guaranteed using gcc 2.95.3? Thanks to everyone in advance bill --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
