Threaded Mode | Linear Mode

juaribd · 07-27-2010, 11:58 AM

You can enable MyISAM by accessing your server via SSH as root ( or another account then use su or sudo to gain root access). Once that is done, check /etc/my.cnd for an entry like:

skip-inndob

If such an entry exists, remove or comment out the entry and restart MySQL.

If such an entry does not exist, then there are other problems for which we will need more information.

Once MyISAM is enabled, you can make it the default table type by specifying the following in /etc/my.cnf:

default-table-type=MyISAM

thebeyond · (This post was last modified: 07-29-2010 05:58 AM by thebeyond.)

Nice tutorial again!

Better tut:

You can do it by simply locating your my.cnf files (which is the mysql configuration file) usually in /etc/ if you are on centos.

Edit this file with the following vi command in the terminal:

vi /etc/my.cnf

and find the line skip-MyISAM
You need to comment this line by adding the # sign before it. It should look like this:

#skip-MyISAM

Now save the file by entering:

:wq

And restart your mysql service with the following command if you are on centos and you are done.

service mysql restart

Your installation should go well now.

This is a better tutorial as it is more detailed.

**dmmcintyre3** · 10-15-2010, 01:57 AM

This should be titled "How to waste 100MB of RAM"

**gbl08ma** · 10-15-2010, 04:30 AM

(10-15-2010 01:57 AM)dmmcintyre3 Wrote: This should be titled "How to waste 100MB of RAM"

Yes, this is an almost useless tutorial. I don't find anything needing MyISAM to work, it's just a waste of RAM.

luis123456 · 10-15-2010, 04:34 AM

I have this line, and skip-locking too.

eSupun · 10-16-2010, 08:26 AM

(10-15-2010 04:30 AM)gbl08ma Wrote:
(10-15-2010 01:57 AM)dmmcintyre3 Wrote: This should be titled "How to waste 100MB of RAM"
Yes, this is an almost useless tutorial. I don't find anything needing MyISAM to work, it's just a waste of RAM.

I don't accept it!

It's just another tutorial which tells you how to enable MyISAM.
There are tutorials guiding you to install Apache, MySQL and many other programs. They are also wasting your RAM.
Isn't it a waste of RAM? Tongue

MyISAM may be not important for you. But there may be people who are looking for it. So this guide is for them.

You should at least appreciate his work.

The thing I need to tell the OP is,
Thank you.

luis123456 · 10-16-2010, 08:46 AM

(10-16-2010 08:26 AM)eSupun Wrote:
(10-15-2010 04:30 AM)gbl08ma Wrote:
(10-15-2010 01:57 AM)dmmcintyre3 Wrote: This should be titled "How to waste 100MB of RAM"
Yes, this is an almost useless tutorial. I don't find anything needing MyISAM to work, it's just a waste of RAM.

I don't accept it!

It's just another tutorial which tells you how to enable MyISAM.
There are tutorials guiding you to install Apache, MySQL and many other programs. They are also wasting your RAM.
Isn't it a waste of RAM?

MyISAM may be not important for you. But there may be people who are looking for it. So this guide is for them.

You should at least appreciate his work.

The thing I need to tell the OP is,
Thank you.

But the thing is,
I don't use it. Most people don't too.

I'd also say thank you, in this case.

eSupun · 10-16-2010, 05:14 PM

Yes it's not used by many people. But it does not mean anyone don't use it. And it's still a tutorial.

Many people don't use Kloxo panel. But Kloxo install guides do exist.

**gbl08ma** · 10-16-2010, 10:02 PM

The guide would be better if it explained users that MyISAM is not useful for most people, and for those it is a waste of RAM. Because there are many people that think that enabling just everything they can on their VPS is good, and sometimes it is not. The guide should warn those users that MyISAM may not be necessarily needed or not bring any advantage at all.