And anyway, that's how the real world works... no matter if one understands the reason or not :)
Federico -------------------------------------------- Dom 12/7/15, Justin Swanhart <[email protected]> ha scritto: Oggetto: Re: [Maria-discuss] ssd and hdd A: Cc: "[email protected]" <[email protected]> Data: Domenica 12 luglio 2015, 23:22 Logically because HDD is cheap and SSD is not. Sent from my iPhone > On Jul 11, 2015, at 5:11 PM, Reindl Harald <[email protected]> wrote: > > why do you waste time and not just store *anything* on the fast storage? > that's *really* not a mysql / maridadb question > >> Am 11.07.2015 um 19:50 schrieb Roberto Spadim: >> hi guys >> i`m with a doubt... i have a server with ssd raid 10 array and hdd >> raid10 array >> ssd is faster for non sequencial read that's a fact when i change a >> table from one device to another and check query response histograms >> >> my doubt is... >> today i have myisam, aria, innodb and sometimes tokudb and spider at >> same server >> >> how could i easily select what table should be stored at ssd or hdd array? >> >> there's a "table space" to select if i want to use ssd or hdd instead of >> create table, and create symbolic links, or create table with data >> directory/index directory? >> i was thinking about something more easily understood like tablespace, >> but used by all engines >> something like >> >> create table blabla table space ssd >> create table blabla table space hdd >> >> what i'm doing today... i have many tables that i use normally and don't >> drop, these tables i can symbolic link to ssd or hdd, but all new tables >> i use hdd (they normally are temporary tables), i'm using innodb per >> file, tokudb i'm not using too much but i don't care about where it's today >> >> anyone with experience to help or ideas? > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
