Thanks all for the feedback.
It's comforting to know that other people have had large mysql databases.
As things stand, my database is setup well enough (I'm confident with the
indexes and normalization).
As for the proper engine to use for my situation, I found this quote:
"InnoDB has been desig
t might in the long
> term.
>
> On May 9, 2006, at 5:52 PM, Steve Revilak wrote:
>
> >> Date: Mon, 8 May 2006 17:24:17 -0400
> >> From: Alex Brelsfoard
> >> To: boston-pm@mail.pm.org
> >> Subject: [Boston.pm] LARGE MySQL Database
> >
> >
On 5/9/06, Aaron Sherman <[EMAIL PROTECTED]> wrote:
> Steve Revilak wrote:
[...]
> > If you haven't normalized the pants out of the table, that's probably
> > a good place to start. Anything you can do to trim a few bytes off
> > the row size will make a big difference in the size of the overall
>
Steve Revilak wrote:
>> Basically I am dealing with using, storing, and sorting a LOT of data in a
>> mysql database.
>> With all the data in the table it makes for 404.8 Million rows. In a backup
>> sql file that makes just under 80GB.
>>
OK, so you're dealing with a tiny database.
mysql> s
You might considering partitioning the table dependent on one of the
column's values. The canonical example is splitting a sales table by date
range. This has the effect of decreasing load time and query time by making
the indexes smaller. You would have to make a series of rules though if
you
elsfoard
>> To: boston-pm@mail.pm.org
>> Subject: [Boston.pm] LARGE MySQL Database
>
>> Basically I am dealing with using, storing, and sorting a LOT of
>> data in a
>> mysql database.
>> With all the data in the table it makes for 404.8 Million rows.
>
> Date: Mon, 8 May 2006 17:24:17 -0400
> From: Alex Brelsfoard
> To: boston-pm@mail.pm.org
> Subject: [Boston.pm] LARGE MySQL Database
> Basically I am dealing with using, storing, and sorting a LOT of data in a
> mysql database.
> With all the data in the table it makes f
Howdy all,
I know this isn't specifically a Perl question. But I AM using Perl
with this project.
Basically I am dealing with using, storing, and sorting a LOT of data in a
mysql database.
With all the data in the table it makes for 404.8 Million rows. In a backup
sql file that makes just u
8 matches
Mail list logo