MySQL Forums
Forum List  »  MySQL & Storage

Re: MySQL + NAS(NFS or CIFS) + Huge Table Insert Problem (Long)
Posted by: Harrison Fisk
Date: September 21, 2005 01:13PM

Hi,

Just to add some more information that I have seen in various scenarios.

Generally NFS/CIFS = not so good for databases. The locking causes issues, as does the performance in most cases. The only real case where I would consider it, would be read-only MyISAM. As you said, most queries use indexes, which means that there will be quite a bit of disk seeking, not so much continous reads. Disk seeking is quite poor over NFS (and will become a bottleneck in almost any application).

If you can, something such as iSCSI (or fibre channel) will be much better. One of the big things is that they operate at the block level where as NFS is at the file level. Generally performance is will *much* better even with the same disk devices.

Anyways, that is just my two cents, good luck with your issue!

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL + NAS(NFS or CIFS) + Huge Table Insert Problem (Long)
September 21, 2005 01:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.