Analysis and Neural Networks Modeling of Web Server Performances Using MySQL and PostgreSQL

作     者：Fontaine Rafamantanantsoa Maherindefo Laha 

作者机构：University of Fianarantsoa Fianarantsoa Madagascar 

出 版 物：《Communications and Network》 (通讯与网络（英文）)

年 卷 期：2018年第10卷第4期

页      面：142-151页

学科分类：1002[医学-临床医学] 100214[医学-肿瘤学] 10[医学] 

主　　题：Web Server Performances Neural Network Database Server MySQL PostgreSQL Apache Mean Response Time Apache Benchmark SNNS 

摘      要：The purpose of this study is to analyze and then model, using neural network models, the performance of the Web server in order to improve them. In our experiments, the parameters taken into account are the number of instances of clients simultaneously requesting the same Web page that contains the same SQL queries, the number of tables queried by the SQL, the number of records to be displayed on the requested Web pages, and the type of used database server. This work demonstrates the influences of these parameters on the results of Web server performance analyzes. For the MySQL database server, it has been observed that the mean response time of the Web server tends to become increasingly slow as the number of client connection occurrences as well as the number of records to display increases. For the PostgreSQL database server, the mean response time of the Web server does not change much, although there is an increase in the number of clients and/or size of information to be displayed on Web pages. Although it has been observed that the mean response time of the Web server is generally a little faster for the MySQL database server, it has been noted that this mean response time of the Web server is more stable for PostgreSQL database server.