B
B
Bodik2011-08-04 12:50:12
MySQL
Bodik, 2011-08-04 12:50:12

How to disable the use of MyISAM?

We need to force users to use InnoDB. How can I disable the use of MyISAM engines for users on web hosting? Or limit to a minimum the possibility of filling dumps where MyISAM lives?

dev.mysql.com/doc/refman/5.1/en/show-engines.html
"All MySQL servers support MyISAM tables, because MyISAM is the default storage engine. It is not possible to disable MyISAM ”

but can you somehow pervert?

Answer the question

In order to leave comments, you need to log in

4 answer(s)
A
Anatoly, 2011-08-04
@taliban

Tell me the hosting on which you want to disable myisam so that I know which hosting not to use.

A
Anton Korzunov, 2011-08-04
@kashey

1. Send users notifications about MyIsam
2. Send a trigger\mysql-proxy that will turn myisam into innodb
3. For fulltext, add a sphinx to mysql
4. And all this can be advertised as bonuses, not restrictions

S
snevsky, 2011-08-04
@snevsky

Starnno, what exactly are the problems with MyISAM replication?

N
Nastradamus, 2011-08-04
@Nastradamus

And if you set the default engine to InnoDB? There is an opinion that most users use MyISAM only because it is the default.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question