maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

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@xxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] ssd and hdd
 A: 
 Cc: "maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 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
 <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
 
 _______________________________________________
 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