Hello

I read in 
http://www.mysql.com/doc/I/n/InnoDB_Disk_i_o.html
that Innodb supports raw partitions on "some unixes". We look forward to use innodb on 
debian (intel): are linux raw partitions supported?

Is it wise to try to use linux2.4 raw partitions with innodb on a production system?

I haven't found linux documentation about raw partitions. Has anyone a pointer?

One question I have: is it possible to mirror (software RAID 1) raw partitions on 
linux? (If not then I guess they are pretty useless without a hardware raid).

Some thoughts about possible loss of memory due to using buffered (non-raw) 
partitions: We will use mysql-innodb on the same machine as apache. Apache will serve 
static files (about 200 MB or so, growing; most hits go to a small subset of this, 
however) which are generated from innodb content. Most items are requested from static 
files much more often (i.e. 1000's of times more) than from innodb. Some (personalized 
stuff) are requested as often from innodb than from cache. I guess because of these 
usage patterns linux will use most disk buffer for apache's files, not for the innodb 
partition, so there won't be much loss of memory? If I make an infrequent mysql query 
that has to read most of the tables content (i.e. 200MB out of the 800MB used table 
space), is linux throwing away all disk buffers used by apache in favour of the innodb 
partition, or is it recognizing that apache will request it's buffers soon again? 
(Ideally innodb partition reads would buffer only for a short p!
eriod (since innodb has it's own buffer anyway) and thus only take little memory.)
(I've been planning to use 512MB ram on this machine.)

christian.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to