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
