Percona's MySQL & InnoDB performance and scalability blog
… will beat string indexes – unless you need to search by partial matches like ‘abc%’. But we’re talking here about mysql behaviour…
…/Key_read_requests. [Note: their use of 'rate' doesn't match mine; I would call this the 'miss ratio']. The problem… optimizing-by-counter never worked! A partially valid use of Key_reads There is a partially valid reason to examine Key_reads….” And now, I would finally like to show you something partially useful you can do with Key_reads: [baron@localhost ~]$ mysqladmin…
… design, which I previously should have kept private as I partially got them while working for MySQL. These thought base on… to see more configuration options to adjust database behavior to match my needs. I love this Zero administration thing and I… where detailed documentation is missing so far. [-] No protection from partial page writes This means if single page write was not…
… SHOW STATUS “Handler” statistics to see if number of operations match. EXPLAIN works for SELECT only This is in works to… enough to perform sorting or use temporary table with partial result set (partial rows) and than compose full rows by reading data…
… will be corrupted by unproper shutdown, it will fail with partial statement execution if certain errors are discovered etc. You should… is better choise for general purpose storage engine – it better matches what you would expect from database server and saves you… later cause crashes wrong query results and further data corruption. Partial updates. MyISAM is does not have transactions this is well…
… the product and to your marketing or positioning, to better match the true needs of your potential clients. It can also… other words, vendors can’t hire us to do a partial or inconclusive evaluation; we require that the evaluation is full… reach a mutual understanding that it isn’t a good match and we don’t form any formal relationship at all…
… use of MyISAM FTS, the idea of a complete or partial migration was, for one reason or another, an impractical solution…, in the sense that the SQL required to run a MATCH .. AGAINST is the same (modulo any new features introduced with…
… graph of memory usage: ms_print /tmp/massif.out An partial example output from a recent customer problem we worked on… Massif’s snapshot options and other cmd line options to match the snapshot frequency etc. to your specific requirements. However, you…
… this success is partially because we’re fair to our customers. Our pricing model has always been to match value for the…
… if you recover master you need to recover slaves to matching snapshot – either it has to be same state (which is… life environments can be even more complicated – one may use partial replication, replication to different storage engine, add some tables beyond…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.