no, i use InnoDB only for DBMail and most other things are and will be MyISAM in the foreseeable future because i do not appreciate global namespaces instead having a folder per database which is in doubt the easiest restore
having 6000 mostly small tables in 250 databases is perfectly suiteable with MyISAM Am 29.01.2014 16:14, schrieb Roberto Spadim: > do you have time to test toku engine? i'm trying it and it's very > nice, i'm considering changing my tables from innodb to toku really > soon > > 2014-01-28 Reindl Harald <h.rei...@thelounge.net>: >> Am 28.01.2014 13:38, schrieb Jan Lindström: >>> I would like to know the most affecting InnoDB pain points the >>> customers/potential customers first refer. By pain >>> point, I mean anything that causes concerns, restricts sales etc, pain >>> point can be bug, missing feature, usage >>> problem, performance etc. My goal on asking this question is to find out >>> what are the real issues customers or >>> potential customer are struggling or issues that block customers using >>> MariaDB. After that I will see what I can do >>> about the situation and plan forward to address the raised issues with >>> proper priorities. >>> >>> Dean, if this list does to reach the support engineers and technical sales >>> teams please forward to more suitable list. >> >> "innodb_file_per_table" should be clearly default because doing it >> later is really a pain as well as if you remove large amount of >> data that the space never comes back while with file_per_table you >> can do "optimize table" >> >> it is also mandatory for compressed tables >> >> for sure there are setups where the potential fragmentation >> may be a issue, but i am sure they are not the majority
signature.asc
Description: OpenPGP digital signature
_______________________________________________ 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