It is currently Fri Sep 18, 2020 3:11 pm

All times are UTC + 5:30 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Sat Aug 06, 2016 12:04 pm 
Offline

Joined: Mon Mar 14, 2016 12:36 pm
Posts: 48
Dedicated Web Server Handles How Many Mysql Queries?


Top
 Profile  
 
PostPosted: Sat Aug 06, 2016 1:09 pm 
Offline

Joined: Tue Jul 12, 2016 12:19 pm
Posts: 48
Generally speaking, performance of a given dedicated server depends largely on the hardware available for the server, configuration of the server and last but not the least, type of the query.

Dedicated web server can handle about 250 MySQL queries per second, provided it is a Quad Core dedicated server.

It is very important to have a proper MySQL configuration of the dedicated server. Ideally you should configure it according to your requirement. Secondly, the size and speed of Solid State Drives can also impact the performance. Number of queries to be handled is also affected by the type of queries. You can improve the performance by taking care of all these parameters.


Top
 Profile  
 
PostPosted: Tue Jun 11, 2019 2:26 pm 
Offline
Site Admin

Joined: Sat Jan 04, 2014 12:08 pm
Posts: 73
Yes, it is possible to manage unlimited MySQL queries provided you have a dedicated server. The obvious reason being, the complete resources that the server offers are exclusively with you. This may not be possible in the other web hosting platforms like VPS hosting and shared hosting since the resources are split across several users.

Dedicated server is a single-tenant platform which assures of the highest level of performance. It is fully customizable, gives complete control, and dedicated monitoring of the servers. The dedicated server is built to handle high traffic and can easily handle millions of MySQL queries. The issues of downtime or speed will not come in dedicated servers.

Even if the server receives over 2 million queries. A quad core dedicated server can easily handle such traffic with 100% uptime. In case the queries increase the client will need to upgrade their server and buy a dual quad core or dual-Hexa core server to ensure there is no performance issues.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 5:30 hours


Who is online

Registered users: Bing [Bot], RonaldNak


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron