[Cialug] mysql ssd

[Dave Hala]

I've been thinking more about this.  I think I'm not going to
virtualize it.  I've decided that probably the way best to do it is to
setup two raid arrays. One array will consist of mechanical drives and
one of ssd drives.  I'll run the OS from the mechanical drives and
then use mysql folder for the SSD mount point. Then I'll go ahead and
set up a temp drive in ram and use that for the mysql tmp directory.
That should eliminate all the log file and tmp writes to the ssd
drives.




On Thu, Jul 9, 2015 at 10:15 AM, jim kraai <jimgkraai at gmail.com> wrote:
> both nice ideas!  i concentrated on the application piece and the other
> didn't even come to mind
>
>
> On Thu, Jul 9, 2015 at 9:16 AM, Dave Hala <dave at 58ghz.net> wrote:
>
>> Interesting read.  From looking at that article,  it might almost be
>> easier to just mount a mirrored SSD array on /var/lib/mysql and use
>> tmpfs for tmp files, rather than just launching a Virtual machine from
>> the SSD array.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Thu, Jul 9, 2015 at 8:41 AM, jim kraai <jimgkraai at gmail.com> wrote:
>> > There's not much specific to say other than convert MyISAM tables to
>> > something more modern (read TokuDB or InnoDB) if at all possible.
>> >
>> > MySQL tuning is fun, as in I love it because it's hard
>> >
>> > percona's presentation in 2012 on flash/SSD is worth reading carefully
>> >
>> > output from mysqltuner.pl running against the db server on that
>> hardware is
>> > worth reading carefully
>> >
>> > percona performance blog is very worth catching up on and keeping up with
>> >
>> >
>> >
>> > On Thu, Jul 9, 2015 at 8:10 AM, Dave Hala <dave at 58ghz.net> wrote:
>> >
>> >> No problems at all.     Just asking to see if anyone had any
>> >> experience that would be beneficial.
>> >>
>> >>
>> >> On Thu, Jul 9, 2015 at 8:05 AM, jim kraai <jimgkraai at gmail.com> wrote:
>> >> > what are you seeing?
>> >> >
>> >> > On Thu, Jul 9, 2015 at 7:44 AM, Dave Hala <dave at 58ghz.net> wrote:
>> >> >
>> >> >> Anyone had any issues running the Samsung MZ-7GE240EW  SSD drives on
>> a
>> >> >> medium-use Mysql server?
>> >> >> _______________________________________________
>> >> >> Cialug mailing list
>> >> >> Cialug at cialug.org
>> >> >> http://cialug.org/mailman/listinfo/cialug
>> >> >>
>> >> > _______________________________________________
>> >> > Cialug mailing list
>> >> > Cialug at cialug.org
>> >> > http://cialug.org/mailman/listinfo/cialug
>> >> _______________________________________________
>> >> Cialug mailing list
>> >> Cialug at cialug.org
>> >> http://cialug.org/mailman/listinfo/cialug
>> >>
>> > _______________________________________________
>> > Cialug mailing list
>> > Cialug at cialug.org
>> > http://cialug.org/mailman/listinfo/cialug
>> _______________________________________________
>> Cialug mailing list
>> Cialug at cialug.org
>> http://cialug.org/mailman/listinfo/cialug
>>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug