Percona's MySQL & InnoDB performance and scalability blog
… sphinx based on attributes, but memory consumption is exaggerated, so we applied the technique described here, but the search results have gone from…
the links here are useful and informative…
Fabian, – please note that, as stated in the article, this technique only works well for highly selective attributes. …
… that does NOT have the SUPER …s memory usage and you see that it’s…the most interesting question asked; my initial reaction was, honestly, why…the performance being all that fantastic, and I could see network latency wreaking havoc with MySQL’s internal understanding of what’s happening on the system…
…the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought…the duplicate index. Does it mean that tools like pt-duplicate-key-checker will not be necessary for MySQL 5.6? Let’s…, but also for filtering by just the first one. Why can’t MySQL enforce this kind of…
… about the importance of performance at low concurrency. The SSB The SSB tests a database’s ability…MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I …. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least for…
… does that on the fly. If you are using sphinxql, you can actually just list all the indexes you want to merge on the fly (e.g. SELECT cols FROM idx1p0,idx1p1,idx1p2 WHERE …), otherwise if it’s more convenient that the index looks as if it was one index, you…
… — exactly, I think this really applies to any multi-writer system. second comment, first paragraph — I’d argue this is a… (or Tungsten) too — huge transactions just gum up the works, it’s just Galera’s synchronous nature that turns it from inconvenient to… via pt-archiver and similar tools. I do believe that’s the “right” solution. second comment, second paragraph — yes, total transaction execution…
… I use SSD for L2ARC, I’ll need to do the same for xfs… I am redoing my tpcc test with… 20GB memory from the Innodb buffer pool to give it to the filesystem. I took a look at OmniOS but frankly it was the…
… to one of these aspects at the cost of the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors… replication, and those which replicate at some other layer of the system stack) and then conclude with some typical use cases where…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.