James (jamesd) wrote in lj_dev,

Filetmignon CPU-limited how?

Is show innodb status and Mytop data available? Particularly Mytop with any long-running queries, if they are taking long enough that the problem is an accumulation of enough others to hit a connection limit. Anything interesting in the slow query log?

For the majority who don't know me, I do database-related things for Wikipedia. Wikipedia accepts the queries, kills the slow ones and uses a high enough connection limit (with higher tolerance for slow responses than LJ) to allow several hundred queries to accumulate during a long one or few. Any unusually long ones get killed with Querybane, based on server load and run time at the time the query is happening.

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded