The Research On EPG Server's Performance Improvement Of IPTV

With the development of wide band technology, providing TV through high speed network becomes true. IPTV is such a service of providing interactive multimedia programs through wide band.Compared with the traditional TV, IPTV win an advantage by its interactive.EPG is program guide of IPTV and it plays a great part in interactive access. So the performance of EPG is critical when many users enjoy it.Now, EPG's performance is a problem must be studyed. The paper takes EPG which in a large-scale IPTV systems as a research instance. Three methods are used to improve EPG's performance. The first based on performance bottle-neck's diagnosing and resolving. The second based on Mysql Cluster. The third based on based on accessing forecast.In the method which based on performance bottle-neck's diagnosing and resolving, firstly, the shortage of original method is analyzed. An Apache log analyzer is designed. The analyzer can find the performance status of EPG blade in and accessing rule of users through analyzing the Apache log in locale.Then three tools--loadrunner, xdebug and Apache log analyzer are used to find bottle-necks of performance. The two biggest bottle-necks are: public parameter's definition and the database access. A contrastive test of four public parameter's definitions is introduced to select an optimal function of definition. Then the first performance bottle-neck has been resolved. The tuning on some parameters of Mysql and the improvement of mysql accessing mode are functions which resolved the second performance bottle-neck. Some other improvements are also introduced, e.g. improve page information's store mode, design a EPG_Assisant to improve the performance, Apache parameters'tunning and so on. The method is proved to improve the performance.In the replace arithmetic which based on accessing forecast, firstly, construct a matrix through accessing rule which analyzed by Apache log analyzer. A remain_index conception and formula are introduced. The remain_index of all data are updated when there is no space in cache, and then a data which remain_index is the lowest will be replaced. Secondly, a DB_Cache is designed, and the arithmetic which based on accessing forecast is applied in DB_Cache. The cache and the arithmetic are proved to improve the performance obviously. In the method which based on Mysql Cluster, firstly, the shortage of Mysql blade's layout and the advantage of Mysql Cluster are analyzed. And then Mysql Cluster is introduced to be used in EPG system. Secondly, Mysql Cluster's install, configure and restart are introduced in detail. Lastly, the method is proved to improve the performance ulteriorly.In the end, UT starcom's EPG system is introduced.