playSMS Forum

MySQL to peak load CPU

try to kill playsmsd one by one, one at a time, and observe

the kill starts from dlrssmsd, then restart playsmsd then kill recvsmsd manually, restart again and so on

see which service affecting mysql

anton

Ok, thank you, will try it.

Regards,
Jamshid Tursunov

Anton, I tried to collect information on each process and together as a whole, and this is what happened:
Sequential shutdown and inclusion:


Before shutting down the processes, the CPU load varied in the range of 105-140%
Disconnected in the following sequence:
The first to disconnect ratesmsd, the CPU load dropped to around 30-50%, and this range, while watching, kept steady
The second turned off recvsmsd, the CPU load was in the range of 30-43%
The third disabled schedule, the CPU load was in the range of 30-42%
The fourth disconnected sendsmsd, the CPU load was in the range of 30-42%
Fifth disabled dlrssmsd, CPU load dropped to 0.7%, sometimes jumped to 1%


When all 5 services disconnected, the CPU load dropped to 0.7%, sometimes jumped to 1%


When I turned on dlrssmsd, the CPU load jumped right up to 30-42%
Next turned on sendsmsd, the CPU load remained in the range of 30-42%
After turning on schedule, the CPU load was in the range of 30-42%
Then turned on recvsmsd, the CPU load was in the range of 30-42%
When I turned on ratesmsd, the CPU load was kept in the range of 40-45%, but very often there are skips and the load reaches as much as 145%


Individual enable and disable: (I will enable and disable the service to calculate how much load a single process gives)
When I turned on dlrssmsd, the CPU load jumped right up to 42%
Next turned on sendsmsd, CPU load kept in the range 1.3-1.7%
After I enabled schedule, the CPU load was in the range 1.3-1.7%
Then I turned on recvsmsd, the CPU load kept in the range 1.3-1.7%
When I turned on ratesmsd, the CPU load started to jump right up to the mark above 100%

I want to emphasize that even after I turned off all the PlaySMS processes, the memory occupied by MySQL remained at 14%. I want to say that after disabling the PlaySMS process, the memory is not freed.

Respectfully,
Jamshid Tursunov

Anton, if possible, pay attention to the above MySQL behavior. Is it possible to optimize MySQL in order to reduce the load on the processor. Such bumps occur only with a simple system.

Respectfully,
Jamshid Tursunov

Anton, good day!
Did you have time to look at the unstable behavior of PlaySMS when stacking with a database?

Respectfully,
Jamshid Tursunov

Hi, sorry no, and I think its better to ask MySQL professionals/communities for that.

Looks to me its all on how to correctly index and/or optimize MySQL configs. Of course there are parts where changes can be done in playSMS to help it, but I haven’t got time to focus on that.

anton

Hello dear Anton!
I have to bother you again, your help is needed in solving this issue :slight_smile:
If you pay attention, I tried to describe the problem in detail within each service separately.
I really need your help in solving this issue, apparently, except for you, no one will figure this out

Respectfully,
Jamshid Tursunov

whats your server’s specification (cpu, ram, is disk ssd or not) ?

have you try to tweak MySQL config ?

have you try to make index, test it, perhaps ask MySQL pro to help you how to fix it (or follow some index pointed by @Edilson_Spessoto on previous posts

how big your data ? how many estimated rows on your tables ? (just estimation, no need exact number, like above a million, above 1 hundred thousand rows… something like this)

anton