On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote: > Daniel, > > it is simply processing big SELECT queries. Maybe their optimization > changed lately? You should tune your queries. > > You should also tune InnoDB, because you are running with the default 8 MB > buffer pool size, and it is reading in 6000 pages per second! > > Best regards, > > Heikki Tuuri > Innobase Oy > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM > tables > http://www.innodb.com/order.php
Hey, The only thing thats changed recently is that the machine had a power outage, thus the low uptime. Otherwise nothing has changed in ages. In any case, if it was a query wouldn't the load derive from one of the child processes, not the parent? It used to handle just as many queries perfecty well before the reboot, and as far as i can tell nothing has occurred to increase the number of queries coming through. I'm not much of an expert on InnoDB, what would be a good buffer size in your opinion? Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
