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? -- Roberto Spadim
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?
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@thelounge.net> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
On Jul 11, 2015, at 5:11 PM, Reindl Harald <h.reindl@thelounge.net> 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
i was
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 <greenlion@gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] ssd and hdd A: Cc: "maria-discuss@lists.launchpad.net" <maria-discuss@lists.launchpad.net> Data: Domenica 12 luglio 2015, 23:22 Logically because HDD is cheap and SSD is not. Sent from my iPhone links, or create table with data directory/index directory? 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ 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
participants (4)
-
Federico Razzoli -
Justin Swanhart -
Reindl Harald -
Roberto Spadim