I am completely new to the whole server side of this and I am learning slowly, however, I cannot figure out how to use ssh!

I have been having mysql issues and would like to increase the table_cache. I am logged into ssh at the root. I have no clue how to view the etc/my.cnf file let alone edit it.

Is there a ssh tutorial, pdf file or something out there to help?

could someone point me in the right direction for this table_cache change?

thank you in advance!

once your at the shell prompt, enter the command:
pico -w /etc/my.cnf ... assuming this is where your mysql main configuration file is.
when the file is opened, hit CRTL+V to page down or CRTL+Y to page up. Look for the group heading in the file called mysqld and under this heading group enter or change your table_cache = SOME VALUE, then when your done, hit CRTL+O to save your changes, CRTL+X to exit out.

Then you will need to restart MySQL. Simple enter at the command prompt service mysql restart.

that should do it.

Mickalo

Thank you so much. The code didnt work (pico), I couldnt get in. I still dont know what I'm doing

I guess I'll try again tomorrow.

Pico isnt installed on every server

Try the same exact commands using nano instead

nano -w /etc/my.cnf

-bash: nano: command not found

-bash: pico: command not found


I must be doing something wrong....