MySQL & Communities/Forums?
Posted 09 March 2006 - 09:24 AM
I've been concerned however, every once in awhile I'll recieve little errors with the database, here are a couple:
mySQL error: Too many connections
User '__name__' has exceeded the 'max_questions' resource (current value: 50000)
I don't even know if these are limits that can be changed or just errors in general.
It's troubling because I have no idea how limited a MySQL database can be. And before I go about looking for a host specifically for a MySQL-driven community I want to make sure there are no limitations.
I've gone to other communities in my i-net experience and have never seen any kind of error with the database, and these communities are HUGE! I just wonder what I should be looking for, as far as hosting/database capabilities.
Posted 09 March 2006 - 01:42 PM
Are you renting a shared server? Your host may be limiting your account to try to ensure quality of service for everyone on that machine, or it could just be misconfigured.
In general, MySQL has a lot of performance parameters to help keep your machine from crashing, but if you tune those parameters, it is only limited by the hardware capabilities. Compared with other database solutions, MySQL is one of the best performers around, so you're not going to do much better with the same hardware.
If you're looking at very high traffic, you may have to look into multi-server load balancing. Some webhosts will manage that kind of thing for you (for a price). Very few sites ever really push a modern server machine to its limits unless they are writing bad queries.
The first thing you should do when you are experiencing performance problems is start tracking down slow queries and find ways to speed them up.
Posted 09 March 2006 - 10:36 PM
Posted 10 March 2006 - 12:13 AM
You should start off small and upgrade your service as needed. Make sure you write your web application in such a way that upgrading or moving servers will be easy. You'll probably want to make it PHP4 compatible as most shared-server hosts are still using it. If you rent a whole machine then you usually have the freedom to install whatever you want, but that can be expensive.
Personally I would recommend a host that can offer you a linux/unix/bsd server running at least Apache, MySQL 5, Perl, and PHP 5. SSH access is often helpful as well. Be sure to consider price, storage, server specs, number of other users on your server(s), overall transfer limits, what happens when your users bust your limit, uptime, and turnaround on your support requests.
Posted 10 March 2006 - 01:18 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users