Hi gang - just setting up a new box (dual Athlons, 3GB RAM, 15K RPM SCSIs) :D This will be a fairly busy VB install.
Any thoughts on mySQL settings? Currently, I'm looking at something like:
max_connections = 250
key_buffer = 64M
join_buffer = 6M
table_cache = 256
sort_buffer = 8M
record_buffer = 8M
myisam_sort_buffer_size = 16M
thread_cache_size = 128
thread_stack = 128K
thread_concurrency = 4
All input welcome!
Cheers.
*bump*
lol - sorry - I was just editing my message when you posted - corrected typo, as well as added new info on this box. Amazon.co.uk: Sarah L. Willis "Head's review of Sony ICF-CD855L ::
Solid, reliable and does excatly what it says on the tin, 14 Feb 2007 Before I got the Dream Machine I had an old hi-fi on which the radio didn't work,
http://www.amazon.co.uk/review/R9KD6CTLIHGCWHOME |
Jura-Capresso Impressa F8 13345 Review: Powered by ConsumerGuide ::
Aug 10, 2007 Jura-Capresso is the Rolls Royce of espresso machines. a professional solid- steel conical burr grinder with six settings,
http://products.howstuffworks.com/jura-capresso-impressa-f8-13345-review.htmHOME |
Originally posted by unixman
Thanks for the comments, Eve, but I can't bloody well post stats on a box that is still under construction. :) Eve ? :eek:
doh :o
to help advise you 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
Bread Machine Reviews; Best Bread Machines, Breadmakers::
The Zojirushi gets solid reviews from owners, but we did find a smattering of The Panasonic bread machine doesn't have custom settings, a jam cycle or a
http://www.consumersearch.com/bread-machinesHOME |
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?
generally for your 3GB of memory, i'd at least place my.cnf with the below to start
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=500
set-variable = key_buffer=16M
set-variable = join_buffer=9M
set-variable = record_buffer=9M
set-variable = sort_buffer=12M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
[safe_mysqld]
open-files-limit=8192
[myisamchk]
set-variable = key_buffer=512M
set-variable = sort_buffer=512M
set-variable = read_buffer=64M
set-variable = write_buffer=64M
Thanks for the comments, Eva, but I can't bloody well post stats on a box that is still under construction. :)
However, the box will run all sorts of stuff, java chat, tons of PHP and Perl scripts, etc.
VB Membership is around 5,000 for this system with anywhere from 20-75 people on at any given time. The current VB has about 250,000 posts.
Cheers.
Scott
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market
|
