On 12/7/06, David Sparks <[EMAIL PROTECTED]> wrote:
Kevin Old wrote:
> Hello everyone,
>
> We have a 4 CPU master server running the 5.0.27 RPM x86_64 version of
> MySQL with a mix of InnoDB and MyISAM tables.
>
> We normally run at 1500 queries/per second and lately, the server will
> all of a sudden lock up and we are forced to restart mysql.
That isn't a crash.
Can you still connect to the db? If so output of 'show full
processlist\G', etc would be useful.
Sorry, I shouldn't have worded it as a crash. Basically what happens
is that queries start stacking up and if we don't start killing
queries, we have to restart mysql before it crashes/restarts itself.
We have spotted a couple of queries that we think might be causing the
problems, but even after adjusting the queries and the tables
(converting from InnoDB to MyISAM) we're still seeing the spike in
queries (not due to actual load).
Here are links to our my.cnf and the output of "show innodb status" and of
"show variables":
http://kold.homelinux.com/bj/my.cnf
http://kold.homelinux.com/bj/innodbstatus.txt
http://kold.homelinux.com/bj/mysqlstats.txt
Maybe some of our settings could be causing the problem.
Thanks for any help,
Kevin
--
Kevin Old
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
