List:General Discussion« Previous MessageNext Message »
From:John Daisley  Date:December 15 2009 2:52pm
Subject:RE: sql file system + optimization
View as plain text  
Yes, you can symlink it. How much performance benefit you get will depend on hardware and


John Daisley

MySQL 5.0 Certified Database Administrator (CMDBA)
MySQL 5.0 Certified Developer
Cognos BI Developer

Telephone: +44(0)1283 537111
Mobile: +44(0)7812 451238
Email: john.daisley@stripped


Sent via HP IPAQ mobile device

-----Original Message-----
From: Steven Staples <sstaples@stripped>
Sent: 15 December 2009 14:37
To: mysql@stripped
Subject: sql file system + optimization

Ok... in the file system, my MySQL files are located in /var/lib/mysql/
 I have a database (lets say 'test') so it gets its own directory
 Now, all the tables go in this folder. (I know, we *should* all know

 if the database is on another disk, could it increase performance if this
 was a large database? If so, could I just
 symlink the test/ directory to another raid array to increase performance?
 Or would the increase be negligible?

 Steven Staples

 MySQL General Mailing List
 For list archives:
 To unsubscribe:

sql file system + optimizationSteven Staples15 Dec
RE: sql file system + optimizationJohn Daisley 15 Dec