maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

Logically because HDD is cheap and SSD is not.  

Sent from my iPhone

> On Jul 11, 2015, at 5:11 PM, Reindl Harald <h.reindl@xxxxxxxxxxxxx> 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     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp