List:General Discussion« Previous MessageNext Message »
From:jeetendra.ranjan Date:October 15 2009 5:05am
Subject:Re: Re: Req. suitable .cnf file for Server used by 2000 users
daily
View as plain text  
Hi Shawn,
 
Thanks for your reply.
This is basically a marketing website for different products. The site will be visited by
the marketer and the customer. 
 
Here is answer as you asked:
 
1) The customer and the marketer will visit only one database and they have no right to
create database by them.
 
2) Its multiple query per visitor which uses tables in only one database.
 
3) Few tables will be very haeavy and there may be millions of rows in one tables.
 
4) Few heavy tables are Innodb and few are MyISAM
 
5) Yes, MySQL database sharing the same box as  web server.
 
I mostly concern about connectoins. Initially 2000 visitor including marketer and customer
will visit this site.
 
Thanks in advance.
 
 
Regards
Jeetendra Ranjan
 
At 21:21 14/10/2009, Shawn Green wrote:


jeetendra.ranjan@stripped wrote:
> Hi,
> Will you plesae guide me ?
> We are about to launch one website whose database is in MySQL. I am very exited about
> the server setting specially about .cnf file.
> I have below hardware and .cnf details. Will you please guide me is the .cnf file
> details sufficient to support current hardware. 
> Initially 2000 users will visit this site everyday.
>  
> Hardware and OS
> *************
> ... snip ...

Unfortunately, you have not asked us an answerable question. There are 
too many unknowns in your setup for us to estimate how much database 
usage per customer your site will create. If it's a single query per 
visitor, then you probably can omit any tuning at all. If each visit 
requires dozens of queries each using multiple tables then you have a 
totally different usage profile.

It all boils down to what you are doing to the database, not how many 
people are doing it.

What can you tell us about your application, how many rows of data you 
plan to manage, if your data is mostly MyISAM or InnoDB, and what 
performance numbers you have achieved so far using your lab equipment 
and a simulated user load. Also, is your MySQL database sharing the same 
box as your web server or are they located in separate machines?

At that point, we may be able to make a reasonable guess about your 
situation.

-- 
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN




Thread
Req. suitable .cnf file for Server used by 2000 users dailyjeetendra.ranjan14 Oct
  • Re: Req. suitable .cnf file for Server used by 2000 users dailyShawn Green14 Oct
    • Re: Re: Req. suitable .cnf file for Server used by 2000 usersdailyjeetendra.ranjan15 Oct
  • RE: Req. suitable .cnf file for Server used by 2000 users dailyGavin Towey15 Oct
    • Re: Req. suitable .cnf file for Server used by 2000 users dailyBruce Ferrell15 Oct
  • Re: Req. suitable .cnf file for Server used by 2000 usersdailyJeetendra Ranjan20 Oct
    • Re: Req. suitable .cnf file for Server used by 2000 users dailyBruce Ferrell20 Oct
  • Re: Req. suitable .cnf file for Server used by 2000 usersdailyJeetendra Ranjan28 Oct