Hi!
I have received several emails from people that choose not to (or can not)
post to the list about mysql segfaulting.
At the moment, I have the segfaults stopped by doing all of the below, I
don't know (yet) which are to blame or in what combination:
1) Eliminate insert delayed (not really needed anymore, anyways)
2) No fulltext search
3) Increased file descriptor limits (again!)
4) Find and eliminated bad format queries, particularly insert delayeds that
cause a error.
After a few days of no segfaults, we are going to allow fulltext again, the
other changes can (and should) remain permanent.
NOTE: From the emails I received I could find two trends that _may_ be the
source of segfaults:
1) Not enough allowances for open files (#3 above)
2) Insert delayed AND poorly format queries AND high load
REQUEST: Can we make an option in mysqld to log bad queries? Re: 'You have
an error in your SQL syntax ...'
PS - we do not use autoincrement in insert delayed tables.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
---------------------------------------------------------------------
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