← Back to team overview

maria-discuss team 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:
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?

Attachment: signature.asc
Description: OpenPGP digital signature

Follow ups