Arjen Lentz wrote:
Hi Brian, all,
On 12/08/2008, at 10:04 AM, Brian Aker wrote:
But I guess that brings up the question, is it more work to scrap it,
than to keep it.
More work to keep it. I am also in favor of getting rid of it, knowing
that the Maria folks will improve on it, and right now doing anything
with MyISAM just costs time.
For rapid high volume inserts (data acquisition, web clicks), InnoDB is
too slow.
And MyISAM outperforms both Archive and CSV; the final bottleneck is not
disk I/O, it's CPU.
Antony tells me that replacing the zlib in Archive with the lzh (sp?)
library reduces CPU significantly.
The difference in sustained bulk insert performance from MyISAM to "the
others" is quite significant, it's a factor of 4-5x.
.
.
> I'm cool with ditching MyISAM, provided we have an suitable
> alternative for the abovedescribed use. Optimised Archive +
> Maria should do the trick.
+1 to that. We only use MyISAM for that now, but without it, we would
have major lag on some logging functionality.
Of course, I could keep using MySQL for that and not Drizzle. In my
world, I plan to use both where the need is correct. Perhaps that
should be kept in mind as well.
--
Brian Moon
Senior Web Engineer
------------------------------
When you care enough to spend the very least.
http://dealnews.com/
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
