I currently have two dedicated servers hosting my site which has about 7000 members: www.mymaturespace.com. I don't know how much it'd cost so i just put $30-$100, you're welcome to bid according to how much you think this project should cost.
Even after I made server 1 a web server, and server 2 a MySQL server, the site is still super slow. When there are about 300 guests online, the site is fine. But when there are 600-1000 guests online, it'd take me 5-10 minutes to log in and sometimes I can't at all.
When I checked server 2 (MySQL server) by typing in "top" in SSH , the CPU is consuming 99.9% when there are a lot of users on the site.
I know it's not a hardware problem because I experienced the same thing @ [url removed, login to view]'s dedicated servers.
Please bid only if you have a solution to make my site faster and can implement this.
Hi! I think your problem is in a bad querrys. I'm working in local ISP, we have MySQL database > 7GB and >8000 customers - i have a lot of experience in optimising MySQL. Let's discuss details in PM. Regards, Sergey.