hi,
I now test Mysql+innodb performance, my platform is Solarise 5.8 1G RAM .
I use my-huge.cnf, set the buffer_pool_size = 400M , my bench table is about 100M .
I run 10 threads to Query a innodb table. Query 10000* 10 thread would cost 30 second
. When I look the Innodb monitor , i fund :
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf for space 0: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 1660247, used cells 0, node heap has 1 buffer(s)
0.00 hash searches/s, 2471.41 non-hash searches/s
Why the Hash search = 0? thanks!
Tony chen
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
