4 ms·
I wonder if using the memcached plugin for InnoDB[1] would speed things up even more, at the expense of not having flexible queries (and thereby introducing mul
by xrstf 10y ago
I wonder if using the memcached plugin for InnoDB[1] would speed things up even more, at the expense of not having flexible queries (and thereby introducing multiple roundtrips) anymore. Presumably, they are using simple "SELECT * FROM table WHERE id = ?" in most places anyway, so that could be an okay tradeoff to make.
[1] https://dev.mysql.com/doc/refman/5.6/en/innodb-memcached.html https://dev.mysql.com/doc/refman/5.6/en/innodb-memcached.htm...
- stplsd 10y agoI wonder about this myself, anyone has experience using this? MySQL 5.6 brought many long awaited features, like schema update without locking tables https://dev.mysql.com/doc/refman/5.6/en/innodb-online-ddl.html https://dev.mysql.com/doc/refman/5.6/en/innodb-online-ddl.ht... (bye bye Percona tools).