SQL Down Peak Hours

[pinaliz]

SQL fails during peak hours. The panel then gives an HTTP 500 error. and broadcasts are closing. If I do mysql restart it will be back. The main server has 128 GB of ram. There is no peak in Ram and CPU. Could you please help me?

 

[D3lta]

SQL fails during peak hours. The panel then gives an HTTP 500 error. and broadcasts are closing. If I do mysql restart it will be back. The main server has 128 GB of ram. There is no peak in Ram and CPU. Could you please help me?

i can help you, contact me in pm

 

[cloudlive]

SQL fails during peak hours. The panel then gives an HTTP 500 error. and broadcasts are closing. If I do mysql restart it will be back. The main server has 128 GB of ram. There is no peak in Ram and CPU. Could you please help me?

what is your workload (number of user connections, live streams ? ) on your main server ?
Do you have load balancing servers ? and do you transcode all your streams ?

 

[pinaliz]

what is your workload (number of user connections, live streams ? ) on your main server ?
Do you have load balancing servers ? and do you transcode all your streams ?

There are no channels or users on main. Yes, I have about 15 load balance servers. I don't transcode streams.

 

[cloudlive]

How many users do you have ? 128GB is a hell lot of RAM for a main server without channel or streams. What is the size of your DB ?

 

[pinaliz]

Ana sunucum 128 gb ram'a sahip. ancak ram / cpu hiç zirvede değil. 4000-5000 çevrimiçi olduğunda, her yarım saatte bir sql hatası verir. sonra http 500 hatası alıyorum. DB boyutunu bilmiyorum. yaklaşık 10 MB.

 

[cloudlive]

If I understand correctly your main server is only running MAIN and ADMIN (with MYSQL) and is not running anything else ?
Can you post a screenshot of http://xtreamUI:25500/process_monitor.php?server=1 ?
And what is your current RAM/CPU usage ?

 

[pinaliz]

Yes true. only sql is running on the main server. nothing else.. yesterday I asked this to my friend. He said that there are many queries on SQL.
Process Monitor

Screenshot

Captured with Lightshot

prnt.sc

Screenshot

Captured with Lightshot

prnt.sc

 

[cloudlive]

I see. Your Main server is specs are overkill for your usage.
What you need now is one of those 2 solutions :
1) caching your mysql queries (through memcached)
2) run a proxy to pool queries (through a mysql proxy solution)

Yes true. only sql is running on the main server. nothing else.. yesterday I asked this to my friend. He said that there are many queries on SQL.
Process Monitor

Screenshot

Captured with Lightshot

prnt.sc

Screenshot

Captured with Lightshot

prnt.sc

Do you know the number of queries MySQL is processing on peak load ?

 

[D3lta]

I see. Your Main server is specs are overkill for your usage.
What you need now is one of those 2 solutions :
1) caching your mysql queries (through memcached)
2) run a proxy to pool queries (through a mysql proxy solution)


Do you know the number of queries MySQL is processing on peak load ?

no he doesn't, thats not the issue

 

[cloudlive]

no he doesn't, thats not the issue

I'm assuming that he's already done all the MYSQL and OS tweaks needed and is still facing bottleneck (otherwise simply increasing the buffer size and max connections in Mysql should be sufficient). This also why i asked the number of queries during peak load.

 

[pinaliz]

I don't know mysql maximum query. I don't understand mysql. I have to ask this to my friend.

 

[lovevoice]

I don't know mysql maximum query. I don't understand mysql. I have to ask this to my friend.

Have you found a solution or an answer?

 

[pinaliz]

I switched to mariadb got better.