Top "Myisam" questions

MySQL MyISAM table locking

Does a MySQL MyISAM table gets locked when records are deleted from it?

sql mysql locking myisam

MySQL FULLTEXT not working

I'm attempting to add searching support for my PHP web app using MySQL's FULLTEXT indexes. I created a test table (…

mysql full-text-search myisam

Make a query in mysql without invoking a trigger (How to disable a trigger)

I have 2 tables: comments and comments_likes. comments id message likes triggers: AFTER DELETE DELETE FROM comments_likes WHERE comment_…

mysql triggers myisam

MySQL Full-text Search Workaround for innoDB tables

I'm designing an internal web application that uses MySQL as its backend database. The integrity of the data is crucial, …

mysql search innodb myisam full-text-search

unknown variable 'default-storage-engine=myisam'

I am trying to configure Mysql (Ver 14.15 Distrib 6.0.8-alpha, for Win64) to use MyISAM as the default storage engine on …

mysql myisam storage-engines

InnoDB performance tweaks

I'm switching a large table to InnoDB from myISAM. There has been a lot of discussion regarding why switching makes …

mysql innodb myisam

Joining InnoDB tables with MyISAM tables

We have a set of tables which contain the meta level data like organizations, organization users, organization departments etc. All …

mysql innodb myisam

Mysql changing table engine MyISAM to InnoDB

On my site I have a visitor's table with 10 million rows. Every request to the site inserts row to the …

mysql innodb myisam

What is maximum records quantity a MySQL table can store?

How many records can a MySQL MyISAM table store? How many InnoDB can?

mysql innodb myisam

What's the safest way to convert table with InnoDB to MyISAM?

My database is currently using the InnoDB engine. Now I want to add the fulltext search feature, which is why …

mysql innodb myisam