… with systems that are at any level of tuning, from completely untuned to a system that’s … operate. For example, if the workload is a star schema data warehouse, it is important to know a … most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL server …
Post: How to estimate query completion time in MySQL
April 22, 2008 By 14 Comments
… typical data-warehousing query needed optimization. It was a fact table joined to two dimension tables — a classic star schema query. The fact table was very large, and after some tuning (I’ll write more about that later) I convinced MySQL to…
Comment: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… applications have only a few queries to tune, rather than being truly any column at any time queries. 4. Why virtual servers were used instead of multiple instances of MySQL… some extent these questions are missing the point about generic star schema queries that you’re really looking at but it’s interesting…
