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?
With
+23k members
+11k threads
+106k posts
we are the most popular IPTV community on the web.
IMPORTANT NOTE:
WE HAVE RECENTLY NOTICED THAT TOO MANY DOUBLE FAKE ACCOUNTS ARE CREATED IN THE PAST.
TO PREVENT THIS ISSUE THE DECISION WAS MADE THAT IN THE FUTURE A ANNUALLY FEE 20 EURO WILL BE RAISED FOR NEW MEMBERSHIPS.
Join now to the World of IPTV
i can help you, contact me in pmSQL 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 ?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?
Channels | MatchTime Unblock CDN | Offshore Server | Contact |
100 cnx / 90€ | 5Gbps / 180€ | 48CPU-256GRAM 10Gbps 569€ | Skype live:giefsl |
500 cnx / 350€ | 10Gbps / 350€ | 48CPU-128GRAM 5Gbps / 349€ | TG @changglobize |
1000 cnx / 500€ | 20Gbps / 700€ | 40CPU-128GRAM 20Gbps / €980 | http://coronaserver.com |
There are no channels or users on main. Yes, I have about 15 load balance servers. I don't transcode streams.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 ?
Channels | MatchTime Unblock CDN | Offshore Server | Contact |
100 cnx / 90€ | 5Gbps / 180€ | 48CPU-256GRAM 10Gbps 569€ | Skype live:giefsl |
500 cnx / 350€ | 10Gbps / 350€ | 48CPU-128GRAM 5Gbps / 349€ | TG @changglobize |
1000 cnx / 500€ | 20Gbps / 700€ | 40CPU-128GRAM 20Gbps / €980 | http://coronaserver.com |
Do you know the number of queries MySQL is processing on peak load ?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
Channels | MatchTime Unblock CDN | Offshore Server | Contact |
100 cnx / 90€ | 5Gbps / 180€ | 48CPU-256GRAM 10Gbps 569€ | Skype live:giefsl |
500 cnx / 350€ | 10Gbps / 350€ | 48CPU-128GRAM 5Gbps / 349€ | TG @changglobize |
1000 cnx / 500€ | 20Gbps / 700€ | 40CPU-128GRAM 20Gbps / €980 | http://coronaserver.com |
no he doesn't, thats not the issueI 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 ?
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.no he doesn't, thats not the issue
Channels | MatchTime Unblock CDN | Offshore Server | Contact |
100 cnx / 90€ | 5Gbps / 180€ | 48CPU-256GRAM 10Gbps 569€ | Skype live:giefsl |
500 cnx / 350€ | 10Gbps / 350€ | 48CPU-128GRAM 5Gbps / 349€ | TG @changglobize |
1000 cnx / 500€ | 20Gbps / 700€ | 40CPU-128GRAM 20Gbps / €980 | http://coronaserver.com |
Have you found a solution or an answer?I don't know mysql maximum query. I don't understand mysql. I have to ask this to my friend.
We know, ad-blocking software do a great job at blocking ads. But our site is sponsored by advertising.
For the best possible site experience please take a moment to disable your AdBlocker.
You can create a Account with us or if you already have account, you can prefer an Account Upgrade.