Top "Myisam" questions

How can I check MySQL engine type for a specific table?

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which …

mysql innodb myisam

How to properly create composite primary keys - MYSQL

Here is a gross oversimplification of an intense setup I am working with. table_1 and table_2 both have auto-increment surrogate …

mysql primary-key myisam composite-key composite-primary-key

MyISAM versus InnoDB

I'm working on a projects which involves a lot of database writes, I'd say (70% inserts and 30% reads). This ratio would …

mysql database performance innodb myisam

What's the difference between MyISAM and InnoDB?

I understand that this question has been asked before, but most of the time it is asked in relation to …

mysql database innodb myisam

How to test an SQL Update statement before running it?

In some cases, running an UPDATE statement in production can save the day. However a borked update can be worse …

mysql sql database testing myisam

Is there a REAL performance difference between INT and VARCHAR primary keys?

Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I'd like to …

mysql performance primary-key innodb myisam

What is InnoDB and MyISAM in MySQL?

What is InnoDB and MyISAM in MySQL ?

mysql innodb myisam

mysql error 'TYPE=MyISAM'

Below query I'm executing in Ubuntu 12, MySQL 5.1 version and receiving error as mentioned: CREATE TABLE mantis_config_table ( config_id …

php mysql syntax-error myisam

How do I know if a mysql table is using myISAM or InnoDB Engine?

In MySQL, there is no way to specify a storage engine for a certain database, only for single tables. However, …

mysql innodb myisam storage-engines

How to lock a single row

I have a user table with field lastusedecnumber. I need to access and increment lastusedecnumber. During that accessing time I …

mysql locking myisam