I could be wrong (I'm not our office's resident MySQL guru), but I think
that MySQL does some significant caching into DRAM. So, if you're
worried about the query time of an uncached query, then possibly, but
otherwise, I'd just let the caching algorithm handle it. Also depends
on what you're req
I have put a mysql server on a Fusion IO Solid State drive and yes it
really speeds things up, however I have not tried a regular SSD that would
connect to a SAS interface but I would believe it would. Fusion IO drives
is basically a PCI card, so it is not limited to the SAS speeds. Also be
aware
On 10/01/12 10:16, Lance Grover wrote:
> I have put a mysql server on a Fusion IO Solid State drive and yes it
> really speeds things up, however I have not tried a regular SSD that would
> connect to a SAS interface but I would believe it would. Fusion IO drives
> is basically a PCI card, so it i
On Wed, Sep 26, 2012 at 1:01 PM, S. Dale Morrey wrote:
> Does anyone have a recommendation for a well thought out, durable
> thumbdrive solution?
> Thanks!
>
I've had one of these in my pocket for some time:
http://www.amazon.com/4GB-Metal-Key-Flash-Drive/dp/B005OP2JQ4/ref=sr_1_5?ie=UTF8&qid=134
On Mon, Oct 1, 2012 at 10:07 AM, Merrill Oveson wrote:
> Put my mysql database on sdd drive...
>
> Will my queries run much faster?
>
> Anybody tried this?
>
I have had a lot of success doing this. It depends on what your database
and read/writes look like though. MySQL does a good job caching r
Yeah, I work for Fusion-io so nobody's shocked ill say this, but there's some
evidence for helping your mySql infrastructure via Fusion-io cards. Facebook is
running their MySQL farm on Fusion-io cards, and others are taking advantage.
Jeremy Zawodny at Craigslist used Fusion-io to take 14 mySq
On Oct 1, 2012, at 10:34 AM, Dan Hanks wrote:
> On Wed, Sep 26, 2012 at 1:01 PM, S. Dale Morrey wrote:
>
>> Does anyone have a recommendation for a well thought out, durable
>> thumbdrive solution?
>> Thanks!
>>
I'm a little late to this conversation, but LaCie makes a metal key shaped usb
ke
When MySQL performance improves significantly from improvements in
disk I/O it is almost always a bad sign. Consider this - if upgrading
your car improved your travel time from New York to Los Angeles by
20%, is that good or bad? On the surface it looks great - we are 20%
faster. But if we stop to
I know BlueHost has been using flash for MySQL for a few years now,
and on a very IO-heavy platform with little control over the
usage/contents of the databases.
I know there are some BlueHost veterans around here with more admin
experience than me. Maybe they'd be willing to share some informati
On Oct 1, 2012, at 12:35 PM, Robert Merrill wrote:
>
> MySql performance blog shows some interesting analysis of RAID vs SSD vs
> Fusion-io with some arguably good things to consider if price > performance
> in your setup:
> http://www.mysqlperformanceblog.com/2009/05/01/raid-vs-ssd-vs-fusioni
There are a few things to consider with a relatively busy mysql on SSDs.
1) admins have little control over developers. Developers program what makes
sense at the time to get the job done on a deadline. Admins do what makes
sense to make those programs run with good performance. Sometimes the
> 1) admins have little control over developers. Developers program what makes
> sense at the > >time to get the job done on a deadline. Admins do what makes
> sense to make those >programs run with good performance. Sometimes there are
> debates, arguments, etc over what >is "best".
On the
On Mon, Oct 1, 2012 at 3:32 PM, Sasha Pachev wrote:
>
> On the subject of the eternal battle between DBAs and developers. I
> have always felt it was a strategic mistake to hire one person to be
> MySQL "DBA", and another person to be a MySQL client developer. I
> believe this is the root of many
OCZ's Revodrive give a lot more bang/$ than fusion IO IMO. My 240GB
card does over 100,000 IOPS (or >700MB/s read/write) and it's less
than $500 now. Their newest card doubles that rate (but costs ~$800
for 240GB).
As for the alarmism, yes, this was fairly well debunked years ago here:
http://www
I don't understand the point of your comment.
On Monday October 1 2012 15:55:23 Barry Roberts wrote:
> On Mon, Oct 1, 2012 at 3:32 PM, Sasha Pachev wrote:
> >
> > On the subject of the eternal battle between DBAs and developers. I
> > have always felt it was a strategic mistake to hire one perso
On 10/1/12 4:31 PM, Richard Esplin wrote:
> I don't understand the point of your comment.
He's saying that SOX strongly suggests that development and DBA
positions be siloed.
Steve
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear t
On Mon, Oct 1, 2012 at 4:32 PM, Steve Meyers wrote:
> On 10/1/12 4:31 PM, Richard Esplin wrote:
>> I don't understand the point of your comment.
>
> He's saying that SOX strongly suggests that development and DBA
> positions be siloed.
>
That. If you're a developer with access to production ser
On 10/01/2012 04:54 PM, Barry Roberts wrote:
> On Mon, Oct 1, 2012 at 4:32 PM, Steve Meyers wrote:
>> On 10/1/12 4:31 PM, Richard Esplin wrote:
>>> I don't understand the point of your comment.
>>
>> He's saying that SOX strongly suggests that development and DBA
>> positions be siloed.
>>
>
>
>
Hey guys,
I'm a new member who's currently living in Lehi. I'm excited to find people so
close that share my same passion and excitement for Linux.
A little about myself... I'm 28 years old, married, and working full time as an
Automation Engineer at Champion Technology Services in Millcreek.
Welcome! I'm top-posting and sending in rich text to ensure an [OT] flame war
netiquette thread starts shortly hereafter. ...It's the best kind of welcome we
know how to give!
On Oct 1, 2012, at 7:57 PM, Matt Melvin wrote:
>
> Hey guys,
> I'm a new member who's currently living in Lehi.
/*
Ah, but you've failed to consider one of the lesser known corollaries to
Godwin's law.
On Mon, 2012-10-01 at 20:28 -0600, Robert Merrill wrote:
> Welcome! I'm top-posting and sending in rich text to ensure an [OT] flame war
> netiquette thread starts shortly hereafter. ...It's the best kind of we
On 10/01/2012 08:33 PM, Stuart Jansen wrote:
> Ah, but you've failed to consider one of the lesser known corollaries to
> Godwin's law.
>
>
Godwin was a commie!
;-Daniel Fussell
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the pe
On Mon, Oct 1, 2012 at 7:57 PM, Matt Melvin wrote:
>
> Hey guys,
> I'm a new member who's currently living in Lehi. I'm excited to find
> people so close that share my same passion and excitement for Linux.
>
Welcome! You'll find plug interesting, entertaining, and demoralizing. Good
luck! If y
On 10/01/2012 08:33 PM, Stuart Jansen top-posted something:
>
Wow, hell has indeed frozen over. It's a new gmail-friendly plug! I'm
so happy. Hey do you guys know anything about configuring this fancy
new metro thing?
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plu
On Mon, Oct 1, 2012 at 7:57 PM, Matt Melvin wrote:
>
> Hey guys,
> I'm a new member who's currently living in Lehi. I'm excited to find
> people so close that share my same passion and excitement for Linux.
> A little about myself... I'm 28 years old, married, and working full time
> as an Autom
Thus said Robert Merrill on Mon, 01 Oct 2012 20:28:37 MDT:
> Welcome! I'm top-posting and sending in rich text to ensure
I highly doubt you'll start a flame war, for one, your email client
can't even do rich text correctly:
X-mailer: iPhone Mail (10A403)
Content-type: text/plain; charset="u
26 matches
Mail list logo