Am 05.10.2014 um 22:39 schrieb Jan Steinman:
I've had good experiences moving MyISAM files that way, but bad experience
moving  INNODB files. I suspect the latter are more aggressively cached

simply no, no and no again

independent of "innodb_file_per_table = 1" there is *always* a global
table-space (ibdata1) and you just can't move around innodb databases
on file-system level - there is not but and if and it has nothing to
do with caching

if caching would matter in that context it just would not be part of
the game in case off a not running service

http://www.xaprb.com/blog/2012/09/07/measuring-free-space-in-innodbs-global-tablespace/

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to