?
Solved

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

Posted on 2011-09-04
2
Medium Priority
?
699 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 61

Accepted Solution

by:
Kevin Cross earned 2000 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
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…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses

588 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