MySQL Forums
Forum List  »  Performance

Re: slow overall perfomance
Posted by: N N
Date: May 23, 2011 03:07AM

Thanks - Rick


>The slowlog threshold is long_query_time, which defaults to a too-high value. Set that to 1 (second).

yes, I have slowlog threshold set to 1 sec but I do not see any slow query, also I did enabled log_queries_not_using_indexes option but did not find any slow query

>Well, let's double check some other things...
>How much RAM in each machine?

$ free mem
total used free shared buffers cached
Mem: 8174188 8120604 53584 0 196452 6592500
-/+ buffers/cache: 1331652 6842536
Swap: 10217332 140 10217192


>How many CPUs? cores?
4

>Is hyperthreading on or off?
yes it is enabled

>What were your tests like? Real-life? Or Benchmarks?
real-life test

>What was the CPU usage (or "load average") during the tests?
with 5.0 the load average is high i.e. load average: 13.24, 8.46, 4.49 but the test finished in 10min.
However, the same test run with 5.1 the load average: 3.13, 1.56, 0.93 and the test took at least 20 min to finish

>sync_binlog? Or was the binlog turned off?
sync_binlog was off and binlog was ON

>Which version of the Plugin did you use?
1.0.15

>How much disk activity?
disk avtiviy is not high, the vmstat collected during test run on 5.1

vmstat 5
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r b swpd free buff cache si so bi bo in cs us sy id wa st
1 0 140 46052 197984 6675892 0 0 0 9 1 2 0 1 99 0 0
4 0 140 46132 197992 6675276 0 0 44 995 1172 12477 51 9 40 0 0
2 0 140 48516 197992 6668768 0 0 38 990 1151 10997 48 8 43 0 0
8 0 140 45212 197976 6658164 0 0 41 1008 1179 11695 52 9 39 0 0
3 0 140 51900 197980 6647436 0 0 42 1110 1211 11932 51 9 39 0 0
4 1 140 47676 197980 6646192 0 0 42 849 1156 11874 50 8 42 0 0
3 0 140 46484 197980 6644732 0 0 42 1011 1155 11793 51 9 40 0 0
5 0 140 45668 197980 6640496 0 0 38 936 1169 11340 49 9 42 0 0
5 0 140 47200 197984 6628168 0 0 30 803 1125 7282 76 7 17 0 0
3 0 140 47072 197988 6629940 0 0 41 846 1158 11377 54 9 37 0 0
5 0 140 45704 197984 6628752 0 0 42 1025 1158 11944 51 9 40 0 0
3 0 140 46172 197988 6627376 0 0 42 851 1158 11812 51 9 41 0 0
3 0 140 46936 197988 6626832 0 0 43 1039 1160 12124 48 9 43 0 0


The vmstat collected durning test run on 5.0

vmstat 5
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r b swpd free buff cache si so bi bo in cs us sy id wa st
10 1 140 48024 197088 6492620 0 0 0 9 1 0 0 1 99 0 0
13 1 140 46472 197088 6493092 0 0 318 998 1171 7849 82 14 4 0 0
12 1 140 46276 197092 6492660 0 0 316 1147 1185 8276 82 14 4 0 0
14 1 140 45640 197100 6487168 0 0 76 1010 1167 8159 79 15 6 0 0
13 1 140 49252 197096 6482576 0 0 79 1088 1173 8382 81 14 4 0 0
15 0 140 47156 197096 6485360 0 0 92 1030 1170 8458 81 15 4 0 0
15 0 140 49356 197060 6475312 0 0 269 1110 1180 8427 81 14 4 0 0
17 0 140 56912 197060 6465216 0 0 323 1031 1178 8343 82 14 4 0 0
15 0 140 50044 197064 6468176 0 0 92 1102 1180 8338 82 14 4 0 0



Edited 6 time(s). Last edit at 05/23/2011 09:34AM by N N.

Options: ReplyQuote


Subject
Views
Written By
Posted
3403
N N
May 20, 2011 03:53AM
1233
May 21, 2011 08:46AM
Re: slow overall perfomance
1364
N N
May 23, 2011 03:07AM
1138
May 23, 2011 09:49AM
1087
N N
August 08, 2011 09:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.