Re: [Maria-developers] I am more than happy to test aria with largedatabases

9 Oct 2010

      Sure!
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.

Mark

On Wed, Oct 6, 2010 at 3:32 AM, Philip Stoev  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" 
To: 
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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp