Percona's MySQL & InnoDB performance and scalability blog
Fabian, – please note that, as stated in the article, this technique only works well for highly selective attributes. … this. Please see “Highly selective columns only” section for examples where it doesn’t work well for us too.
does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?
the links here are useful and informative…
Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering 
Thanks for sharing.
Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.
…the replication topology when using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is the…the other one is from s0 (for s0 which is crashed, the server UUID can be read in the auto.cnf file in the datadir). So the last executed event is…
…where even under just a moderate load on the host system, DRBD can end up in a split-brain situation. Typically DRBD is run in…the lower-level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is…
…the dirty tablespace files while streaming the redo-logs to ensure that all transactions are also captured. The –apply-logs phase simply utilizes the built in…my colleagues (thanks Bill Karwin!), the cumbersome part of this process is the DISCARD/IMPORT TABLESPACE step as that is…
…the command line is shorter and neater. In my case here is the properties file in use for my…is where Metadata files come in to play Creating a Metadata File The format of the metadata file is XML-based. I have included the metadata file…
…Is the tuple comparison independent of sorting order? Wouldn’t it be a problem if the keywords were returned in a different order from what you specify in the query? The tuple comparison you’re referring to is this example: WHERE…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.