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
traffic.

===================

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
 /var/lib/mysql/test/
 Now, all the tables go in this folder. (I know, we *should* all know
 this...)

 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: http://lists.mysql.com/mysql
 To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


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