Hi all, I'm currently experiencing some very strange behaviour at my MySQL server.
Our production server is a Sun-E4500 (8x400 MHz 4 GB Ram running Solaris 8 and Solstice Disksuite...) and a single A5000 "Storedge" with 127 GB disk space (12x9.1GB @ 10K RPM) array connected over a single FC-AL adapter. The MySQL server we use is 4.0.17 and as all queries such as select and insert are really fast, all "update" queries are extremely slow. In numbers it is 17 seconds for a single update query on a 500K record table which looks like this : AGID | int(10) unsigned | | PRI | NULL | auto_increment period | datetime | | MUL | 0000-00-00 00":00:00 | key_ | varchar(100) | | MUL | | type_ | tinyint(3) | | MUL | 0 | name | varchar(100) | | | | value | int(100) unsigned | | | 0 | lastrun | datetime | | | 0000-00-00 00":00:00 | acl | varchar(50) | | | | Now my question : Is this problem a hardware problem (are there any sun specialists here) or are there any known issues with solaris/sparc/a5000 and MySQL any special configuration needed.The server is not under heavy load compared to a single 600 MHz CPU Intel/Linux machine which can handle this tasks without any problems. For the config of the MySQL server we used the configuration described in the current handbook of MySQL. We are really desperate about this machine at the moment since we are not very experienced Sun/Solaris admins and until now tried every trick we could think of to get a bit more performance. If you need more config data please name it and I'll send you all I can get hold off. ______________________________________________________________________________ Nachrichten, Musik und Spiele schnell und einfach per Quickstart im WEB.DE Screensaver - Gratis downloaden: http://screensaver.web.de/?mc=021110 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
