Re: MySQL performance on LVM2

2008-05-21 Thread obed
http://tldp.org/HOWTO/LVM-HOWTO/whatislvm.html

On Tue, May 20, 2008 at 10:13 PM, Moon's Father
[EMAIL PROTECTED] wrote:
 What is LVM?

 2008/5/12 MarisRuskulis [EMAIL PROTECTED]:

 Hello!
 I'm wondering about MySQL LVM2 preformance, but cant found any
 comparisions. I know that there is some speed decrease with LVM,
 something about 30%. But how this decrease impacts overal MySQL
 performance?
 Now we are backuping replication slave server with mysqldump w full
 table locks, this takes some time. I think better solution is to use LVM
 snapshots, but this performance decrease really scares me. Has anyone
 some advices on this?



 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]




 --
 I'm a mysql DBA in china.
 More about me just visit here:
 http://yueliangdao0608.cublog.cn




-- 

obed.org.mx

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: MySQL performance on LVM2

2008-05-20 Thread Moon's Father
What is LVM?

2008/5/12 MarisRuskulis [EMAIL PROTECTED]:

 Hello!
 I'm wondering about MySQL LVM2 preformance, but cant found any
 comparisions. I know that there is some speed decrease with LVM,
 something about 30%. But how this decrease impacts overal MySQL
 performance?
 Now we are backuping replication slave server with mysqldump w full
 table locks, this takes some time. I think better solution is to use LVM
 snapshots, but this performance decrease really scares me. Has anyone
 some advices on this?



 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]




-- 
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn


MySQL performance on LVM2

2008-05-12 Thread MarisRuskulis
Hello!
I'm wondering about MySQL LVM2 preformance, but cant found any
comparisions. I know that there is some speed decrease with LVM,
something about 30%. But how this decrease impacts overal MySQL performance?
Now we are backuping replication slave server with mysqldump w full
table locks, this takes some time. I think better solution is to use LVM
snapshots, but this performance decrease really scares me. Has anyone
some advices on this?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]