Top "Myisam" questions

Changing Table Engine in MySQL

I am using mysql and mysql workbench. I created 5 tables with innodb engine. I checked their engine and it was …

mysql database innodb myisam

Why to use foreign keys with no action on delete or update

I have a question of interest: I have 2 tables in mysql with InnoDb. table tbl_a has a primary key, …

mysql foreign-keys innodb myisam

Why doesn't MySQL's MyISAM engine support Foreign keys?

I am writing a web-app for my studies which includes fulltext search and foreign keys. I have read somewhere, MyISAM …

mysql database innodb myisam

Query time result in MySQL w/ PHP

Is there a way that I can get the time of a MySQL query (specifically with PHP)? The actual time …

php mysql time myisam

MyIsam engine transaction support

I was testing transaction support in innoDB tables, and just for the curriosity I tried to run the same transaction …

mysql myisam

#1033 - Incorrect information in file: './database_name/table_name.frm'

I'm completely lost as to how or why this error is displaying when I go to browse the table data. …

php mysql phpmyadmin innodb myisam

What is the InnoDB equivalent of MyISAM's key_buffer_size?

When using MyISAM the configuration setting key_buffer_size defines the size of the global buffer where MySQL caches frequently …

mysql performance innodb myisam

MySQL MyISAM how to perform a read without locking a table?

My question is a follow up to this answer. I want to find out how to perform a select statement …

mysql sql myisam

MySql: MyISAM vs. Inno DB!

What are the differences between MyISAM and Inno DB types in MySql?

mysql database innodb myisam

Performance difference between Innodb and Myisam in Mysql

I have a mysql table with over 30 million records that was originally being stored with myisam. Here is a description …

mysql database innodb myisam