Solved

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

Posted on 2011-09-04
2
684 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL Grouping 2 43
mysql ide 10 40
when to use sequences in mysql 4 30
Responsive Design or Mobile Sites? 4 31
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to dynamically set the form action using jQuery.

803 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