innodb vs myisam

whats the difference between a table created in innodb and one created in myisam?'Advantages/disadvantage of innodb over myisam and which will you recommend on a web based application specifically meant for dating?

thanx u all.

mysql

Contributors

Replies

Views

12 Years

Discussion Span

8 Years Ago

Last Post by sen1989

This thread should answer your question: http://www.daniweb.com/techtalkforums/thread40911.html

in my experience, myisam is better for high read volumes, innodb for high update volumes due to table vs row locking.

innodb is journaled, and can recover from crashes where myisam can't, much like NTFS vs FAT file systems.

myisam has full-text indexing, innodb doesn't.

innodb has transaction support, commits and rollbacks, myisam lacks these.

Myisam is default database engine It's not supported in transction.
But Innodb supported all transactions.

mysql

This topic has been dead for over six months. Start a new discussion instead.

I want to create a php function that i can use to get a particular user details and display the info gotten in my ProfileActivity when a user profile is ...

hello everyone im taking database course this year and it's my first time to take it so i need help how to draw a ERD for following busniess case AND ...

//How to change cin and cout to printf and scanf???

#include <iostream>
using namespace std;

char square[10] = {'o','1','2','3','4','5','6','7','8','9'};

int checkwin();
void board();

int main()
{
    int player = 1,i,choice; ...