MySQL performance gains for storing data files and transaction log on another drive

We're bundling MySQL with our server product for an analytics data-logging component and are wondering if it's worthwhile to separate the data files and/or transaction logs on other drives for large installations to improve performance. Does anyone have experience with this?

We're on Windows server (2003 and 2008r2) only, using InnoDB with a 3NF normalized database, about 500-1000MB per day of data, with lots of small reads and writes and the occasional large read from denormalized report tables.

Thanks

Category:mysql Views:0 Time:2011-02-23

Related post

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.204 (s). 11 q(s)