 |  |  |  |  |  |  |  |
Innodb or Myisam
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Hi guys,
I'm wondering, web-sites like facebook and myspace, which MYSQL engines would be better to use?
I'm wondering, web-sites like facebook and myspace, which MYSQL engines would be better to use?
•
•
Join Date: Apr 2009
Posts: 340
Reputation: 
Solved Threads: 26
Posting Whiz
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.
Posts should be like mini-skirts, long enough to cover enough, but not too long that you cover too much.
My Liveperson: http://liveperson.com/josh-connerty/
My Liveperson: http://liveperson.com/josh-connerty/
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.
If you're question/problem is solved don't forget to mark the thread as Solved!
-- Code I post is usually but not always tested. If it is tested it will be against 5.2.12 or 5.3.1
-- Code I post is usually but not always tested. If it is tested it will be against 5.2.12 or 5.3.1
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
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
|
Similar Threads
- Need advice in mysql performance tunning (MySQL)
- MyISAM vs InnoDB (MySQL)
- Foreign key constraint fails (MySQL)
- Which is better for storing user data? (PHP)
- Mysql select query takes more time (MySQL)
- Querys Bug (MySQL)
- innodb vs myisam (MySQL)
Other Threads in the PHP Forum
- Previous Thread: Data Does Not Post To MYSQL
- Next Thread: output file problems
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess 301 access ajax apache api array beginner binary broken cakephp checkbox class cms code compression cron curl database date directory display download dropdown dynamic echo email error file files folder form forms function functions google href htaccess html httppost image include insert integration ip java javascript joomla limit link login loop mail md5 menu methods mlm mod_rewrite multiple mysql oop parse paypal pdf php problem query radio random recursion regex remote script search secure select server sessions sms soap source space speed sql structure syntax system table tutorial update upload url validation validator variable video votedown web xml youtube
