Solved

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

Posted on 2011-09-04
2
688 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 60

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmakerā€¦

734 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