…be if they have LVM installed or have some systems with similar features… general works. Really there are different implementations but the sake of them … you. In other cases snapshot may be implemented by tripple-mirroring. Ie you … unlock the tables, but before that you should probably record binary …
Post: MySQL Quality of old and new features
October 4, 2007 By 24 Comments
…optimization was implemented in MySQL 5.0. Surely Baron is right Bug fixes are not much different from new features …in MySQL 5.0 release so being careful is the best. It also may be good idea to sample queries …this way but it can be helpful for basic query bugs at least. Plus it is not that hard to …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… tables use different engine types. The API does not yet support incremental backup, but this is planned. Internally this feature is implemented by… to be unlocked before it continues. The affect is that the init function returns quickly, but the first queries that access PBXT tables may…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… I see so far with this feature are ease of use and requirement to… pages and uncompressed index pages can be significantly different. Q2: Does Innodb has pointers… not resolved by index HT: That is already implemented in 5.1: if you… pages in buffer pool it well may be faster to do 1 write than…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…implement MySQL Query Cache so it is lockless ? I believe it may be…by different developers. Supporting different …may not want changing that to have complete invalidation. Having the option to have some updates not to invalidate query cache can be powerful, though sometimes dangerous feature…
Post: MySQL should have dynamic durability settings
April 8, 2008 By 4 Comments
…different transactions) have different durability requirements. For some of updates you really would hate to lose them, though they may be…be implemented to utilize delayed commit for the replication thread. This is surely not standard at all but could be…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
…be hard depending on how search is implemented…be expensive – ie FaceBook does the ranking depending on “approximation of social graph distance” which is different… see if that can be used… – there well may be some of …Features in FaceBook search I found number of features missing which would likely be…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
…different concepts both in terms of performance properties and transaction implementation details Falcon is unlikely to be… may be handling of long transactions (spilling bonsai tree to the disk may not be that… to be accumulated. It is worth noticing different storage engines and features have …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…scalability fixes. Adding up all the new features, you have a great release. However, …that a single I/O may have a size of 32K, 64K, 96K, …, etc. And again, that…that for Percona Server the best choice is innodb_buffer_pool_instances=1, as we implemented buffer pool scalability in a different…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… Sphinx which is currently implemented as storage engine for… all workloads. Well this may be too much of the… MySQL Cluster would ever be that thing as it provides …to come up with different consistence guaranty and semantics……being Solid. By by being Solid I mean Solid functionally complete features…
