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