?
Solved

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

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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Suggested Courses

719 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