Linode Forum
Linode Community Forums 		 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic

Board index » Linux Community Forums » Web Servers and Web App Development
  Previous topic | Next topic 
Author Message
taron
PostPosted: Sat Jun 26, 2010 10:40 pm 
Offline
Senior Newbie

Joined: Sat Apr 04, 2009 7:51 pm
Posts: 12
I have a Linode 1536 dedicated database server running MySQL 5.0.51a-24+lenny4 (Debian)

What should I set my.cnf values to?

Quote:
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M


The database server is for a vBulletin forum
Top
   
Reply with quote  
jankball
PostPosted: Sat Jun 26, 2010 11:17 pm 
Offline

Joined: Sat Jun 26, 2010 11:14 pm
Posts: 1
Hi taron,

There are a number of factors involved in determining the optimal MySQL memory settings.

For a quick guide, though, I'd recommend checking out the MySQL tuning primer script:

https://launchpad.net/mysql-tuning-primer

Regards,
Jankball
Top
   
Reply with quote  
Guspaz
 Post subject:
PostPosted: Mon Jun 28, 2010 10:03 am 
Offline
Senior Member
User avatar

Joined: Tue May 26, 2009 3:29 pm
Posts: 1691
Location: Montreal, QC
If the only thing this system does is run MySQL, you probably want to start with my-large.cnf (/usr/share/doc/mysql-server-5.0/examples/my-huge.cnf.gz or some similar directory)

While I haven't worked on a very high load site in some time, I find that generally I get good enough performance by picking the appropriate pre-fab mysql config file, so I spend my time elsewhere.
Top
   
Reply with quote  
Display posts from previous:  Sort by  
Post new topic  Reply to topic

Board index » Linux Community Forums » Web Servers and Web App Development


Who is online

Users browsing this forum: No registered users and 3 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group