Maximo, ----- Original Message ----- From: "Maximo Migliari" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, November 13, 2002 11:31 PM Subject: MySQL load problems.
> Hello all, > > I've been having some problems with MySQL crashing. I use a mixture of > MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My > web applications all do relatively complex join queries. Almost all fields > in the WHERE clauses of queries are indexed. > > I'm running RedHat 7.2, and MySQL version is 3.23.53a > > The server is: > PIII-866 Mhz, > 512 MB RAM > 18 GIG SCSI drive (no RAID). > > The server acts as an Apache server AND as a MySQL server > > The server seems to work fine and has +- an uptime load of 1 - 1.5 when > MySQL is running arround 20 queries/sec > When it reaches about 30-40 queries/sec, the machine goes to 3-5 load in > uptime, often registers slow queries, and eventually dies without any error > messages (except that the socket file doesn't exist - i.e. crash). can you send me the error log yourhostname.err from the datadir of MySQL? I could try to resolve stack traces from it if any. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB --------------------------------------------------------------------- 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