…, and now it is good time to summarize features we have and what is expected soon. This release contains long waited features from 5.0… is: InnoDB pagesize, so you will be able to specify 4K, 8K, 16K pagesize when you created database InnoDB fast checksums, idea… Full list of XtraDB engine features (what makes it different from InnoDB-plugin) on the state as it is right now: Performance improvements…
Post: MySQL Quality of old and new features
October 4, 2007 By 24 Comments
… different from new features in terms of possibility of breaking things. These raise few questions in my head: What is MySQL Current Bug… there is no good errata documentation which would outline which things have known problems which MySQL can’t fix fast. What is the… MySQL 5.0 release so being careful is the best. It also may be good idea to sample queries from your application…
Post: How reliable RAID really is
June 30, 2006 By 11 Comments
…in this situation. What one would like to do in such case is to fore SCSI…is much better than loosing everything. Unfortunately neither RAID BIOS nor RAID tools do not provide you with such feature… is of course chance some data is corrupted so checking file system and MySQL database is good idea….
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…Yahoo and develop the new “Applet” which will be featured on the front page you quite likely start …tend to have higher cost of downtime. So now what is about using your Own Resources vs Hiring Consultants ? … them as optimization is as art as it is science and each expert may his own ideas which may …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…asynchronous writes. The idea behind the log-based solution, on the other hand, is to avoid the …yet support incremental backup, but this is planned. Internally this feature is implemented by PBXT using an MVCC-…of data will become less and less important. What is the page size in PBXT, and can it…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… or views so you rarely would scratch your head thinking what is this query you peer has written suppose to do. Of… and is able to support if needed. What scares me in MySQL Development is what is is quickly leaving this Commodity Space in terms of overall feature…, other may be good with MySQL Cluster but have no idea how to write storage engines or optimize for Falcon storage…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… OLAP workload features a low number of concurrent queries which each examine large amounts of data. Since a single query is single… available resources (that is, scale better) when running small numbers of queries which examine a lot of data. What is Shard-Query? Shard… host in parallel, with the added feature of supporting aggregation. Then I hit upon the idea of taking SQL constructs like IN…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… in profile search is rather simple full text search features are required. As ordering is not done by relevance what is required is simple boolean full… though is often supported by search engine directly and it is good idea to see if that can be used The other one is… at Features in FaceBook search I found number of features missing which would likely be great value for the users. This is of…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… past. However, if you think about Core idea of the MySQL Query Cache – it is great. The transparent cache which does not… sometimes dangerous feature. I’m not quire sure if it is worth doing or if delayed invalidation is enough. Improve Manageability What is in the…. This is especially the problem for very expensive queries. The good thing about MySQL Query Cache is it knows exactly what is needed to…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… a bit about features and limitations of Query Cache: Transparent Caching – Caching is fully transparent to the application, and what is very important it… it is hard to tell what is good or bad as a lot depends on statement complexity as well as how much work is… set will be offering best speed up. So when it is good idea to use query cache ? Third party application – You can…
