Tony, ----- Original Message ----- From: "³Â ½Äþ" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, November 29, 2002 8:08 AM Subject: Innodb Hash search
> 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! if you have many recurring index searches to the same rows, and those rows are not modified or flushed out of the buffer pool, then there should be hash searches. Difficult to say anything in this case because I do not know the query load nor EXPLAIN SELECTs. > Tony chen Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- 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