… will beat string indexes – unless you need to search by partial matches like ‘abc%’. But we’re talking here about mysql behaviour…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…/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…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… 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…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… 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…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… 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…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
… 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…
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
… this success is partially because we’re fair to our customers. Our pricing model has always been to match value for the…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… 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…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… better analyze word frequencies and build stop word list which matches your application. For example “A6″ unlikely needs to be stop… safe to search a very complex query and just get partial results if it can’t complete in time. From Relevance…
Comment: Alternatives of PHP ?
September 10, 2006 By 28 Comments
… done in modules written in C/C++ – XML processing, regexp matching, sorting and even MySQL Client. If you need something else… error, so you could display nice error message instead of partially created page. Yes these are often caused by development errors…
