Sure Nixcraft,
Code:
[mysqld]
max_connections = 4900
key_buffer = 512M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 2500
thread_cache_size = 64
wait_timeout = 3600
connect_timeout = 300
max_allowed_packet = 16M
max_connect_errors = 1000
query_cache_limit = 4M
query_cache_size = 48M
query_cache_type = 1
skip-innodb
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
We dont use any acceleration or cache, however, our SELECT *'s on the webserver are cached using AdoDB's file cache, but on the uploading application server there is no cache being used, the folks at the datacenter suggest that the latency might just be too high for MySQL
but that seems ridiculous.