View previous topic :: View next topic |
Author |
Message |
Marty_ -
Joined: 21 Feb 2006 Posts: 55
|
Posted: Mon Oct 08, 2007 10:12 am Post subject: my.ini 2g |
|
|
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 |
|
|
admin Site Admin
Joined: 03 Mar 2002 Posts: 1298
|
Posted: Mon Oct 08, 2007 3:59 pm Post subject: Re: my.ini 2g |
|
|
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 |
|
|
Marty_ -
Joined: 21 Feb 2006 Posts: 55
|
Posted: Mon Oct 08, 2007 4:29 pm Post subject: Re: my.ini 2g |
|
|
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 |
|
|
|