my.ini 2g

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
Marty_
-


Joined: 21 Feb 2006
Posts: 55

PostPosted: Mon Oct 08, 2007 10:12 am    Post subject: my.ini 2g Reply with quote

The settings for my-huge.ini read as follows...
Code:
# Example MySQL config file for very large systems.
#
# This is for a large system with memory of 1G-2G where the system runs mainly

# The MySQL server
[mysqld]
port      = 3306
socket      = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M


My question is do the above settings represent 1G, basically I'm trying to get the max from my machine, ie: can I go higher ?

PC 3ghz running 2g
_________________
What is Pay Per Play ?
Back to top View user's profile Send private message
admin
Site Admin


Joined: 03 Mar 2002
Posts: 1295

PostPosted: Mon Oct 08, 2007 3:59 pm    Post subject: Re: my.ini 2g Reply with quote

Marty_,

The above settings are good for a computer with more than 1GB. But the best is to run some tests on your specific database and scripts to know whether such a configuration really inceases the performance. In some cases, giving high values for some parameters can have the reverse effect and will worsen the speed.
_________________
Follow @abyssws on Twitter
Subscribe to our newsletter
_________________
Forum Administrator
Aprelium - https://aprelium.com
Back to top View user's profile Send private message
Marty_
-


Joined: 21 Feb 2006
Posts: 55

PostPosted: Mon Oct 08, 2007 4:29 pm    Post subject: Re: my.ini 2g Reply with quote

admin wrote:
Marty_,

The above settings are good for a computer with more than 1GB. But the best is to run some tests on your specific database and scripts to know whether such a configuration really inceases the performance. In some cases, giving high values for some parameters can have the reverse effect and will worsen the speed.


I'm currently running the above settings and yes it has improved my page load times.

I noticed(later) that the 4g settings are similar for some settings so I guess I can tweak the rest ie: some are 4times higher and some remain the same.

Thanks for the reply...
_________________
What is Pay Per Play ?
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
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
You cannot vote in polls in this forum


Powered by phpBB phpBB Group