As we already know, hostgator database size is not limited to certain number of file size per database. Your hostgator hosting plan can have MySQL database can be in any size, 1MB, 100MB, or more… as long there is sufficient disc space in your cpanel account to host the file size. If you are concerning about hostgator hosting is handling mysql database query size and want to know what the limit is… the better question to ask is how many simultaneous mysql database connection is allow at your hostgator hosting. As we found out, each of your cpanel account allow you to execute 25 MySQL database connection at the same time. Usually a PHP script that carry out sequence of mysql queries will complete the query within second and close the database connection, regardless how many queries per connection, its counted as one database connection only. The chance to have 25 simultaneous mysql database connection at one time from your cpanel account is very small. Unless you are running a website with thousand of user online at the same time for example.
Also, hostgator mysql server will timeout in 15 to 30 second of inactivity. Meaning the mysql database connection made will be terminated if there is no activity by php scritps for example. This help recover and release the database resource back to server.
Hostgator hosting is now offering 20% discount off regular price $4.95 per month, use the hostgator coupon to entitle!
 |
View more HostGator Reviews and HostGator Coupons from this HostGator Review site! Hostgator Coupons 25% Discount : HOSTGATOR371 |
One Response to “Want to know what is the hostgator MySQL database query limit?”
Leave a Reply
You must be logged in to post a comment.
August 19th, 2011 at 3:48 pm
Sounds interesting, however, I had over 100 resource warnings, and I only have 12 domain running under one plan, this has created a huge issue for my websites running wordpress, so I guess the number one question to ask here is hostgator friendly to wordpress, my guess is a big fat, (no)