my.cnf

[Loco_Mike]

Dear users , i have a problem

My dedicated server is a P4 2.8D with 2 gig memory
MySQL client version: 5.0.67
and i am running Debian 4.0

i found my.cnf

/etc/my.cnf: Permission denied

how to edit?

Thanks

 

[sce]

Are you editing it from shell console, ftp, web script??? Are you logged in as root? ... more input please.

 

[Loco_Mike]

Yes i'm logged in as ROOT
i want to edit it with ssh program putty

 

[daveyw]

You can open that file by

nano /etc/my.cnf

pico /etc/my.cnf

vi /etc/my.cnf

Or whatever you want
Be sure you know what you are doing!

 

[floyd]

/etc/my.cnf: Permission denied

Your tried to run the my.cnf file instead of editing it.

You need some practice first on files that don't matter until you are comfortable using a file editor. Don't let my.cnf be the first file you edit on the server. Create some new files to practice on.

 

[Loco_Mike]

yes now i can edit it , but i have a big question about it , i have 2 gig memory and a p4 2.8d CPU ,

I want the best my.cnf file can anybody help me out with this ? my.cnf is now this


[client] port = 3306 socket = /tmp/mysql.sock

[mysqld]
port = 3306
socket = /tmp/mysql.sock skip-locking
key_buffer = 128M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 8M
read_buffer_size = 2M
join_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache = 128
query_cache_size = 128M
max_connections = 150
thread_concurrency = 2
tmpdir = /tmp/
wait_timeout = 60
connect_timeout = 10
long_query_time = 4
log_slow_queries = /var/log/mysql/slow_query.log

innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_arch_dir = /usr/local/mysql/data/

[safe_mysqld]
err-log = /var/log/mysql/error.log
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 1M

[mysql]
no-auto-rehash

[mysqlhotcopy]
interactive-timeout = 60

 

[floyd]

The knowledgebase is there for a reason.

http://help.directadmin.com/item.php?id=44