…a client who has MyISAM tables with many columns (the same one Peter wrote about recently). The client’s performance is suffering in…of query performance time for all three databases…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…SQL interface to it (the meta-tables are still a…a custom table, which is really constructed behind the scenes from the name-value tables in a complex query…a database? You have your choice of buzzwords these days. Hadoop is a big one. But beware of falling into the trap of…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…Query is a smart database proxy that can add parallelism. In this mode it will add additional six degrees of parallelism the query…queries together. This query is single threaded, and thus this serves no purpose. It will be much more important in a moment. — AGGREGATION SQL…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…a node from here on out. Shard-Query is very flexible in it’s configuration, so you can use this sample database…sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…in this blog post. Many database servers can add this parallelism natively, but most of those are not open source. In the future, Shard-Query…Query. As the name implies, it takes a list of queries in a file (or stdin) and a config file. It runs the SQL…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…in chunks so it is even harder to implement. Might not work with transactions – Different transactions may see different states of the database…queries to compose so it is efficient to cache whole objects rather than individual queries. No control on invalidation Table…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
…of SQL which a ROLAP tool must generate to answer those queries. Performance challenges with larger databases…of the partially denormalized nature of a star schema, the dimension tables in a data mart may be updated. In fact, there is a term for such a dimension – A…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…of Database Market, leaving this for Market talks, my interest is market of Web Applications in general. Clearly web is not enterprise and has a…of customization of data store and processing was using non SQL and not systems – Google Big Table…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…a temporary table is required for query execution Tmp_table will be set. Sometimes that table must be created on disk instead of in memory, in…database traffic, it’s considered experimental and as such I don’t recommend using it in…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
…of change in the database tables. This results in unpredictable and therefore, undesirable, performance. The other big problem with the query…SQL commands can be used to either replace the contents of, or insert new data into the summary table. One advantage of summary tables…
