From: Johan De Meersman Date: February 23 2010 10:51am Subject: Re: Partitioning List-Archive: http://lists.mysql.com/mysql/220780 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0050450163335efddb048042564d --0050450163335efddb048042564d Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable that's very much gonna depend on what your selects look like. For example, = a low-cardinality but often-where'd field makes an interesting candidate, as such a partitioning will take the size of your table scans down. If you kno= w that you'll mostly access just last month's data, partition on year+month. YMMV. On Mon, Feb 22, 2010 at 11:23 PM, Jerry Schwartz wrote: > I=92d like to know your opinions about partitioning the following table. > Here=92s the relevant snippet: > > > > Create Table: CREATE TABLE `prod_price` ( > > `prod_price_id` varchar(15) NOT NULL DEFAULT '', > > `prod_id` varchar(15) DEFAULT NULL, > > =85 > > PRIMARY KEY (`prod_price_id`), > > KEY `prod_id` (`prod_id`) > > ) ENGINE=3DMyISAM DEFAULT CHARSET=3Dutf8 > > > > Here=92s the deal. The primary key, `prod_price_id`, is rarely used. Pric= es, > as you might expect, are fetched by `prod_id`. Both keys are randomly > generated strings. (Before you ask, I am not a mental health professiona= l > and am therefore not qualified to judge my predecessor.) > > > > How could I partition this table in a useful way? > > > > Regards, > > > > Jerry Schwartz > > The Infoshop by Global Information Incorporated > > 195 Farmington Ave. > > Farmington, CT 06032 > > > > 860.674.8796 / FAX: 860.674.8341 > > > > www.the-infoshop.com > > > > --=20 Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0050450163335efddb048042564d--