943,815 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 1123
  • PHP RSS
Jul 16th, 2009
0

Innodb or Myisam

Expand Post »
Hi guys,
I'm wondering, web-sites like facebook and myspace, which MYSQL engines would be better to use?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
codemaker is offline Offline
20 posts
since Nov 2004
Jul 16th, 2009
0

Re: Innodb or Myisam

Well, I think they would probably use different engines for the specific job needed. But I will say now, they most likely use a WHOLE server just for a MySql server and nothing else. If you are planing on making a database heavy application then you really must have the MySql server on a dedicated machine.
Reputation Points: 31
Solved Threads: 27
Unverified User
Josh Connerty is offline Offline
342 posts
since Apr 2009
Jul 16th, 2009
0

Re: Innodb or Myisam

check out http://www.mysqlperformanceblog.com/ you will have to do some looking and some reading but provide a lot of really good information for performance tuning and/or what you can expect from both engines.
Sponsor
Reputation Points: 265
Solved Threads: 126
Practically a Master Poster
mschroeder is offline Offline
624 posts
since Jul 2008
Jul 16th, 2009
0

Re: Innodb or Myisam

I've checked the link but I'm still confused.
I've googled this question a lot but there is no direct answer.
Everyone says that Myisam is good when you have read operations only or update operations only. and Innodb is used when you have a mix between read and update. but what if you have many read operations and some update operations? It's right that you have read operations more than update but still.

I'm still confused. Please help
Reputation Points: 10
Solved Threads: 0
Newbie Poster
codemaker is offline Offline
20 posts
since Nov 2004
Jul 16th, 2009
0

Re: Innodb or Myisam

If in doubt use PostgreSQL
Reputation Points: 11
Solved Threads: 3
Light Poster
sysel is offline Offline
49 posts
since Jun 2009
Jul 22nd, 2009
0

Re: Innodb or Myisam

Click to Expand / Collapse  Quote originally posted by sysel ...
If in doubt use PostgreSQL
Now that is an accurate response.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dsherwin is offline Offline
1 posts
since Jul 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: Data Does Not Post To MYSQL
Next Thread in PHP Forum Timeline: output file problems





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC