Hi!

I have an InnoDB SHOW Status like that on my master in mysql cluster

===================================== 080515 17:55:09 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds

---------- SEMAPHORES

---------- OS WAIT ARRAY INFO: reservation count 6845098, signal count 6591280 Mutex spin waits 0, rounds 195429057, OS waits 1720902 RW-shared spins 8966432, OS waits 4349329; RW-excl spins 1421308, OS waits 576463

------------ TRANSACTIONS

------------ Trx id counter 2 19639226 Purge done for trx's n:o < 2 19630842 undo n:o < 0 0 History list length 2420 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 2539, OS thread id 1192798560 MySQL thread id 114931178, query id 899943056 192.168.1.222 mysqlDBadmin SHOW INNODB STATUS ---TRANSACTION 2 19639225, not started, process no 2539, OS thread id 1161382240 MySQL thread id 114931174, query id 899943050 192.168.1.224 clickpointnew ---TRANSACTION 1 4134828660, not started, process no 2539, OS thread id 1141680480 MySQL thread id 2, query id 739501255 Has read all relay log; waiting for the slave I/O thread to update it

-------- FILE I/O

-------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 28598023 OS file reads, 17399120 OS file writes, 3446699 OS fsyncs 2.97 reads/s, 16384 avg bytes/read, 13.09 writes/s, 2.78 fsyncs/s

------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX

------------------------------------- Ibuf: size 1, free list len 3329, seg size 3331, 3463985 inserts, 3463984 merged recs, 1711645 merges Hash table size 4728611, used cells 2903216, node heap has 6642 buffer(s) 1448.52 hash searches/s, 3392.14 non-hash searches/s

--- LOG

--- Log sequence number 318 497975339 Log flushed up to 318 497864346 Last checkpoint at 318 351352033 0 pending log writes, 0 pending chkp writes 2413393 log i/o's done, 2.06 log i/o's/second

---------------------- BUFFER POOL AND MEMORY

---------------------- Total memory allocated 2440320762; in additional pool allocated 20971520 Buffer pool size 131008 Free buffers 0 Database pages 124366 Modified db pages 5421 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 53411245, created 648215, written 20904074 2.97 reads/s, 0.62 creates/s, 15.41 writes/s Buffer pool hit rate 1000 / 1000

-------------- ROW OPERATIONS

-------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 2539, id 1140881760, state: sleeping Number of rows inserted 38646557, updated 161882488, deleted 29694772, read 33261219458 63.15 inserts/s, 235.77 updates/s, 17.91 deletes/s, 3430.17 reads/s

---------------------------- END OF INNODB MONITOR OUTPUT ============================

I want to know if everything is ok in having a big jump between OS waits and OS signals. Anyone knows?

Thanks to all

Paola