hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Server or hardware specs for big MySQL database
Reply

Forum Jump

Server or hardware specs for big MySQL database

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 12-12-2005, 11:07 AM
ThaiZone ThaiZone is offline
Junior Guru Wannabe
 
Join Date: Aug 2002
Posts: 32

Server or hardware specs for big MySQL database


I would like to know if anyone every working with MySQL more than 5 million record of more than 1GB of database size.

I want to know the specs of the dedicated server that can handle these BIG database.

I think 2GB RAM is enough but I am not sure so I would like to have suggestion from the one who ever work with big database like this before


Thank you



Sponsored Links
  #2  
Old 12-12-2005, 12:30 PM
PerfTuner PerfTuner is offline
Web Hosting Guru
 
Join Date: Jul 2005
Posts: 256
Yeah, I run even somewhat larger DBs (largest is 4 gig one) on a simple P4/1GB box which also runs Apache/PHP.
But everything really depends on your usage patterns. If your queries are not properly optimized, things may be very slow on any server.
Anyway, 2GBs of RAM is enough cause MySQL will be able to always keep the whole DB cached in memory.

  #3  
Old 12-12-2005, 02:32 PM
netfreak netfreak is offline
Web Hosting Master
 
Join Date: Nov 2005
Location: BC, Canada
Posts: 754
On a related subject, has anyone had experience running a MySQL database with in the neighbourhood of 25,000-50,000 concurrent connections on a server with maybe one or two Opterons or Xeons?

__________________
|| Higher Intellect || Half a million documents and climbing.

Sponsored Links
  #4  
Old 12-12-2005, 03:07 PM
PerfTuner PerfTuner is offline
Web Hosting Guru
 
Join Date: Jul 2005
Posts: 256
That's not possible unless most of connections are idle. If you need to serve such a high load, you'll have to serialize some queries, MySQL Connector for Java has such capabilities (for PHP you can achieve the same effect by running a limited number of FastCGI servers, and backlogging all pending requests).

Reply

Related posts from TheWhir.com
Title Type Date Posted
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2013-08-19 12:25:00
Cloud Host Savvis Extends Cloud-Based Database Platform to European Customers Web Hosting News 2012-10-12 11:06:37
Jakarta Web Hosting Introduces MSSQL Server 2012 Hosting Services Web Hosting News 2012-04-23 11:18:07


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?