- Original Message -
From: Chao Zhu zhuc...@gmail.com
One Q: Can mysql binlog use raw device on Linux?
Mmm, good question. Don't really know; but I'm not convinced you'll get huge
benefits from it, either. Modern filesystems tend to perform pretty close to
raw throughput.
From a
Yes, that was my question. Though, since English is not my first
language, let me try to post it again:
There is a list of all orgs and items org bough, from table called
orders
item_idorg_id
342607
342607
341520
362607
361520
368934
38
What I need is a list of orgs they bought all of items 34, 36, 58,
63. every of them.
Some solutions under What else did buyers of X buy at
http://www.artfulsoftware.com/infotree/queries.php.
PB
---
On 3/17/2011 12:00 PM, LAMP wrote:
Yes, that was my question. Though, since English is not
First I was thinking there is function IN ALL or something like that,
since there are functions IN and EXISTS. And I would be able to make a
query something like this
select distinct org_id, item_id
from orders
where item_id in all (34, 36, 58, 63)
order by org_id asc
But, there
Hi,
For the actual question, I agree with the points Johan mentioned. MySQL, to
my knowledge, does not have an option to use raw devices for binary logs. Even
if it had it, it would not have the benefits Chao is seeking. There is indeed
a tradeoff between losing transactions and
Thanks Guys;
The reason I was seeking RAW/AIO, is mostly about non-blocking write;
Which i mean:
Even though single write is not faster on RAW, if it supports raw and
Asynch IO write, then MySQL can continue to submit write request to disk
without waiting for the previous write to complete,
Thanks Guys;
The reason I was seeking RAW/AIO, is mostly about non-blocking write;
Which i mean:
Even though single write is not faster on RAW, if it supports raw and
Asynch IO write, then MySQL can continue to submit write request to disk
without waiting for the previous write to complete,
Just my two cents.
That's why it is Oracle.
Oracle is (almost) an operating system,
with its advanced implementation of device/file system management,
up to a logical volume management just consider ASM for example.
MySQL is quite simpler.
May be Oracle gurus could bring some key benefit to