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.dais...@butterflysystems.co.uk
===
Sent via HP IPAQ mobile device
-Original Message-
From: Steven Staples sstap...@mnsi.net
Sent: 15 December 2009 14:37
To: mysql@lists.mysql.com
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=john.dais...@butterflysystems.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
