Optimize MySQL - MySQLTuner

[Solutho]

Tables that have a lot of 'SELECT' queries being run on them will often end up being fragmented.

Hmmm... why does this happens? I mean the 'fragmented' part.

(Great thread, btw! Cheers)

[Rox]

I cannot seem to find the my.cnf file on kloxo! Any help will be appreciated.

I am not that good with ssh so i want to edit that file through kloxo. I am comfortable that way.

[pi0tr3k]

I'm worried about OPTIMIZE TABLE query, as I'm sure my mysql server will die.
I have tables with 4MILL records, ~12GB ..

How can I optimize such a big table, without any problems.?

[Whoo]

I'm worried about OPTIMIZE TABLE query, as I'm sure my mysql server will die.
I have tables with 4MILL records, ~12GB ..

How can I optimize such a big table, without any problems.?

Run it with the nice command.

[Sp32]

I cannot seem to find the my.cnf file on kloxo! Any help will be appreciated.

I am not that good with ssh so i want to edit that file through kloxo. I am comfortable that way.

It should be in the /etc/ folder?

What operating system are you running?

[Rox]

Centos

[Sp32]

Yes, it should be in the /etc/ folder called my.cnf

Can you not find it?

[Rox]

I cannot find the /etc/ folder lol

[Sp32]

the /etc/ folder should be a folder in your / directory, so you need to go to the highest directory then locate the etc folder, if in SSH type "cd /etc/" without quotes

I suggest you try SSH, it is very good once you are used to doing stuff, and nano is an extremely easy editor to use, as simple as notepad.

[Rox]

Arh! Will use SSH. Thanks for this post Sp