Solved

ADVICE NEEDED FROM PROEVEN DATABASE AND HIGH TRAFFIC SITE EXPERTS  ONLY !

Posted on 2011-09-04
2
680 Views
Last Modified: 2012-05-12
PLEASE DO NOT ANSWER THIS QUESTION UNLESS YOU ARE A PROVEN DATABASE (MYSQL) EXPERT AND HAVE SOME EXPERIENCE WITH MODERATE TO HIGH TRAFFIC SITE.

Hi,

       First of all thanks for bearing with me. Since i do not want  just about anyone answering this question and then seeing the question being ignored since it's already been answered(even though the advice may not be relevant or qualified enough)  i put the above notice.


Apologies if it sounds rude to anyone.


However, I appreciate advice through multiple answers/experts and probably would allocate hundred times more points if it was in my hands.


Getting to the point,

 

 I have  a database design/schema  for a classifieds/listings site.   This is currently done in MyISAM engine so there are no relationships, keys etc.


I need to know if i'm on the right track with  the DB Design... (The Email and Password fields are redundant in both Users and Ads tables since the first plan was  not to require user registration but that plan was changed lately.  So, please ignore this bit since i'll remove these fields from Ads table)

It's expected that the site has the potential to do  at least a minimum of 100,000 page views a day  within a few months from launch.


Please advice about what do you think about this design and what could be done better.



I'm posting below the links to the images of ER diagrams for the current design.


http://i1192.photobucket.com/albums/aa322/techpics2011/er1.jpg


http://i1192.photobucket.com/albums/aa322/techpics2011/er2.jpg



Also please advice on the best Db Engine to use for such a site(InnoDb or any other...). I am posting a separate question for this.  Here's the  url to the question :



http://www.experts-exchange.com/Database/MySQL/Q_27290666.html
0
Comment
Question by:ee-itpro
2 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 36480727
It looks to be in a workable direction. If you combine this with INNODB over current MyISAM engine, you should be fine. I say that as you have the tables pretty normalized from my glancing at images. Therefore, the indexing and foreign keys will be important. Ensure to optimize MySQL for your situation. Here are some references:

http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
http://www.experts-exchange.com/Database/MySQL/A_1250-3-Ways-to-Speed-Up-MySQL.html

If you are on Linux, you can use the referenced mysqltuner.pl to help find the proper settings for your load.

Hope that helps!
0
 

Author Closing Comment

by:ee-itpro
ID: 36495807
Thanks... that helped a lot.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Why do we like using grid based layouts in website design? Let's look at the live examples of websites and compare them to grid based WordPress themes.
This video teaches users how to migrate an existing Wordpress website to a new domain.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now