… a later date. For example, if a database isn’t owned by MySQL, … A runaway server process, or poorly optimized queries, can consume too much …application environment makes it difficult to handle max_connections problems (the use of fixed…, so you can (for example) get the incremental increase in a …
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… results from this aggregation get a second distributed reduce… but right now only MySQL storage nodes are supported….date on ontime_fact.date_id = dim_date.date_id where dim_date.Year IN (2008,2009) group by 1; –PARALLEL OPTIMIZATIONS…aggregation_tmp#74082863` ; Edit *MIN/MAX are only distributable …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…, `FlightDate` date NOT NULL, `date_id` smallint(6) NOT NULL, PRIMARY KEY (`date_id`), KEY `FlightDate`… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘…max-allowed-packet=1M net-buffer-length=16K #we value throughput over response time, get a good plan optimizer…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…(@mvid,’GROUP’,’DATE_FORMAT(order_date,”%Y%m”)’,'…get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0 rows affected (41 min 52.04 sec) *If you use MIN/MAX…optimization which is required to efficiently refresh MV which use those aggregate functions. Now I delete some line items from orders: mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…with these commands: date uname -a cat…at MySQL status Now we’re starting to get into…mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max…query, and index optimization Analyzing and optimizing a server…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…varchar(64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128)…mysql- –with-falcon mysqld startup params: Falcon: libexec/mysqld –no-defaults –user=root –falcon_min_record_memory=1G –falcon_max… final result we get a maximal result … engines are maximally optimized and the result…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…need for optimization when replication can’t catch up but yet optimization process we…to work. Get the log file which will include all queries MySQL server ran….41M rss, 170.38M vsz # Current date: Mon Jul 19 15:12:24 2010 … QPS, 0.37x concurrency ______ # total min max avg 95% stddev median # Exec …
