MySQL Forums
Forum List  »  InnoDB

Re: Innodb bogs down on complicated query(ies)
Posted by: Heikki Tuuri
Date: May 18, 2006 07:41AM

Hi!

The workload inside InnoDB was only moderate. Only 11,000 rows read per second, and few file reads. The bottleneck probably was elsewhere. A slow /tmp directory might have been the explanation, or large CPU usage in the MySQL SQL interpreter.


1.02 reads/s, 25693 avg bytes/read, 0.12 writes/s, 0.12 fsyncs/s

----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 317355144; in additional pool allocated 3269376
Buffer pool size 16384
Free buffers 4959
Database pages 10716
Modified db pages 10
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 10707, created 9, written 2707
1.60 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
1 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Main thread process no. 11043, id 32777, state: sleeping
Number of rows inserted 910, updated 572, deleted 418, read 50186074
0.05 inserts/s, 0.05 updates/s, 0.00 deletes/s, 11231.62 reads/s

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Innodb bogs down on complicated query(ies)
2727
May 18, 2006 07:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.