Hi guys,
I'm wondering, web-sites like facebook and myspace, which MYSQL engines would be better to use?
codemaker 0 Newbie Poster
Josh Connerty 20 Unverified User
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.
mschroeder 251 Bestower of Knowledge Team Colleague
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.
codemaker 0 Newbie Poster
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
sysel 0 Light Poster
If in doubt use PostgreSQL
dsherwin 0 Newbie Poster
If in doubt use PostgreSQL
Now that is an accurate response.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.