MySQL performance on LVM2
This is a discussion on MySQL performance on LVM2 within the MySQL General forum forums, part of the MySQL category; --> Hello! I'm wondering about MySQL LVM2 preformance, but cant found any comparisions. I know that there is some speed ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-13-2008, 06:13 PM
| ||||
| ||||
 MySQL performance on LVM2 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?      |
|
05-24-2008, 06:09 AM
| |||
| |||
| Re: MySQL performance on LVM2 What is LVM? 2008/5/12 MarisRuskulis <maris@co.inbox.lv>: > 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/mysql?unsub=y...0608@gmail.com > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn |
|
05-24-2008, 06:09 AM
| ||||
| ||||
| Re: MySQL performance on LVM2 http://tldp.org/HOWTO/LVM-HOWTO/whatislvm.html On Tue, May 20, 2008 at 10:13 PM, Moon's Father <yueliangdao0608@gmail.com> wrote: > What is LVM? > > 2008/5/12 MarisRuskulis <maris@co.inbox.lv>: > >> 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/mysql?unsub=y...0608@gmail.com >> > > > > -- > I'm a mysql DBA in china. > More about me just visit here: > http://yueliangdao0608.cublog.cn > -- obed.org.mx |
 |
« NOT [solved] Re: Error reading packet from server: Out of memory(Needed 6560 bytes) ( server_errno=5)
|
DESC index column »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 02:21 PM.
