Tweak Settings::
1 To access the Server Configuration Menu, click on Server Configuration, on the main screen of your WebHost Manager interface. 2 Click on Tweak Settings.
http://www.cpanel.net/docs/whm/Tweak_Settings.htmHOME |
George(Eva2000), hope you read this ;)
I am just moving to my first dedicated server, and I would like to use your tweaking service a bit ;)
Specs:
AMD DURON 1GHz
512MB RAM
20GB Hard Drive
Average users will be ~90, max will be at 140 I guess
current my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Thank you!
Tom
ok, thank you George- it is running again...
what should I do now? leave it running ?
If I upgrade mysql can I leave my my.cnf as it is now?
Thank you
just replace my my.cnf with this one, right?
please forgive the pre written text but it's easier :o
please provide the following
1. your server specs, such as mysql and php version
2. if possible how mysql was compiled/installed
3. your top stats
4. your mysql configuration variables located at /etc/my.cnf or c:my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type
mysqladmin -u root -p variables
copy and paste output here
5. your mysql extended-status output either still telnet as root user type
mysqladmin -u root -p extended-status
copy and paste output here
or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477
and post url to that here
6. oh and is your vB the only thing on the server? or other scripts? sites?
7. how many average and max concurrent users on your vB forum ?
Originally posted by Dontom
ok, thank you George- it is running again...
what should I do now? leave it running ?
If I upgrade mysql can I leave my my.cnf as it is now?
Thank you yes you can leave my.cnf as it is
Originally posted by Dontom
just replace my my.cnf with this one, right? yup :)
thank you!
Tom
Hi George,
I got a ram upgrade to 1 gig - leave my.conf as is or change it?
Thank you
Tom
Originally posted by discussfitness
Dumb question - but where else could my my.conf file be? I looked in /etc/ but couldn't find it. Any other places would be great. I'm with Rackspace.com :D if you don't have that file you need to log into telnet and as root user type
mysqladmin -u root -p variables
and copy and past the output here
also yes i' still have a raq4 server with rackshack.net but for their intel/amd servers i don't recommend them anymore still alot of issues with those servers of theres just check the rackshack.net forums and you'll see
Originally posted by Dontom
Hi George,
I got a ram upgrade to 1 gig - leave my.conf as is or change it?
Thank you
Tom i'd leave it as is for a few weeks and see if there are any problems... basically you should be fine with the my.cnf i recommended... Using Moodle: New Windows Install Slow and Unusable::
Jan 29, 2008 As you adjust your MySQL settings (and PHP RAM as well) it is . We are going to end up purchasing a new server around 3-4GHz and 4+ GB
http://moodle.org/mod/forum/discuss.php?d=89143HOME |
Dumb question - but where else could my my.conf file be? I looked in /etc/ but couldn't find it. Any other places would be great. I'm with Rackspace.com :D
place this in a /etc/my.cnf file and restart mysql
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=600
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=2M
set-variable = record_buffer=2M
set-variable = sort_buffer=3M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
[safe_mysqld]
open-files-limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=128M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
Hi George, here my specs:
AMD DURON 1GHz
512MB RAM
20GB Hard Drive
php 4.06
mysql 3.23.36 (installed by rpm)
Top (~90 User online)
12:48pm up 9 days, 11:06, 1 user, load average: 0.75, 0.63, 0.60
95 processes: 92 sleeping, 3 running, 0 zombie, 0 stopped
CPU states: 40.9% user, 3.5% system, 0.0% nice, 55.5% idle
Mem: 497240K av, 417680K used, 79560K free, 0K shrd, 25288K buff
Swap: 265064K av, 3248K used, 261816K free 204528K cached
Variables:
ansi_mode OFF
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_log_buffer_size 32768
bdb_home /var/lib/mysql/
bdb_max_lock 10000
bdb_logdir
bdb_shared_data OFF
bdb_tmpdir /tmp/
bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (March 27, 2001)
Quick 'n' Easy LAMP Server for Centos/RHEL::
To create a new mysql user 'guest' with 'all previleges' on database 'demo' can be handy to tweak settings in your server if you are beginner to linux!
http://www.mysql-apache-php.com/centos-lamp-server.htmHOME |
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620
concurrent_insert ON
connect_timeout 5
datadir /var/lib/mysql/
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
have_bdb YES
have_gemini NO
have_innobase NO
have_isam YES
have_raid NO
have_ssl NO
init_file
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language /usr/share/mysql/english/
large_files_support ON
locked_in_memory OFF
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names 0
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_recover_options OFF
myisam_sort_buffer_size 8388608
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file /var/run/mysqld/mysqld.pid
port 3306
protocol_version 10
record_buffer 131072
query_buffer_size 0
safe_show_database OFF
server_id 0
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer 2097144
table_cache 64
table_type MYISAM
thread_cache_size 0
thread_stack 65536
transaction_isolation READ-COMMITTED
timezone CET
tmp_table_size 1048576
tmpdir /tmp/
version 3.23.36
wait_timeout 28800
Extended Status:
+--------------------------+------------+
Variable_name Value
+--------------------------+------------+
Aborted_clients 33
Aborted_connects 0
Bytes_received 580190756
Bytes_sent 2424519241
Connections 62306
Created_tmp_disk_tables 10214
Created_tmp_tables 90880
Created_tmp_files 92
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 3
Handler_delete 24996
Handler_read_first 65761
Handler_read_key 23001736
Handler_read_next 978749625
Handler_read_prev 986
Handler_read_rnd 33366916
Handler_read_rnd_next 752092534
Handler_update 791730
Handler_write 3958777
Key_blocks_used 7793
Key_read_requests 159618953
Key_reads 5503455
Key_write_requests 740279
Key_writes 241326
Max_used_connections 49
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 64
Open_files 118
Open_streams 0
Opened_tables 12451
Questions 8729301
Select_full_join 9557
Select_full_range_join 5
Select_range 913897
Select_range_check 0
Select_scan 379937
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Slow_queries 49
Sort_merge_passes 0
Sort_range 881075
Sort_rows 62069196
Sort_scan 239505
Table_locks_immediate 3902018
Table_locks_waited 657
Threads_cached 0
Threads_created 62305
Threads_connected 13
Threads_running 1
Uptime 817703
I am running Postnuke as portal combined with (standalone)vb for forums.
Average users is ~90, max is 130 until now.
Thank you!
Tom
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
HOME