Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL++ - Programming with the C++ API to MySQL
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
mysql openssl Question
mysql:it 's a db not a dbms how it 's possible?!
Does the binary log enabling affect the MySQL performances?
Strange behavior, Table Level Permission
FULLTEXT query format question
Preventing Duplicate Entries
Comparing and writing out BLOBS
Executing MySQL Commands From Within C Program
Can 't access mysql after kernel upgrade
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Downgrade Mysql from 4 to 3 23
MySQL Cluster Software
mysql test 4 1 fails with the gis test
ERROR 2002: Can 't connect to local MySQL server through socket
Getting Identity after INSERT
Update one field with more fields from another table
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
mysql have same function mthod as Oracle decode()
 
About configuring I/O on Linux...

About configuring I/O on Linux...

2006-10-24       - By Martin Cordova

 Back
Reply:     1     2     3  

Hello:

I am reading latest MaxDB online docs, and found this:

1) USE_OPEN_DIRECT

Q: do you recommend this on a Linux w/kernel 2.6? which Filesystems
make sense for this parameter?

2) "Only for UNIX/Linux: do not use hard disks with a journal file
system for the volumes. Journal file systems perform their own logging
of data changes, which is unnecessary for the database system and
leads to performance reduction."

Q: I am not familair with raw devices, so I was using XFS, because I
did read it was suitable for large files, like the ones I use with
MaxDB. The paragraph above put me think again... If I am not using Raw
devices, does this mean that I should use Ext2?? what about server
restarts? who will protect the integrity of my log and data files?

I would appreciate very much your comments on these topics.

Thanks a lot,
Martin
--
Dinamica - RADical J2EE framework
open source, easy and powerful
http://www.martincordova.com

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=mysql@(protected)