AFAIK: * TokuDB does large random writes, not small ones * TokuDB doesn't do update in place So it doesn't need something like the doublewrite buffer in InnoDB. I am not sure whether they might benefit from atomic writes. They would benefit from access to a few nice/fast FusionIO devices. On Tue, Sep 30, 2014 at 2:12 AM, Christophe Le Roux < christophe.le.roux@fr.clara.net> wrote:
Hi Jan,
Thank you for your answer.
I am writing to the TokuDB community.
I hope for good news J
Cordialement,
[image: Claranet] <http://www.claranet.fr/>
[image: Linkedin] <http://www.linkedin.com/company/claranet>
[image: Twitter] <https://twitter.com/#!/Claranet_FR>
[image: Youtube] <http://www.youtube.com/user/ClaranetFR>
[image: Gartner MQ] <http://www.claranet.fr/propos-de/gartner.html>
*De :* Jan Lindström [mailto:jan.lindstrom@mariadb.com] *Envoyé :* mardi 30 septembre 2014 10:38 *À :* Christophe Le Roux; Maria Discuss *Objet :* Re: [Maria-discuss] MariaDB,TokuDB and FusionIO
Hi,
On Tue, Sep 30, 2014 at 11:27 AM, Christophe Le Roux < christophe.le.roux@fr.clara.net> wrote:
About NVM compression, is it a hardware compression doing by the FusionIO controller or is it a software compression doing by the CPU of the server ?
Compression is done by CPU in the MariaDB server (InnoDB/XtraDB storage engine).
About Atomic Write, I understand there is missing code to have this feature to the TokuDB engine. Should I ask to the Mariadb dev team or the Tokutek dev team (or SanDisk/FusionIO dev team ?) to add it (maybe it’s technically no doable ?)?
I would start from Tokutek dev team, I do not know fully how database tables are stored on Tokutek, but I do not see immediately a reason why atomic writes would not be possible.
Do you think this can boost performances for huge TokuDB tables ?
Atomic will boost performance but only if database is stored on device that supports atomic writes.
R: Jan
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Mark Callaghan mdcallag@gmail.com
