Question Mass edit streams problem

[dindin]

Hi guys,
I have problem when i want to use mass edit streams...
When i choose 500 or 1000 streams to mass edit, xuione just hang and mysql pid go to using 100% of cpu and i have to restart mysql and xuione to do again.

Is there any special mysql or mariadb confige to solve this problem?

 

[dreamerJS]

Hi guys,
I have problem when i want to use mass edit streams...
When i choose 500 or 1000 streams to mass edit, xuione just hang and mysql pid go to using 100% of cpu and i have to restart mysql and xuione to do again.

Is there any special mysql or mariadb confige to solve this problem?

make sure this option is off restart on edit
this is what i think you got that problem
unless you have a very bad server specs

 

[dindin]

make sure this option is off restart on edit
this is what i think you got that problem
unless you have a very bad server specs

Restart in edit is off.
And our servers have good hardware.. 8 core cpu and 32 gig ram.

Its not server issue, some times editing works in the second but most of the time get hang

 

[chang]

Please upgrade main server with higher RAM and CPU
Moreover , the SSD disk is preferred

 

[antitoxis]

Is there any fix for that?
We have same Problem on 1.5.12.
If we massedit more than 100 things, we get high cpu.
Streams ore Movies all the same. I think there is a problem with mysql.
The process is /home/xui/includes/cli/tools.php