Thank you for that Claudio.
To be fair, we studied them a few years ago for a high-traffic website
we were migrating from 4.0 to 5.0. The proof-of-concept was sound and
tested well but concerns from the sysadmin team kept that model from
going to production.
Again, I did not mean that to appear
Micheal,
I have the feeling that no one on this planet uses raw devices with mysql,
I might be wrong but I think InnoDB is kind of 'optimized' to leverage the
filesystem facilities,
but I would really like an InnoDB expert opinion here.
Claudio
2012/2/7 Michael Dykman
> In the case of using ra
I have a query that I need to tune.
Basically, substr a text, and select first and last entry.
The table is currently a few million rows big. Index is on FromHost (text
field) and ReceivedAt (index field)
Is the best way to optimize my query.
1) create an index on substr() and the two date columns
I am having a problem with select results that I don't understand. It seems to
be tied up with a GROUP BY statement. Forgive the complexity of the SQL, I
inherited some problematic data structuring.
If I use this statement:
SELECT lu_rcode_bucket.bucket AS 'BUCKET',
CP_PKG.value AS 'PRODU
In the case of using raw devices (which I'm not really sold on in
general, but there are cases when performance is all), we ran our
backups from a slave replica.
On Tue, Feb 7, 2012 at 1:42 PM, Sameh Attia wrote:
> Hi,
> Check these:
>
> http://www.enterprisestorageforum.com/storage-hardware/te
I highly recommend against Raw Devices..
You're extremely limiting your backup options in this case..
S
On Tue, Feb 7, 2012 at 13:39, Michael Dykman wrote:
> If what you are looking for is performance optimization, you might
> want to consider:
>
> http://dev.mysql.com/doc/refman/5.5/en/innodb
Hi,
Check these:
http://www.enterprisestorageforum.com/storage-hardware/test-plan-for-linux-file-system-fsck-testing.html
http://www.enterprisestorageforum.com/sans/features/article.php/3749926
http://www.enterprisestorageforum.com/storage-hardware/the-state-of-file-systems-technology-problem-s
If what you are looking for is performance optimization, you might
want to consider:
http://dev.mysql.com/doc/refman/5.5/en/innodb-raw-devices.html
- michael dykman
On Tue, Feb 7, 2012 at 1:31 PM, List Man wrote:
> Ext4 is faster to me.
>
>
> LS
>
>
>
> - Original Message -
> From: "ri
Ext4 is faster to me.
LS
- Original Message -
From: "rickytato rickytato"
To: mysql@lists.mysql.com
Sent: Tuesday, February 7, 2012 1:19:32 PM
Subject: Filesystem choice
Hi,
I'm my new server I've to decided what filesystem to used.
The server are dual amd six core 2.4GHz, 32GB ram,
Hi,
I'm my new server I've to decided what filesystem to used.
The server are dual amd six core 2.4GHz, 32GB ram, and 4x 300GB SAS 15krpm
raid10 with perc700 512MB raid controller.
I've to chosse between xfs and ext4; ext4 with
noatime,nodiratime,data=writeback,barrier=0,nobh,commit=100,errors=rem
10 matches
Mail list logo
