maria-discuss team mailing list archive
Mailing list archive
Re: ssd and hdd
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:
i`m with a doubt... i have a server with ssd raid 10 array and hdd
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
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
i was thinking about something more easily understood like tablespace,
but used by all engines
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?
Description: OpenPGP digital signature