← Back to team overview

maria-developers team mailing list archive

Re: I am more than happy to test aria with largedatabases


I will get the schema with the column names changed.
Most of the data will be in just 4 or 6 tables.
They will be read-only (for the most part).
With MyISAM, I would be using MyISAM merge and compress the data that isn't
changing anymore. For Aria, we can skip the Merge part obviously.

The big advantage with Aria, if is can have all the properties of MyISAM, is
the transactional capabilities with a mostly read-only database and also
compression. The transactional part is a huge political win for people who
*need* a database to be transactional, even if it isn't necessary.


On Wed, Oct 6, 2010 at 3:32 AM, Philip Stoev <pstoev@xxxxxxxxxxxx> wrote:

> Mark,
> Thank you very much for your offer. I think it would be very beneficial for
> us if we can somehow take advantage of your dataset (CentOS should be just
> fine).
> Aria does not yet support Merge tables, however can you give more
> information about the underlying tables and the overall database schema?
> Maybe we can try loading some of the underlying tables in Aria and use them
> for testing?
> Philip Stoev
> MariaDB QA
> ----- Original Message ----- From: "Mark Nielsen" <menprojects@xxxxxxxxx>
> To: <maria-developers@xxxxxxxxxxxxxxxxxxx>
> Sent: Tuesday, October 05, 2010 1:47 AM
> Subject: [Maria-developers] I am more than happy to test aria with
> largedatabases
>  I am not a coder, but I can probably help anyways for development.
>> I have CentOS systems at work which I can happily run tests against with
>> large real-world data. They are development systems I can trash.
>> i can't change CentOS that easily (maybe I can use virtual machines), but
>> I
>> can put whatever version of MariaDB on my systems and runs tests against
>> it.
>> If someone wants me to run tests, let me know.
>> When the Aria tables can be used with MERGE, I will be very very happy to
>> test it using a terabyte of data. The Aria engine has some some advantages
>> over MyISAM and InnoDB for some report servers I wish to setup. MERGE is
>> one
>> of the last things for me to recommend it.
>> Anyways, any testing is fine with me. I only have CentOS systems though.
>> Mark
> --------------------------------------------------------------------------------
>  _______________________________________________
>> Mailing list: https://launchpad.net/~maria-developers
>> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-developers
>> More help   : https://help.launchpad.net/ListHelp