Johan De Meersman <vegivamp <at> tuxera.be> writes:
>
> I did some quick math, and it comes down to 1.5 records per second on
> average. Even with peak loads, this is doable without the annoying
> manual partitioning, I think.
A major benefit of partitioning is the ease of maintenance (running
operations like optimize/mysqlcheck).
Coming to the original question -
>
> On 11/5/09, || Sudhir Nimavat || <sudhir_nimavat <at> yahoo.com> wrote:
> > Ok,
> >
> > Now the problem is.. currently we are using mysql 4.1 and it is not possible
> > to upgrade mysql at this time.. as far as I know mysql 4.1 does not support
> > partitioning.. So the only solution would be to use manual partitioning and
> > handle it through code..
Look into the "merge table" storage engine
<http://dev.mysql.com/doc/refman/4.1/en/merge-storage-engine.html>.
Your app will still need to handle to job of creating and loading the
underlying tables, but selects/deletes/updates be transparent. This is
the closest that you can come to partitioning with 4.1, unless you can
rewrite your app to handle sharding.
