Look at this ......

[Lallek]

hi ...

ok.. we got a dedicated databaseserver and some vb on it....

look at this thread and tell me the configuration to handle this.. the server is dual PIII 500 512MB..

installed php403p1 and mysql ..27

..postings in the big thread brings you to the file newreply.php ...but you will get an browsererror.

http://d2nforum.gamesweb.de/showthread.php?threadid=6765&pagenumber=lastpage

i wonder whats the best configuration :)

thanks

Lars Koschin
gamesweb.de Admin

[eva2000]

woah 3920 replies :eek:

[chrispadfield]

is it anything to do with the reply number? I thought the test here showed it was not. If it is how about closing the thread and starting a new one (part 2). Most forums do that often.

[Lallek]

..so do you think mysql/vb cant handle this thread ??

it must be kind of timeout ...
noone any suggestions for a good configuration ???

greets
Lallek

[chrispadfield]

chris schreiber is best person to ask, but you will need to post your current mysql and php settings for him to be able to recommend changes.

[Chris Schreiber]

Lars-

Can you post your current MySQL settings? If you have a file called /etc/my.cnf, please post the contents here. Also can you do a "mysqladmin -uroot -p variables" from a telnet prompt and post that here as well. There may be some setting we can tweak to help with your performance. Also, which version of vB are you running? I would strongly recommend upgrading to 1.1.4 if you haven't already. Also, have you added any indexes into your database?

Thanks,
-Chris

[Lallek]

i dont use vb 114 ...but i will upgrade soon.

here are the stats of my server:

Aborted_clients 1
Aborted_connects 0
Bytes_received 2479583
Bytes_sent 26934030
Connections 796
Created_tmp_disk_tables 0
Created_tmp_tables 49
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 74
Handler_read_first 266
Handler_read_key 11851
Handler_read_next 333763
Handler_read_prev 122
Handler_read_rnd 41298
Handler_read_rnd_next 2784880
Handler_update 830
Handler_write 1010
Key_blocks_used 423
Key_read_requests 34261
Key_reads 417
Key_write_requests 917
Key_writes 667
Max_used_connections 10
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 219
Open_files 431
Open_streams 1
Opened_tables 227
Questions 31723
Select_full_join 415
Select_full_range_join 0
Select_range 159
Select_range_check 0
Select_scan 15238
Slave_running OFF
Slow_launch_threads 0
Slow_queries 0
Sort_range 164
Sort_rows 77556
Sort_scan 2679
Threads_cached 5
Threads_connected 6
Threads_running 1
Uptime 3933


ansi_mode OFF
back_log 50
basedir /usr/local/mysql/
bdb_cache_size 8388600
bdb_home /data/
bdb_logdir
bdb_tmpdir /tmp/
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
connect_timeout 60
concurrent_insert ON
datadir /data/
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
join_buffer_size 131072
flush OFF
flush_time 0
init_file
interactive_timeout 28800
key_buffer_size 67104768
language /usr/local/mysql/share/mysql/english/
locked_in_memory OFF
log OFF
log_update ON
log_bin OFF
log_slave_updates OFF
long_query_time 120
low_priority_updates OFF
lower_case_table_names 0
max_allowed_packet 17824768
max_connections 500
max_connect_errors 500
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_recover_options OFF
myisam_sort_buffer_size 67108864
net_buffer_length 16384
net_retry_count 150
pid_file /usr/local/mysql/data/data.pid
port 3306
protocol_version 10
record_buffer 98304
server_id 0
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /tmp/mysql.sock
sort_buffer 102392
table_cache 16384
table_type MYISAM
thread_stack 65536
thread_cache_size 16384
timezone CET
tmp_table_size 1048576
tmpdir /tmp/
version 3.23.27-beta-log
wait_timeout 28800


my start-script:

bin/safe_mysqld --user=mysql --datadir=/data
-O thread_cache_size=15M -O table_cache=15M -O max_connections=500
-O max_connect_errors=500 -O connect_timeout=60 -O key_buffer_size=64M
-O long_query_time=120 -O net_retry_count=150 -O net_read_timeout=120
-O sort_buffer=100k -O record_buffer=100k -O max_allowed_packet=24M &

just remember this is a very busy site.... with lots of traffic ( right now 1 terra-byte).
i tried everything for now to bring this 2 threads back online ... but no chance.

thanks for any help

Lallek

[Chris Schreiber]

Originally posted by Lallek
i dont use vb 114 ...but i will upgrade soon.

You should upgrade as soon as possible since there are
many optimizations to most of the queries which should
help tremendously.

I would modify your startup script to the following:


bin/safe_mysqld --user=mysql --datadir=/data -O thread_cache_size=15M -O table_cache=15M -O max_connections=500 -O max_connect_errors=500 -O connect_timeout=60 -O key_buffer_size=64M -O long_query_time=120 -O net_retry_count=150 -O net_read_timeout=120 -O sort_buffer=6M -O record_buffer=6M -O join_buffer=6M -O max_allowed_packet=24M &


Also, please post your 'top' information about server load and memory usage.

Thanks,
-Chris

[Lallek]

3:01pm up 11 days, 20:47, 1 user, load average: 0.17, 0.23, 0.29
48 processes: 47 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: 7.0% user, 3.4% system, 0.0% nice, 89.4% idle
Mem: 523808K av, 501148K used, 22660K free, 0K shrd, 165176K buff
Swap: 136512K av, 0K used, 136512K free 281044K cached

PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
30847 mysql 10 0 21948 21M 1724 S 0 10.7 4.1 0:02 mysqld
30837 mysql 4 0 21948 21M 1724 S 0 3.3 4.1 0:03 mysqld
30841 mysql 2 0 21948 21M 1724 S 0 2.3 4.1 0:04 mysqld
30751 mysql 2 0 21948 21M 1724 S 0 2.1 4.1 0:22 mysqld
30835 mysql 2 0 21948 21M 1724 S 0 0.7 4.1 0:03 mysqld

[Chris Schreiber]

Thanks,

Looks pretty good, I would go ahead with those script changes when you get a chance... and try to schedule a time for the 1.1.4 update as well.

-Chris

[Lallek]

Hi Chris,

sorry.. used your scriptchanges and got an "Lost connection during querry"

:(

gruss
Lallek