Daniel,
----- Original Message ----- From: "Daniel Andersen" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, December 21, 2004 1:04 AM
Subject: Re: Weird load issues
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?
queries are processed by mysqld.
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.
Please see http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
I'm not much of an expert on InnoDB, what would be a good buffer size in your
opinion?
Please see http://dev.mysql.com/doc/mysql/en/InnoDB_configuration.html
Daniel
Regards,
Heikki
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
