May 24, 2012

Comment: Percona Server now both SQL and NOSQL

… engine operations ( SQL Parsing, Query analyzer etc.. ), but while using handler socket to have massive concurrent writes thus bypassing all those operations… 16 core machine to process requests with the traditional mysql socket but slave process the binary log using HandlerSocket it might… format, while the slave will read the HSbinlog straight into handler socket write socket :) . I am sure it’s not that easy, you…

Comment: What's up with HandlerSocket?

… It would be strange for me to see someone using Handler Socket actually looking to use query cache at the same time… fixed some way, whenever it is disabling query cache if Handler Socket is enabled or actually invalidating items is enabled is both…

Comment: What's up with HandlerSocket?

… It would be strange for me to see someone using Handler Socket actually looking to use query cache at the same time… fixed some way, whenever it is disabling query cache if Handler Socket is enabled or actually invalidating items is enabled is both…

Comment: High Rate insertion with MySQL and Innodb

… would not expect significant gains from Handler Socket in this case. The main gain from Handler Socket is a lot of small selects as…

Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!

… interested in Replication? Come see others speak on topics from Handler Socket to Programmatic Queries. With 45 sessions not including the keynotes…

Comment: What's up with HandlerSocket?

By convenience I mean that my existing application continues to work unmodified which is not the case with handler socket. I also mean that all existing technologies, libs and tutorials work (not the case). The move towards nosql is driven primarily by performance but only few need it.

Comment: What's up with HandlerSocket?

… you’d want support in PHP_MYSQLND, etc. Or would handler sockets just work with those drivers (looser abstraction layer)? Naturally, the…

Comment: What's up with HandlerSocket?

By convenience I mean that my existing application continues to work unmodified which is not the case with handler socket. I also mean that all existing technologies, libs and tutorials work (not the case). The move towards nosql is driven primarily by performance but only few need it.

Comment: What's up with HandlerSocket?

… you’d want support in PHP_MYSQLND, etc. Or would handler sockets just work with those drivers (looser abstraction layer)? Naturally, the…

Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5

… than 8 cores effectively (which would correspond to single CPU socket these days) Here are some more details. oprofile: 867964 15…,row_search_for_mysql,ha_innobase::index_read,handler::read_ra nge_first,handler::read_multi_range_next,QUICK_RANGE_SELECT::get…,row_s earch_for_mysql,ha_innobase::index_read,handler::read_range_first,handler::read_multi_range_next,QUICK_RANGE_SELECT::get…