olve this issue. Thanks for your link also , it is
very helpfull.
Thanks
> See tips in
> http://mysql.rjweb.org/doc.php/ricksrots
>
>
> > -Original Message-
> > From: Adarsh Sharma [mailto:eddy.ada...@gmail.com]
> > Sent: Friday, September 21, 2012 5:09 AM
> > To: my
PARTITION, yet they have not determined that there will be
any benefit.
See tips in
http://mysql.rjweb.org/doc.php/ricksrots
> -Original Message-
> From: Adarsh Sharma [mailto:eddy.ada...@gmail.com]
> Sent: Friday, September 21, 2012 5:09 AM
> To: mysql@lists.mysql.com
> Sub
Just update the string needed function substring(id,9,6).
On Fri, Sep 21, 2012 at 5:18 PM, Adarsh Sharma wrote:
> Hi all,
>
> I created a partition on a timstamp column ( dt_dtamp ) in mysql-5.1.58
> testing table.But as all of us know that partitioned column need to be
> primary key.
> I have al
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Tuesday, February 23, 2010 5:52 AM
To: Jerry Schwartz
Cc: MY SQL Mailing list
Subject: Re: Partitioning
that's very much gonna depend on what your selects look like. For example, a
low-cardin
>-Original Message-
>From: John Daisley [mailto:mg_s...@hotmail.com]
>Sent: Tuesday, February 23, 2010 6:07 AM
>To: jschwa...@the-infoshop.com ; mysql@lists.mysql.com
>Subject: RE: Partitioning
>
>Hi Jerry,
>
>I guess modification of the table is needed! What are
Hi Jerry,
I guess modification of the table is needed! What are you trying to achieve by
partitioning?
If the primary key is rarely used then maybe adding another column with a
numeric value based on `prod_id` and adding that column to the primary key
would work and at least let you do some ha
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 know
that you'll mostly access just last month's data, partition on year+mo
Am Mittwoch, den 05.12.2007, 17:59 +0530 schrieb Krishna Prajapati:
> Suggest me some link for partitioining.
http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitions.html
http://dev.mysql.com/doc/refman/5.1/en/partitioning.html
Norbert
--
MySQL General Mailing List
For list a
