<p dir="ltr">You can use a log structure file system to prevent that... </p>
<div class="gmail_quote">On Oct 16, 2012 6:55 PM, "Alex Carver" <<a href="mailto:agcarver%2Bale@acarver.net">agcarver+ale@acarver.net</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 10/16/2012 15:45, Derek Atkins wrote:<br>
<br>
> Note I said SSD, not BSD. Thinking about a Solid State Disk (versus<br>
> spinning disk). Any comments?<br>
<br>
Save the cash and stick with a spinning disk. The I/O requirements on<br>
MySQL aren't huge so there's very little speed-up from going SSD versus<br>
spinning disk. On the other hand, the short lifespan of the SSD will<br>
give you heartburn later as the storage cells get used and abused by the<br>
maintenance on the indicies and other housekeeping (true for any DB).<br>
<br>
I've actually got one WinXP system running MySQL (WAMP - don't ask, I'm<br>
still working on creating a LAMP system to replace it) with only 2 GB of<br>
RAM and there aren't any performance hits that I've seen to MySQL. It's<br>
actually my primary desktop machine at work so plenty of other things<br>
are running on it at the same time and yet I can do a big query from the<br>
command line and get snappy return data (plus a swamped buffer).<br>
<br>
_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
</blockquote></div>