Im on a vps right now. Can it bee seen from WHMpanel? I can't find it from /etc/my.cnf
Printable View
Im on a vps right now. Can it bee seen from WHMpanel? I can't find it from /etc/my.cnf
I'm not sure about the WHMPanel (don't use Cpanel or Cpanel products). However, you can see it from SSH (logging in via SSH as root).
So it looks like I can't get access that way. Unless I put in the wrong command
It says
root@server [~]# /etc/my.cnf
-bash: /etc/my.cnf: Permission denied
I can browse around and see if I can find away to find that file. I am pretty sure the limit is not set to 30minutes.
You have to open the file in a text editor of some sort (such as vi or nano). I.e. "vi /etc/my.cnf" or "nano -w /etc/my.cnf".
Ok I got in there. Heres what Im looking at. What do I need to change :)
skip-locking
character-sets-dir=/usr/share/mysql/charsets/
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
max_user_connections=100
max_connections=250
interactive_timeout=120
wait_timeout=30
connect_timeout=3000
thread_cache_size=96
key_buffer=16M
join_buffer=2M
max_allowed_packet=16M
table_cache=1024
record_buffer=2M
sort_buffer_size=1024K
read_buffer_size=1024K
I used nano /etc/my.cnf
Ah I see. How would I actually change it using putty. Is it just like setting a cron command?
I just got a response from my host so lets see if they will do it
Now that they have been busted..:)
I accidentally deleted some important lines because I tried to just change the time out command but didn't realize I had to change them all at once.
Al my sites were down that hole time, and I almost had a brain spasm. But thanks for the info. Although I havent tested it yet Im sure it works.
skip-locking
character-sets-dir=/usr/share/mysql/charsets/
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
max_user_connections=100
max_connections=250
interactive_timeout=120
wait_timeout=1800
connect_timeout=3000
thread_cache_size=96
key_buffer=16M
join_buffer=2M
max_allowed_packet=16M
table_cache=1024
record_buffer=2M
sort_buffer_size=1024K
read_buffer_size=1024K
Yep :) Even went to my remote server.