# How to balance user load !!!

**URL:** <https://forums.percona.com/t/how-to-balance-user-load/2661>\
**Category:** Other MySQL® Questions\
**Created:** [May 2, 2013, 2:31am UTC](https://forums.percona.com/t/how-to-balance-user-load/2661 "2013-05-02T02:31:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![systemali](https://avatars.discourse-cdn.com/v4/letter/s/b9bd4f/32.png) [@systemali](https://forums.percona.com/u/systemali)\
**Post date:** [May 2, 2013, 2:31am UTC](https://forums.percona.com/t/how-to-balance-user-load/2661/1 "2013-05-02T02:31:24Z")

</div>



---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [May 2, 2013, 9:45am UTC](https://forums.percona.com/t/how-to-balance-user-load/2661/2 "2013-05-02T09:45:42Z")

</div>

It is hard to provide a single answer without knowing the storage engine, and without knowing whether the problem is reading or writing to the database.

---

<div class="post-metadata">

**Author:** ![systemali](https://avatars.discourse-cdn.com/v4/letter/s/b9bd4f/32.png) [@systemali](https://forums.percona.com/u/systemali)\
**Post date:** [May 2, 2013, 9:12pm UTC](https://forums.percona.com/t/how-to-balance-user-load/2661/3 "2013-05-02T21:12:03Z")

</div>

Appreciate your revert “gmouse” as always 🙂

Since i am a novice at it, Can you please let me know how can i find out if the server is having “Read OR Write” problems to the database ?

Thank you once again !!

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [May 3, 2013, 5:44am UTC](https://forums.percona.com/t/how-to-balance-user-load/2661/4 "2013-05-03T05:44:21Z")

</div>

If mutex contention or cpu power is not the problem, that will become clear from the disk utilization, as shown by e.g. iostat.

---

<div class="post-metadata">

**Author:** ![systemali](https://avatars.discourse-cdn.com/v4/letter/s/b9bd4f/32.png) [@systemali](https://forums.percona.com/u/systemali)\
**Post date:** [May 7, 2013, 1:43am UTC](https://forums.percona.com/t/how-to-balance-user-load/2661/5 "2013-05-07T01:43:44Z")

</div>

Hello “gmouse”

I have got the results from iostat, can you please comment on the status of the same :-

> [@](#):
>
> root@rack02 ~ # iostat -d -x 1 3  
> Linux 2.6.18-308.4.1.el5 (rack02.cv.local) 05/07/2013
> 
> Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util  
> sda 0.23 39.07 3.08 11.65 128.31 776.37 61.39 0.05 3.41 0.79 1.17  
> sda1 0.00 0.00 0.00 0.00 0.01 0.00 9.81 0.00 2.41 2.36 0.00  
> sda2 0.22 39.07 3.08 11.65 128.30 776.37 61.40 0.05 3.41 0.79 1.17  
> sda3 0.00 0.00 0.00 0.00 0.00 0.00 46.56 0.00 6.82 6.74 0.00
> 
> Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util  
> sda 0.00 0.00 0.00 1.00 0.00 8.00 8.00 0.00 0.00 0.00 0.00  
> sda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00  
> sda2 0.00 0.00 0.00 1.00 0.00 8.00 8.00 0.00 0.00 0.00 0.00  
> sda3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
> 
> Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util  
> sda 0.00 5.00 0.00 8.00 0.00 104.00 13.00 0.01 0.88 0.88 0.70  
> sda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00  
> sda2 0.00 5.00 0.00 8.00 0.00 104.00 13.00 0.01 0.88 0.88 0.70  
> sda3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Thank you
