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.
Flip side is, what if the Maria guys never finish the new version of
MyISAM? If that happens then there is entirely a new set of problems
to look at (I believe they will, but I do not know when).
The current state of Maria can already replace MyISAM, can't it.
It's just the transactional stuff that's not complete. But it can do
the basics and has crash recovery.
I'm cool with ditching MyISAM, provided we have an suitable
alternative for the abovedescribed use.
Optimised Archive + Maria should do the trick.
Cheers,
Arjen.
--
Arjen Lentz, Founder @ Open Query
Training and Expertise for MySQL in Australia and New Zealand
http://openquery.com.au/training/ (ph. +61-7-3103 0809)
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
