Vadim, Is it Mutex which protecting Index lock or is it RWLOCK ? I see no reason why readers should block other readers in either of them ?
Comment: Index lock and adaptive search - next two biggest InnoDB problems
March 3, 2010 By 12 Comments
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… 24 core system. For comparison you can checkSysbench Results which Vadim published. For read only workload we get 17x gain from…_array_wait_event,rw_lock_s_lock_spin,pfs_rw_lock_s_lock_fu nc,btr_search_build_page_hash_index,btr_search_info_update…_array_wait_event,rw_lock_x_lock_func,pfs_rw_lock_x_lock_fu nc,btr_search_build_page_hash_index,btr_search_info_update…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… only contain data pages – it also contain adaptive hash indexes, insert buffer, locks which also take some time. Though it is not… memory allocated by Innodb is typically a bit over 13GB. Vadim has posted some numbers on it a while back. After… cache because there is no copying, due to adaptive hash indexes, ability to buffer writes and number of other factors so…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… to do it online, no needs to lock or shutdown server. To export table you need…–backup –tables=tpcc.order_line* –target-dir=/data/vadim/mysql/export/ xtrabackup: tables regcomp(): Success xtrabackup …/order_line is started. InnoDB: import: 2 indexes are detected. InnoDB: Progress in %: 1 2 …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… do not have much resources for scalability research. Peter Zaitsev, Vadim Tkachenko, Yasufumi Kinoshita, and Mark Callaghan from outside Innobase have… implement online reorganize which locks and reorganizes small portions of table online. Q38: Seems that adaptive hash indexes are not used for…
Comment: Full text search for all MySQL Storage Engines
February 28, 2007 By 37 Comments
…? I’m currently using MyISAM becasue of the fulltext index for two forums. Size is 2 Million records and …’m very unhappy about using MyISAM for obvious table locking reasons and issues. The combination of complicated (long) search + … sphinx would a better solution? Regards to you and vadim Gunnar
